Search results

INSTALLATION PART TWO It is better than a good Idea to make regular back ups. Suggest something like a dozen or more an hour. ChrisO wrote this. D:\Shared Folder\AutoBackup.rar Naturally this link will not work on your machine. You will need to download your own version. More tomorrow.

INSTALLATION PART ONE Assuming I have completed writing and tested the database. Written in 2003. For the CLIENT Create two separate folders. C:\Roger C:\RogerInstall Place the Database front end "RogerFE.mde" and a Text file Token.txt under C:\Roger You may prefer to use a .mdb version...

Ranman256 Thanks for the input. You may have missed it but I am trying to make this thread exclusive so that I can write my solution progressively as I develop it. The original thread is still open if you would like to continue with that one. The Address for the original is...

I have created my own reply. It will take a while to complete. http://www.access-programmers.co.uk/forums/showthread.php?p=1439744#post1439744

This is an old thread that I have been trying to find the time to write an answer. The original question is located here. http://www.access-programmers.co.uk/forums/showthread.php?t=272900 I started a new thread so as not to get confused with other people's posts. I first wrote this about 3...

If it works and you are happy then that is good. If you don't want to post a copy then that is fine. Maybe latter if you run into problems. For now it is good luck with your project. Bye.

That could very well have been the problem. Thanks.

vba Last night I was having problems. Tonight all is good. Your sample works like a charm. I have no idea what happened.

I do not understand why you say "otherwise table will created the same records for the same value of 3 fields:" Can you explain your thinking here. To have the ID inserted automatically you have a Form with a Sub Form. The Main Form holds the ID and the Sub holds the Foreign Key...

What are you using as the ID. Is it Auto Number or what. Could you please explain your relationships. There are two way of doing this and only one is correct. What have you used. Could you post a Pic of the Relationships or if you prefer post a cut down version of your Database.

vba I will give it a rest for a while, Post 30 does not work for me????

I hope you all realise that what I posted was mainly for light entertainment. Even though it is based upon reality.

Make the other fields unique by giving them an index with no duplicates.

If you look at the Relationships window you will see that a Primary Key can have more than one link to another table. You therefore cannot delete the Primary Key as it is required as part of a relationship with other records in the related table. The Primary Key therefore must not be...

For Clarity. What you have is a Normalisation problem. Because MagazineYear and MagazineMonth REPEAT then any table that uses these values should be getting the value from a Table where they are listed once. This would be a One to Many Relationship. I would have an Auto Number as the primary...

I do believe I understood correctly. You need a separate Table to store unique values.

Let's see what the Mods think.

The Record Source is incorrect. Try This SELECT TabellaJoinPIP.IDPIP, TabellaJoinPIP.DataPIP, TabellaJoinPIP.Seleziona, TabellaJoinPIP.IDAnagrafica FROM TabellaJoinPIP;

For now forget the Button. Does the query work by running it manually.

Create a separate Table to use as a lookup. EDIT. If the choice is Not on the List If the choice is No on the List when you use the Drop Box then there is some come to help add a new on. You should be able to find it with a Google Search. If not I can find some code for you.