Search results

Hi, I am trying to write a query that will look first in tblSealStripData to see if there is a date in the NextD field and if there is give the results from that record but if that field is empty then look in tblPEMAC in the DateStart field and give the results from that record in the table. I...

Hi, I am having trouble getting the vba code to check for duplicates working. I have a table called tblPEMAC with a field called PEMAC and on the form there is a textbox called txtPEMAC. How can I get it to check for duplicates? Regards,

Hi, I have a created a form which has several textboxes, the issue I have is that when the user types the data in the textbox and presses enter on the keyboard the data is not displayed until they go to the next text box. How can I change it so that the text displays all the time...

Hi, I have a form which i would like to be able to update certain fields in a table, the table is called tblSealStrip and the fields to be updated are Seal1 & Seal2. The data will be coming from 2 text boxes called txtSeal1 & txtSeal2. The record in the table to be updated will have to match...

Hi, I am new to access and am trying to create a query. i have 2 tables that I need to get the required information from, Table "Data" & "Machine" What I am trying to get is the user enters the shift commencing date and shift number and the query to list all the machines that are related...