Search results

Can a person register for 1 Course only or do you want them to be able to register for 1 or More Courses??

Hi Your best layout for what you are trying is a Tabbed Subform. See the attached example.

Hi Simon Can you upload a screenshot of your table relationships?

Do each of the users have a copy of the FE on their computers which is then linked to the BE?

I take it you did not bother to look at the Manual on how to set up a questionnaire? This is one of the easiest ways to achieve what you need.

Hi The attached is one of the best examples of a questionnaire, which is what you are trying to achieve.

Hi I have corrected all of the points I had noted previously. I believe I have also updated all of the queries that run your Reports. See if the db now behaves as it should. Note there may be some objects that do not run as expected.

But as mention by Mike the Form dealing with Transactions is wrong. It needs to be fixed.

All of the items I listed are relatively easy to fix. Best to fix now.

Hi As suggested by Mike Krailo your Transactions Form should look like that shown in the attached screenshot.

Hi I have taken a look at the database and have the following issues:- Field names should not have characters ~$/-!"£%^&*() Each table should have a PK which is numeric and not text A number of tables have Lookup Fields which should not be used Unable to Enforce Referential Integrity between...

Can you upload a copy of the database?

When I opened the last version you sent it was showing the 2. As long as it is now sorted then that's great. Mike has given you a good modification to the Contacts subform.

Hi I found in the version you uploaded you had a reference to 2 backend files. I removed 1 of them and then relinked to the correct BE and all now appears to be fine Remember to relink the FE to the BE

Because the Job can have multiple Contacts you need a table related to the Job where you can record Multiple Entries. See the modified BE and the FE with the addition of a Main Form to record Site a Subform to Record Jobs with a related Subform to record Contacts.

It would make more sense to say: 1 Site has a Specific Job and each Job has a Specific Contact

Need FE as well please

Can you upload a copy of your db?

On The form where you are recording the Job details you would create a Combobox to Lookup the Contact allocated for the specific Job

Hi I changed the code as suggested Private Sub cmdAddLines_Click() 10 On Error GoTo cmdAddLines_Click_Err 20 If Me.Dirty Then Me.Dirty = False 30 If DCount("[MainId]", "tblLineUnitEntries", "[MainId] = " & Me.txtMainID) <> 0 Then Me.Undo 40 If MsgBox("If These...