Recent content by JohnN2006

Hi, I am using the following piece of code to allow users to update their databases. Basically I have 5 users who all have their own databases in different locations. To save them from having to email the databse, me completing an update and then emailing it back I have written an "updating...

Dan, Thanks very much for the advice - works a treat !! For some reason when using the code, you are not prompted to overwrite the existing object it just does it automatically. But hey as the saying goes "If it a'int broken, dont try and fix it !!" Thanks again for quick help on this.

I was thinking along the lines of sending them another database file which would have all of the new forms and reports. They open up the update file and get a button saying "click here to update" this will then import the new items into their current database. On the users current version of...

The people who are using the front end databases are how shall i say it - not very computer literate. Is there a way I can run the export function using vba ?

I have written a couple of databases that are now being used by several different Offices all over the place. Is there a way I can export forms, reports etc so that I can carry out updates without having to have all of the databases emailed to me and amended seperatly ?

Right fianlly managed to sort this out, had to remove all office applications and then delete all registry items that related to Office. Followed by a complete re-install of Office. Still dont know how this happend ! Hope nobody else has to go through it, just wanted to say thanks to the people...

Right even further mystery to contend with. I can right click on the toolbar and perform customisation on the toolbars. I just can't right click on the database window.

I have reset every toolbar listed but the problem still remains. I have even tried removing all office components and the deleting access items from the registry.

ghudson, It's definatley not yout code that is causing the problem. I have to run your code to enable the right mouse click ! I was looking at the following code last week and lost all toolbars, when i restarted access the toolbars appeard to be back to normal, could this have anything to do...

I have been using the sendkeys command quite alot over the last few projects I have worked on - why should I avoid using it and what are the alternatives.

I have done a total reinstall of Office but still no joy.

Thanks for the quick reply RG but it's stil not working. Even when I open up a blank database and create a new table and then try and right click on that I still find that right click is disabled.

Hi, Somehow I have managed to permamently disable the right click on my version of Access. I have been trying out numerous amounts of code to amend toolbars for a custom application that I am building. But I though I had reversed them all. Luckily I have the code to enable the right click...

ghudson - again a simple answer from me, if you hide all of the objects from their properties window then they cannot be imported or linked to. I would recommend setting the properties using vba on the opening screen and by using the AllowByPassKey property the end user should not have access...

Hi, I have been looking at the same sort of thing as well. As my VB programing isnt that advanced I have manged to achieve the same effect using forms and simple vb code. I have enclosed an example. The first thing to set up is the Expiry Date within the Expire table, the Expiry Status...