Search results for query: *

Hi, I must be making this much harder than what it is, but I am having problems try to write some code to update data in a table through VBA code. Here is what I as trying to do. I have a process where I Import data from another location. It gets dumped into a temp table, from there is gets...

Hi, I am having a devil of a time trying to get MS Access to quit. I have an Access application that uses a work group file for the security, I don't think that is the cause but I just want to throw that out there. Anyway, when I go to exit the database appears to close, but then an empty...

Hi, I am trying to populate a listbox on open event based on a crosstab query. Here is my code. My question is, can I can I make the number of column dynamic based on the results of my crosstab? Second, how can I get my columns to display correctly. Any help would be great! Private Sub...

Can anyone answer this question of mine. I would like to define the size of paper for my report. My users need it to have it print to 11x17 inch paper and display it on print preview. I have it opening up in landscape just fine, but my users now want it on 11X17 inch paper. If and one has...

I would like to use Continuous Forms layout on my form. However, for each record I want it to have its own list box. For instance, I have a date picker. The user picks a date and all data all the records for that date appear. However I want to display more information, for each record that...

I am not sure how to word this, but I have an drop down menu that is actual an ActiveX Control calendar. I can't figure out how to requery a sub form after the user selects the date from the calendar. Basically I want the user to be able to see data this has the same date that is selected from...

I was wondering if it is possible to open a report in word using a template. Some of my formating on my report isn't making it when I publish it in word. So is there some code I could use telling access it open it in word using a specific word template. Or if anyone has a better idea on how I...

I am trying to format a feild in a table that will accept only minutes and seconds. Like a stop watch. I need access to see the values as minutes and seconds so I can do calculations in other parts of my database. I tried the nnss like the helpl file suggested, but when I input a time of 12:30...

I am trying to write a query that will return the two most current dates in a table titled Fitness. Here is what I have so far. It will return the most current date, but I can't figure out how to get the next date after that. SELECT Fitness_Test.Member_ID, Max(Fitness_Test.Date) AS MaxOfDate...

I need some help, I would like to either write a SQL statment in module or run two queries I built. I think the SQL statment is the way to go though, but don't have much expeirence with it. Here is my problem, I want to add a record to a table if a certain condition doesn't exist. For example...

I am trying to calculate time using datediff. However I want to know the hours to the tenth between two dates. The dates I have in my database are date and time together. example Start 1/01/04 10:20:34 Stop 2/01/04 9:20:34 Now I want to know the time between the times. This example would...

I was wondering if anyone knew how to write an event that on opening of a report it will display it in word or rtf format instead of access. I am trying to use the following code but I get runtime errors. Private Sub Report_Open(Cancel As Integer) DoCmd.OutputTo acOutputReport, "unit Report"...

I have created a Calendar using calendar control 10.0 to open from a combo box. I was looking up how to do this at www.fontstuff.com. So far everything works great, but I can't get the Calendar to pass the date to the combo box. The Calendar opens up with the current date selected but that is...

I was wondering if anyone knew how to make a report open in word, using a word template I designed. I have a report that is sent to Outlook as an attachment as a Word Doc. However, I want it to open up in as specific layout. For instance I want my company's letterhead to appear, and I want...

Here is my question; I hope I am making it clear. I have a report, which I want to insert a date for the up coming weekend. Here is the scenario, Every week I pick a group of individuals who have to come into work on the weekend. I have a report that has the individuals who I pick from a...

I am trying to open a report based on a selection from a list box on a form. I don't know if my code is way off or my query is is way off. Here is what I have so far, which is what I got from an old thread from last year regarding this problem. my form is called ind_fit_test_report my report...

I am trying to open a report based on a selection from a list box on a form. I don't know if my code is way off or my query is is way off. Here is what I have so far, which is what I got from an old thread from last year regarding this problem. my form is called ind_fit_test_report my report...