Search results

Use after "update event" on the Form not the table. I would use VBA rather than a Macro.

As a general rule I split when I am close to release. Once you give access to users you really have no choice but to split. All users must have their own copy of the front end (Normally located on their own machine) with a link to the backend on the server. Can you explain this a little...

This looks to me like the Form has been imported/exported. Other than that I used to have the same problem but it has not occurred since I stoped importing. This was many years ago that I had the problems.

It looks like we are all in agreement here. Use Auto Number as your Primary Key. This will identify records with a unique number. Then for sequential Numbers like Invoice number use the function DMax plus one. You should be able to find this in the archives or do a Google Search. I have a...

Dave Would you not think that the problem can be solved. After all we have not proven that it is corrupt. He has not complained about the normal errors that you would get with a corrupt DB. No report of corrupt files in tables. No reported error with a compile. We have not done a decompile...

I get my name because I am a Red Head. This is the land from Down Under. A bit hard for you guys to understand.

One of my nick names is "Blue". It is not uncommon where I come from. Blue is also a common name for a certain breed of cattle dog.

I still believe that there is something wrong with the code. Can you post a copy of the DB. If not then the latest code plus an earlier version before the major code. We should be able to work it out from there. This is a very good lesson. Personally I could make 20 - 40 copies in a day...

It helps others if you explain the solution

Use the query builder. Select the Tables you want making sure the join is correct. Then bring down only the fields in order that you want. You may need to include the Primary key and set its width to zero so that it cannot be seen.

Are you sure that this works. Suggest that you test again with all possible options.

If you read the code it may still be referring to Command1234 instead of CmdcClose. Marian may also be correct. So both may need attention.

You have a Table called Pupils. It has two fields the same. "ID" You are not allowed to duplicate a field in the same Table..

Auto Number is fine to use as the primary key. Your Foreign key would then be a Long Integer Age should be DOB as this can be calculated each time you use it. Is there a Table for Survivor or some other person who may be in charge, If so I think you can relate the other tables to it. However...

I have been away. Sorry. The Criteria for this expression is simply the "Location" e.g. 0217. Go back to your query and select the fields that you require. Then on the line that says Criteria go to the field Location and enter 0217. This should return all the records where the criteria for...

Jeff What's happening. Did you solve the problem. Don't forget that we are here to help

This would in my opinion be the best plan, based upon the information you have given. That is unless you have a problem with your Primary key and its joins.

You keep referring to a Graphic. I am not familiar with this term. What does it mean. Also what version of access are you using.

I was wondering if this was the smartest way. There is always more ways to skin a cat. Mine was a suggestion. Do you have another idea. You have not given any information of why your DB freezes. What else have you got that is important.

Have you gone back and found the fault? Hint. Start small get that working before adding something else. One step at a time. BTW Turning Warnings off. Why have you done that. If there is an error you need to see what it is, not hide it.