Search results

We are setting up automatic importing of data from excel sheets to access database. I want to code something in access that at the click of a button will find the correct spreadsheet (excel sheets will be numbered corresponding to the current Access record), will append data from specific cells...

Could you elaborate on that a bit?? Not overly familiar with the VB side of access. If I have a main database "CTS.mdb" and I want to attach code to an OnClick of a button on this to open a db called "CTS IT.mdb" that's in the same folder, what exactly would the code be? thanks

The databases are split - SQL2000 back end, Access front end. And the front ends are distributed to each user. And yes, deliberately, when make a change to one the rest are updated. This provides multiple copies of the same databases, an advantage if one goes belly up. It also makes for fast and...

No it works fine the way it is thanks, I'm not about to change our whole network database structure for the sake of some security messages. Can anyone supply the code?

I have a screen on my main database that has command buttons which open up various other mdb Access databases. All databases are in the same folder on each person's C-drive within the network, but the folders aren't called the same thing. The way I found before to open up a database from a...

I can't get that command to work. For info have one main Access db and several other smaller ones. They are all in the same folder on each of our computers but not all folders have the same name. So in the hyperlink I just have, "Database 1.mb" for instance and it defaults to looking for this in...

Just upgraded to Access 2003 - every time you click on a button assigned to a hyperlink (to another database within the same folder) it comes up with a security warning: "Hyperlinks can be harmful to your computer and data. To protect your computer, click only those hyperlinks from trusted...