Recent content by simon mills

Good morning everyone. Im stuck and wondered if anyone could help. I have a database that opens other database at set time of the night. When the databases open at specific times they run lines of code designed to keep day to day admin to a minimum and use the quiet networks as they as fairly...

We've had a similar problem here. What we did was to put a "locking" button on the database with all the data in it. Then we set up a lookup database, which was exactly the same as the main one, but had link tables. The main database would then export a simple, small table when the "locking"...

Thank you so much. I had to change the quotation marks slightly but it now opens it on call. Call Shell("msaccess ""u:\team-shared-data\Res. Sales\Outsource\Outsource_Dbs\Database_Store\Outso urce.mdb"""). Thanx again, you have just solved something in the blink of an eye that has been...

Hi thanx for looking. Im still getting the same error ... "The command line you used to start microsoft Access contains an option that Microsoft access doesnt recognise. Exit and restart Microsoft access using valid command line options" When you click ok it pops up 3 more times, it the...

Hello. I have a database that runs a fews tasks for me me when no one is in the office as the systems are quicker and the admin work tedeous and boring, yet necessay. The problem Im having is in calling a database. The problem stems, i think, from the names on the folder. Unfortunately renaming...

Thanks for the links. I will take a look through each. Another thought presented would be to change the query to a make table query query and have an auto number on that ...... But if these work better and quicker because its all done in one then great. Thanx for your time in helping. I will...

I was completely un aware of the assumptions that access makes. I have used a hidden text box and then =format(cdate[],"dd/mm/yy") - this appears to be working now. The cdate alone didnt, but after the format it started too. The test will be on going to ensure its working. Thanx again for...

I know he's right, but as it wont effect us again till 2100 Im not overily concerned :o i'll be in a box or 115, I just want my database to work. :cool: Sorry, its too early for humour, on a serious note, I have tried the Cdate function and then to format the resulting date into dd/mm/yy...

Hello everyone. I have a multi user database that is used across 2 sites. In one of the sites the regional settings for 'short date format' is set to dd/mm/yy - the other site its set to dd/mm/yyyy. All the data that its the tables are set to dd/mm/yy. When the second site try to use the reports...

What do you mean by lock up? Sorry - this access thing is newish still I have a database that only I have access to on a seperate server. I maintain that. I then have a smaller lookup version that has 2 linked tables, and a few forms/reports etc. On one form there is an exit database button...

Hello. I want to prevent people accessing the control boxes on a 'satalite' mdb. I have hidden the control at the top through the start up options, but havent prevented the special keys as I occassionally need to get in this database for error fixing and such like. I want to know if I can put a...

Thanks for this - Im now going to try to persuade my IT manager to get it :rolleyes:

Can this be done ?? I have a query on a timer that basically looks at a linked table every minute and tells me whose in the database. I want to number the rows in a column so I can reference this to a form that has 7 spaces. The number of 'users' could vary from 0 - 23, although this will soon...

Hello all. This is my first post on here after reading many of the other threads as I try - often in vain - to pick up access. I am in the process of building a couple of databases, the main one being one that is an amalgamation of 4 other/older mdb's. All tables/queries etc were simply...