Recent content by Sony170

I created an Excel file using: DoCmd.OutputTo acOutputQuery, _ "Compile_Query", acFormatXLS, _ "G:\ServiceCompany\SanDiego\Warehouse\LCDLine_Summaries\Daily\" _ & DateMonth & DateDay & DateYear & ".XLS", False However, after creating this excel file, i want it to automatically...

we've been testing out the sendkey method for a week now, and it still isn't consistent enough of a solution; sometimes the fields would be offset and the wrong keys are sent to the wrong field, or in the most odd cases, you see the cursor jump from field to field, but nothing gets filled out.

There is an online form which we need to fill out for each of our inventory units. This form has several dozen fields though. We have to fill each one out for every unit that we ship (which is about a hundred a day). But the good news is, about 25 of these 30 fields are always filled in with...

that's SICK, it works!!!! :D ty

This is my search criteria: John, blank, blank, blank, blank I want it to return the following records: 1: JJohn , data, data, data, data 2: johnny, data, data, data, data 3: john, data, data, data, data 4: john, blank, blank, blank, blank for some reason, it is not returning Record 4. I...

Here is a link that will help: http://www.access-programmers.co.uk/forums/showthread.php?threadid=36145&highlight=multicriteria scroll down to the database written by Candace Tripp and download it to your computer and give it a whirl to see if it does what you want

I have a database consisting of one table with 5 columns, called Name, Zip Code, Model, Serial #, and Reference # I made a form with 5 text boxes (generically named Field 1 through 5), and then I built a query. I put all five of the table's fields in the query. In the criteria fields of those...