VBA-help

[Gunnar Petersson]

Hi,

I have some more complicated things (for me) that I want to do in an
Access survey database. I'm totally new to VBA-syntax and I don't have
time to dig into it to much. I would appreciate any advice on the
following things that I want to do:

1. Run an external Java-progam with control of that it must be ready
before executing more code (polls mailbox and downloads encrypted
files)

2. Empty the ImportErrors Table

3. Read external file names and put it into a "macrovariable"

4. Run external program for decryption with the filenames from step 2

5. Save to another subdirectory

6. Load XML-files into Access tables (I have managed loading one but
how to load every file in a directory?)

7. Save loaded files to another subdirr

8. Count the number of files addes

9. Count the number of records added

10. Manage/trap different kind of errors

Thank you,

/Gunnar

[Salad]

Gunnar Petersson wrote:

Hi,

I have some more complicated things (for me) that I want to do in an
Access survey database. I'm totally new to VBA-syntax and I don't have
time to dig into it to much. I would appreciate any advice on the
following things that I want to do:

1. Run an external Java-progam with control of that it must be ready
before executing more code (polls mailbox and downloads encrypted
files)
Will ShellExecute work?
2. Empty the ImportErrors Table
See delete queries in help.
3. Read external file names and put it into a "macrovariable"
See the word Dir in help
4. Run external program for decryption with the filenames from step 2
See ShellExecute. Goto http://www.mvps.org, AccessWeb, APIs to see how
to shell execute using API calls if you want to open a file by association.
5. Save to another subdirectory
See FileCopy
6. Load XML-files into Access tables (I have managed loading one but
how to load every file in a directory?)
See Dir to get filenames
7. Save loaded files to another subdirr
FileCopy?
8. Count the number of files addes
cnt = cnt + 1?

9. Count the number of records added
Will you use an action query called by Execute? Then see
RecordsAffected. Otherwise get a beginning count, run query, get ending
count and subtract.

10. Manage/trap different kind of errors
On Error GoTo Err_routine

Err_Routine:
select case err.number
case 123
...code
case 456
...code
case else
end select
Thank you,

/Gunnar

[Salad]

Gunnar Petersson wrote:

Hi,

I have some more complicated things (for me) that I want to do in an
Access survey database. I'm totally new to VBA-syntax and I don't have
time to dig into it to much. I would appreciate any advice on the
following things that I want to do:

1. Run an external Java-progam with control of that it must be ready
before executing more code (polls mailbox and downloads encrypted
files)
Will ShellExecute work?
2. Empty the ImportErrors Table
See delete queries in help.
3. Read external file names and put it into a "macrovariable"
See the word Dir in help
4. Run external program for decryption with the filenames from step 2
See ShellExecute. Goto http://www.mvps.org, AccessWeb, APIs to see how
to shell execute using API calls if you want to open a file by association.
5. Save to another subdirectory
See FileCopy
6. Load XML-files into Access tables (I have managed loading one but
how to load every file in a directory?)
See Dir to get filenames
7. Save loaded files to another subdirr
FileCopy?
8. Count the number of files addes
cnt = cnt + 1?

9. Count the number of records added
Will you use an action query called by Execute? Then see
RecordsAffected. Otherwise get a beginning count, run query, get ending
count and subtract.

10. Manage/trap different kind of errors
On Error GoTo Err_routine

Err_Routine:
select case err.number
case 123
...code
case 456
...code
case else
end select
Thank you,

/Gunnar