Search results

The effect it will have on the other tables is that it will reset all their autonumbers to the next available number. So if you have an empty table, the next available number is 1. If you have a table that has 2059 as the highest autonumber value being used, it will set the next available...

I moderated another MS Access forum until I was given administrator rights (the owner was extremely busy and wanted a backup). Our main purpose was to keep the forums "clean". You know, move posts to their proper location, clean up the posts when members do a bad job in posting (i.e. forget to...

If you are using Excel Automation coding (which from your coding it seems to be an accurate assessment), the verion is determined by which Excel Object Library you are bound to in your References. Excel 2002 is Version 10.0, Excel 2000 is Version 9.0, and so on. If you run an Access 2000...

I can't remember where I got this code but I believe it was one of those VB Snippet sites. But I have attached the code behind a module I use to map/unmap drives using UNC paths. The method ConnectUNC will not only map the drive but it returns the drive letter it created so you can know what...

Along the lines of what Autoeng suggested, I have been using a "portal" database solution. Basically, the user lauches what they think is the database they want to use, but really it just copies a couple files to their harddrive and then launches the database. It copies the front-end .mdb and...

Wicklund, Unfortunately, the manner in which I did this would be hard to put into a demo fashion because it doesn't do much good without data to back it up. THe data is confidential in nature and would surely get me in a load of trouble. My suggestion would be to do a search on Excel...

I ran into this problem on a previous assignment. The client wanted a version of the Access Report in Excel and wanted all the formatting to be the same (colors, bolding, alignment, etc). Since I don't like to have things scattered about and like to keep everything centralized to my MS Access...

Marvet95, I'm not sure what version of Access you are using, but in Access2000 you have the CurrentProject object and it has a method called Path. So if you use CurrentProject.Path it will give you the full path to where the database is being run from. So if you make your images folder a...

bdj, I don't know if this help or even points you in the right direction, but you can link to your Address Book in Outlook. In the table view of the Database Window, click on the New Button Choose 'Link Table' You should get a Dialog Box. In the 'File of Type:' dropdown, choose 'Outlook()'...