Recent content by Trigon

Thanks, only just got round to looking at this and it worked a treat!! :-)

Anyone...?

Hi All I'm having problems trying to get this to work. When selected by the user I have set our system to push data out into excel, I have then wrote a macro in the spreadsheet that it pushes to ask into to run another macro in access, which then imports and opens forms with it etc. The...

Hi Im trying create a new form to add our current database that will password protect excel, word and if possible pdf documents when they are dragged onto it. For now I only have 2 boxes 1 containing the password to be applied and the other to drag the file onto. I have it all working so once...

Would it help if I called it from the other backend after that one has done its thing and fully closed?

I was thinking of just calling it database.mdb as its hidden away from everyone anyway. But I assume it will then start calling it database(01).mdb instead and run into the same problem.

Hi all After following the advice from a previous thread (I cant link as i haven't posted enough). I now have 2 backends, 1 imports data then uses queries to add new items to the other main backend. It then removes the data and compact and repairs ready for the next run. This works fine but...

I've just tried it on a test version and realised that it doesn't let you :-(. It looks like option 3 is the way to go then. I can see people getting annoyed if I kick them out every night.

Is there likely to be major problems if I was to compact and repair while people are in it? I could get this running every night say around 7pm but people leave their machines on all the time and stay in things so they can work from home. Thx

Nope its not a medical condition. :) I have created a split database for users to keep control of their daily work targets. I have 3 tables Import, Old and Current. Data is imported into the database from the system into import, a query works out what cases are missing (finished with) and...