Search results

Hi, For some reason when I set the focus to a text box in the subform it clears the textboxes there. First I set the values of 2 of the textboxes in the subform programatically. Then I tab to the last control in the main form. This is the code I have in the lost focus event of that control...

He actually has Access 2000 installed and it was developed in 2003. I will get him to upgrade - otherwise it will cause problems if everyone has different versions installed. Thanks Ghudson!

Hi, I have been installing a database on computers and it is working fine exept on one of them. I have copied the front end and the back end onto the users computer in each case. Both the front end and back end are MDE files. On this one I am getting the error "The Visual Basic for Applications...

Hi Len, Thanks for the reply. I do have 2 different start up screens for my 2 groups. Thats the only way in which the front end is different for the 2 groups so it will be easy when updating it. Depending on which group the user is in they have different permissions. The larger group of users...

Copy backend to users local drive instead of replicating Ok, think I've found the best solution.. I can just distribute a bat file to each of the users that will copy the backend of the database from the server onto their local drive and open the database. I don't need alot of the features of...

Please let me know what you think. Need to get this installed on everyones computers today. I will have 2 main groups using it: One group (about 3 or 4 people) who will need access to the full thing - I was going to link their version to the master version. The second group just need a few of...

Also, if I do create partial replicas should I store those on the users local drive along with the front end? I will also have 3 or 4 users who would need to have access to the full version. Should they be linked to the master copy on the server..?

Hi, I've been reading about this alot today but can't decide for sure if I should replicate my database or not. The users will have a front end installed on their local drive and the back end is on a shared server. Basically the users will not be able to add or delete records. However, they can...

OK thats fine. I'll do that. Thanks very much for your help. Wasn't wasted time anyways cos I learnt alot.

I just realised that I need to tell it the field to search: OrderNum: IIf(IsNull([PartNum]),[OrderPrefix] Like "67081*",[OrderPrefix] & [PartNum]) I see what you mean about the wildcard effect not working though.. The data I require is in the the PartNum field for the other records but as this...

Nearly there.. Hi Len, Thanks a million for that. Its exactly what I was looking for. This is what I have now: OrderNum: IIf(IsNull([PartNum]),[OrderPrefix] & "*",[OrderPrefix] & [PartNum]) It does evaluate the condition properly but the wildcard search doesn't work propperly. The following...

Hi, I have a calculated field in a query that concatinates an order number prefix and the part number to give the order number: OrderNum: [OrderPrefix] & [PartNum] There are 2 tables: tblPartsList PartNum PartDesc tblPartsListCategories OrderPrefix OrderNumCategory This works fine except for...

Don't really understand why you need to have this information in a spreadsheet? By the way, you can delete posts if you accidently posted it a few times by going to the post and clicking 'edit' below your message.

Anyone have any ideas? Maybe I should set up a special user with full permissions and put that username and password in the code? I will make an mde file so no one will be able to see the code anyways?

Connect to secured Database through ADO I have the same question. I have (finally!) secured my database. The back-end is located on the server and the frontend on the local drive along with the workgroup file. So I did all that and some of my code stopped working because I was connecting to...

Connect to secured Database through ADO I have the same question. I have (finally!) secured my database. The back-end is located on the server and the frontend on the local drive along with the workgroup file. So I did all that and some of my code stopped working because I was connecting to...

Shortcut works but how to prevent users accessing DB directly? Hi, I have a database with a backend on the server and a front end on the local drive. I've created a workgroup file called DrawingsDB.mdw and put that on the server. (I intend to put this on the local drive for each user having...

Found the answer Just found the answer to my problem - creating a calculated filed in my query. I didn't know you could do that - that will def be useful. This is the expression I entered in the field in the design view of the query: OrderNum: [OrderPrefix] & [PartNum] Hope it helps someone.

I have a database of drawings and each one has an order number. The order number is something like 67080 22. The first 5 digits tell me what category of drawing it is in and the last 2 digits correspond to the part number. These are the tables: tblOrderCategories orderPrefix description...

Hi everyone, I'd really like some advice on this. I have just finished a database I've been working on (thanks to everyone who helped me) and I just split it so that the tables are on the server and the front end will be on the users machines. Its a drawings register and many of the users will...