Search results

Hi Does the Report now give you the correct result?

Which Report are you referring to and what data are you expecting to be displayed. First look at you relationship diagram shows that there are no relationships set between any of your tables. You are trying to retrieve data from Investments01_tbl and Investments_Puchases_SalesT where you have...

Hi You can download the Google Docs file into Word and then zip the Word file and post the zip file.

Hi Al It looks like you do not want to take good advice. If I were you I would re-read all posts again to see where you are going wrong.

Hi Al Are you able to upload a copy of your database with no confidential data?

Hi Al Why not just do the Merge into an Access Report?

Hi Are you trying to add New Referral details for the Patient Details obtained via your Search Form ?

Take a look at your exact same question on AccessForums. I have given you the correct method of solving your problem.

From your screenshot it looks like you have created a database for each table. All of your tables should be in one database.

Sorry but your explanation makes no sense to me at all.

The AuthorizationEditF Form opens. Do you want the unbound Controls which display as Grey Colour to be enabled to Edit??

What is the name of the Form that you have the problem with?

I think a more detailed description of your process is required. Does 1 Customer have 1 or more Projects and each project can have 1 or more Job Sites?

Glad to help

Hi My apologies but I missed the fact that you want all items to be added in the order that they were in your tblChecklistDetails. I have modified the process so that now you just click on the Command Button "Add All Items" Does this suit?

Hi There will probably be a better way of doing this but this is one way of doing what you want. On the Form that opens when you use the "Trade" Combobox and select a Trade, then all related Items will be inserted into the Subform.

Hi Sorry but you are not following what I am recommending. You cannot add data to a Continuous Form until you add a Record in the Main Form. Pat Hardman has pointed you to a solution but you need to get this First Major Step created before you can add the Multiple Items.

Hi Your tblCheckListDetails which is the many side of the Relationships contains 58 Records with no Parent Records. This is not how you would manage your process. You should initially enter a record in tblCheckList and then add related records in tblCheckListDetails. Looking at the data in...

Is this what you are after?

Hi David If you think about your process, you are trying to record information about All Games played in a specific Season. So to get you started if you look at the relationships in the revised Relationship Diagram you will see that I have removed all of your current relationships. I then...