Search results for query: *

Thanks Shaun for your answer. I do only need read permissions from the second DB. I have tried the RunPermissions option but I still cannot get access from the second db/workgroup. First of all I cannot link to a query I can only import and import doesn't work as I still don't have...

Try adding this sub routine: It works by looking for the first week in April with a monday and using that as week 1. I hope this is ok. It will calculate this depending on the year. i.e 21/04/03 = wk 3 as 07/04/03 = wk 1 07/01/2003 = wk 41 as 01/04/2002 = wk 1 Replace all date_tb with you...

Hi Easier than that. Have another text box with the DateRec field as the Control Source. Under Format choose 'ww'. This will convert the date to the week number. Alternatively use Datepart("ww", yourdate) Regards, Gary

Hi, Access 2000 I have 2 databases with largely unrelated info and therefore each database uses a different workgroup file. I need to link one table, but I can't because that workgroup doesn't have permissions for that table. I usually use "/wrkgrp c:\secured.mdw" on a shortcut to...

Thanks Brad, The first one is quite useful. Unfortunately, I do not need to know who has a file open I need to know when a user has another record open and therefore locked in Access. Someone must know....please. Gary

I need to find out using vbcode when a record is locked by another user. The record indicator has this info but where does it get it from? Basically, I need to be able to create my own error message of: "Could not update, record currently locked by 'user' on machine 'xxxxx'." Could...

Please help, I have been packaging an Access 2000 database successfully for about 6 months. I have now created a new database which I am trying to distribute. However, each time I click on finish and it tries to write the setup.lst file I get the error "Unexpected error number 28 has...

Hi, Sorry about the 2 questions, but I have only just found this site while tearing my hair out on the web. ACCESS 2000 1 - Using the Package & Deployment wizard I have distributed a program many times without problems. Recently, though when deploying onto two win 2000 machines it says it...