Search results

The GetOpenFilename in excel works like this: theFile = Excel.Application.GetOpenFilename This pops up your system file directory and lets you browse for a file. And then sets your object (theFile) to the filename and you can do whatever using the filename (open, save, etc.). WORKS GREAT in...

The Problem The problem is when you created the form. Access gives you 3 different actions that the form can act as. They refer to what it does to your table. Make sure you have the right one selected. I know that this is true for Access 2000. Not sure about the others.

I think so.... I believe the problem is the Me. Me points to the form currently active or the form with the "focus". All you need to do is include some code before the requery code that activates the subform. then use the "me" after that is the active form. Otherwise the requery is working, but...

Send me your email send to Daxton.Allen@firstamericanplastic.com I made a simple db that will make this work for you. Get me your email and i'll send it to you.

OK I have a simple database made that works. Give me your email and i'll send it to ya.

Just a shot in the dark but.... do you have the record numbers as a field?

Hi You turn it off by right-clicking on the key on the table.

Try it anyways I dont believe you have to have it in there. Take and turn it off on the table. And try it. Then if that doesnt work then try turning it off on your query as well. I am far from being an expert. I'm just saying try it for poo's and grins. ;)

HI Try using this Between[Enter Start Date]and[Enter End Date] This will let you specify the range to use.

HI see what happens if you dont have the primary key. Meaning take it off.

A parameter query is easy to create. Simply place what text you want the popup to prompt the user saying. For instance: If you are needing to get a set of records for a certain date range (say by month) In the criteria cell, you type: Between[Enter Start Date]and[Enter End Date] It's...

If an excel spreadsheet is open already or if the worksheet that is going to be used is already open within the workbook before i output my query. Any suggestions on what code to use to test for these open sheets. Thanx, Daxton Allen

Thanks for the help so far fellas The filename is going to change everytime. It has to. I need to be able to catch the filename that is typed in the dialog box. Any idea on how to do this. Im doing all of this using the OutputTo Statement. If you leave the filename blank then it will prompt for...

10-4

Try this Instead of using text boxes. Use Combo Boxes to list the available products and descriptions and price. And reference those in your query.

I am using the OutputTo Statement. When i leave the filename to Output to....blank, access prompts me for the file, this is good, that's what i want it to do. But lets say i want to then take and open the file in excel. How would i code that? I know that i somehow have to set an object...

I am using the OutputTo Statement. When i leave the filename to Output to....blank, access prompts me for the file, this is good, that's what i want it to do. But lets say i want to then take and open the file in excel. How would i code that? I know that i somehow have to set an object...

I am using the OutputTo Statement. When i leave the filename to Output to....blank, access prompts me for the file, this is good, that's what i want it to do. But lets say i want to then take and open the file in excel. How would i code that? I know that i somehow have to set an object...

I am using the OutputTo Statement. When i leave the filename to Output to....blank, access prompts me for the file, this is good, that's what i want it to do. But lets say i want to then take and open the file in excel. How would i code that? I know that i somehow have to set an object...

When using the DoCmd.OutputTo Statement, What is the correct code to use for the Output Format. Say im outputting from a query to Excel spreadsheet. Ive tried .xls, *.xls, (*.xls), "*.xls", ".xls", etc. No Luck yet. If anyone could help with this matter. It would be great. Thanx, Daxton