Search results for query: *

Add this code before your "End Sub": DoCmd.Close acForm, "Form Name"

Use the "Transfer Spreadsheet" or the "Transfer text" command in the Actions menu of a new macro. F1 is very helpful for these commands but write back if you get into trouble.

You could try this but it's kind of silly: Add something to the end of the macro1 to let you know that's done. e.g. have it update a temp table (temptable!counter) with the old counter number + 1. Add a Loop statement that says: Do While temptable!counter = old counter number +1 Stage2...

I've seen where I've gotten "Out of memory" errors. Keeping the c:\temp folder clean helps this one.

kennedymr2, I may not be understanding your question correctly so please clear up the following: A.) This code does not wait until macro1 is done running before executing "Stage 2"? That's not what I thought would happen. B.) Can't you convert the macro to vb code? I would...

To convert field from alpha to numeric, use the function CInt([FieldName]). To convert field from numeric to alpha, use the function CStr([FieldName]).

We have an executable -- "Kill.exe" that does the following: KILL kills the application specified by a process ID, which can be retrieved from TLIST. Runs On Alpha, x86 Files Required for KILL KILL.EXE KILL Syntax kill [-f] {process_ID | pattern} -f Forces the process to die...

MSAccess97 should be able to import a tabular text doc. Instead of a link to a spreadsheet, you could set up an import macro that first deletes the records of the table and then imports the file.

I've had problems using DBLookup's in Views. Can you provide a sample?

Can't you create a new view with the information you want? Then you can use the Tabular structure.

Check under the "View Selection" formula to make sure that your view is not restricting the documents it shows.

You can create a new view with the information that you want to export. Go to the new view you've created and export it (choose "Tabular text" as the saveas type). Then you should be able to import it into MSAccess. Let me know if you need more detail or run into problems.