Recent content by elvanace1

This is the line: DoCmd.OutputTo acQuery, "TT-TRANSITION BOEING FILE-single", "MicrosoftExcelBiff8(*.xls)", "s:\it\exchange\Rocketdyne-SB_" & Format(Now(), "yyyy-mm-dd") & ".csv", False, "", 0 What am I doing wrong?

One last question. Is there a way to onit the headers info when writing the file?

When using the OutputTo (an.xls file)feature within a macro, is there a way to append an existing file instead of replace it?

Adding a second combo box to the form, using the control wizard and make sure you select the option to 'find a record in my form'works. Thanks so much!

I changed the field to a combo box and set AutoExpand to True - but that didn't work. Did I do it wrong?

No, the field in the form is locked so the actual data cannot be modified. I have a user that would like to just start typeing there search criteria. Then with every key-stroke have access narrow the search results.

Is there a way to sequentially search a form field? Meaning, is there a way to place the cursor in a specific locked field and begin typing the desired value (without Ctrl-F) and have Access start searching automatically? Thanks, Eleanor

That's perfect. Thanks so much!

I need to populate a new table from query results, but I need to include an autonumber field or new records number in the new table. How can I do this?

SELECT TOP 1 ... ORDER BY Rnd(Val([Any field])" is perfect! Thanks sooo much.

But if there is no purely numeric field, what then?

Rnd() generates a random number, but what if the table's index is alpha-numneric. How do you get a random record?

Is is possible to write a query that will select records from a table randomly?

This is brilliant! Thanks

Yes. I need to run a query every hour from within access. I cannot use the windows scheduler.