Search results

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...

Hi everyone I have posted the same question on Utter Access The code I am using as as follows and I am getting the following error. Private Sub cmdAddLines_Click() 10 On Error GoTo cmdAddLines_Click_Err 20 If Me.Dirty Then Me.Dirty = False 30 If DCount("[MainId]"...

Hi June I amended the Date Construct to remove spaces.

Hi Everyone As usual it was my mistake again The initial I changed the SQL Code shown below and it now works just fine Dim strSQL As String strSQL = "UPDATE tblCurrentPastYears SET DateFrom = # " & Me.txtD _ & " # WHERE DateFrom is Null;" Debug.Print strSQL CurrentDb.Execute strSQL...

Hi June & CJ I am trying to get the date updated by using the following Code and cannot get the syntax right, Dim strSQL As String strSQL = "UPDATE tblCurentPastYears SET DateFrom = #" & 1 / 1 / [txtY] _ & " # WHERE DateFrom is Null;" Debug.Print strSQL CurrentDb.Execute strSQL...

Hi CJ Many thanks nad now you have pointed me in the right direction I will do the insert. Many thanks