Search results

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

Hi Everyone I have a Form which has an Unbound Control named "CurrYr" to display the Current Year 2025 using the following. =Right(Date(),4) I then want to run an Append Query using the Code as follows: INSERT INTO tblCurrentPastYears ( YearClassID, StudentID, GradeID, ClassID ) SELECT...

Hi In the attached I have imported all of the relevant objects for the process of attaching documents related to a Specific Permit for a specific Plant. The Form that opens allows you to select a Specific Plant and add all relevant details for the Permit. Then in the Subform you can locate...

Hi The attached has a good calculator of DateDiff provided by @Pat Hartman

Translation Hi David Your question is not very clear. Does the employee number, name and other fields ALREADY appear on your second form? OR Do you WANT the employee number, name and other fields to appear on your second form? Whatever your answer is, what do you want to do once you have that...

Hi Can you upload your database?

Tom has given you an example of how to manage documents. Have you tried to implement it in your database? No one is actually going to do this for you.

Hi Because you have set your Primary Key in your table "Nalog" as Number means you have to know which is the next IDNalog number to use in the Form "Nalog1"

Have you tried just creating a Form based on the table "Nalog" ?

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

As the_DocMan says to display the Type change the Column Width of the Listbox as shown in the attached.

Hi Why go to all the bother of multiple Unbound Controls and Forms? Just create a Form bound to the Nalog table.

Was in Berlin then from 1985 to 1992