Please guys don't ignore this one also, I am in a big mess I hope this forum shall sort me out How do make my access database(connec ted to vb 6.0.) add records automatically at the end month and also How do i make my Ms access database and VB to be accessed by any computer on a network . am using ODBC
-
-
Sounds like you have your work caught out for you...
What are you most comfortable in:
(1) VB
(2) VBA -
I comfortable at using VB 6.0Comment
-
Hello out there:
I am not too much of an expert myself, although I do alot of VB6 cutting and pasting routines and try several hours to get them to work, a very daunting task to say the least.
In your case you would most probably look into SQL statements. using SQL you can simply create a connection to your database (location on the hard disk) then select the data using the "SELECT"stateme nt and go on to construct a new table or even a new query if you will at the end of each month.
To make this happen automatically you would have to write code stating that at the 28th of each month (for example) you will run this query based on SQL statements and build a new monthly table and thus print it out and/or save it.
Go online and type in SQL reference, you might find the right code there.
Hope this was some help.
dComment
Comment