Search results

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

I was Comms & Sy Grp UK, 651 Sig Troop (Borneo), 13 Sig Regt, Sig Troop (Berlin), 226 Sig Sqn, 9 Sig Regt, 321 EOD Unit NI, 14 Sig Regt, 3 Sqn Berlin.

Hi Trevor I was in from 1962 to 1995 Which Unit were you ?

Why not do the Mail Merge in Access by creating a Report?

Hi Michael The Report is the least of your problems. You have no true relationships set at the moment. You are using Table Lookups which should not be used. If you try to set Referential Integrity between your tblWorkOrder and tblEmployeeLine you will get the error shown below.

Hi Are you able to upload a zipped copy of your database?

Can you show us a Screen Shot of your Table Relationships?

Hi Magger Do you have an example of the tests to be carried out on each of the TestTypes Basic,Standard & Premium?

I agree Gasman, definitely suspicious.