Search results

Your original question is a bit unclear. Can you re-explain in plain English.

If you use the After Update event it means that the data has been written to the table and most likely you are now somewhere different to where you should be. If you use Before Update then you can interrupt the code adjust it if required and continue on. Go to Google and have a little read...

Doesn't matter. It could come in handy another day. ;)

I had another go at it. 2007 is not the best for finding commands etc. If you go to Print Preview, Preview, you will see Shrink One Page there.

Doris Thanks for the help but this is an old post. Try helping newer posts. BTW I still have not solved the problem. There is a simple Button somewhere that says shrink to fit. I just cannot find it. Bring back Access 2003

I think I would love to go OS. I will let you know where she is and you can keep an eye on her. She speaks very good English as well as our local dialect

Hi Paul. My Daughter will also be there at about the same time. Could you afford a world trip at 25 years. Not ne. Welcome navi87

Welcome to the forum.

If you do as I explained in the previous post you will NEVER have a problem. If you make design changes because of other influencing factors then you will have nothing but trouble. If in doubt, ask.

A lookup table consists of two or more Fields. The first is Auto Number. Unique. Cannot be duplicated. This is the field that we copy into other Tables to use as an identifier. We use one only Field to identify a particular record. This is the Primary Key for this Table Other Fields. (Sample...

Use a Table that only has One One. This table is strictly a look up table. You must only populate it with unique records. If you have a reason for repeating ONE then that reason is wrong. So delete the second ONE.

Long time since I used this. I think it still works. The tables mean nothing. They are just there to link to.

This is the count of how many times you have been thanked. The top one is for when you thank someone else. Then both should be text. Also make the length/size the same. I use 50. Long time since I had a problem but I think they should be the same. Maybe someone else could comment.

For a Start "T" is not a Number. Typo I assume. If there are two fields then you can sort filter etc. on either should there be a need. You can Concatenate them when they are displayed. In the interim you have a bit more flexibility with separate tables. If you can't see a use, then maybe...

Think about putting the T in a separate field. I realise you fixed it but this may be of benefit.

Thanks for that. Very interesting. Do you realise that this question is over 2 years old. I can't remember what I did but thanks for going to the trouble of sharing your knowledge.

You have a few problems. Why do you want to write to the Main Form. It is unbound. Nothing will be saved. Also try making the names of everything a little tidy so we can tell what is what. Put tbl in front of Tables. qry for queries frm for forms etc. Do you think you could find...

The need to compact 50 records will be required every 6 Months or more. Just an educated guess. So I am thinking that this is a lot of time spent on something that is not overly important. See the attached for an Automatic Backup and Compact tool. very good for development as you can quickly...

Are you wanting to simply Requery the Main form or================= Do you want to change add some Data.

I don't know who came up with the word Normalisation. It is not very descriptive. The object is not to repeat Data. This is called redundant Data. If you had a business at a certain address and you sent thousands of invoices every month. Why would you repeat the Company's address thousands...