linking code from an external text file

[Jason Malatia]

We use the same code in an access mdb as well as on a webserver. The code
is written in vbscript

The code is exactly the same. Is there a way to link the text file that has
the code into an access vba module.


Thanks.

 

[Alex Dybenko]

No,
Also - Access VBA is not 100% compatible with VBScript

 

[tom]

I have a table with columns
"Jobs", "Cost-code", "Date", "Amount"
There are 200 K lines in the table.
Aprox 50 differnent jobs number with aprox 100 differnt cost_codes
What I trying to do is Group by Job and group by cost_ codes
Cost codes are 00-000
I want to group by Land = cost_ codes 02-???

Land = 02-???
Soft cost = 03-??? through 05-???
Finance = 06-??? through 09-???

Is there a way to do this?
How do I set up that Land as a column label and equals cost code records
(02-???)


Would like to do it using VBA which so far I can't get any where with it
Can you get me started with what would be need to create groups by land,
Soft costs, & finance.

Thanks
Tom