Recent content by Damo10

Hi, They both have 5 columns and the data types are the same. Regards,

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,

I have found out why, in the textbox properties on the other tab under enter key behaviour it was set to new line in filed instead of default. Thanks for your help

It is set to move to next field when enter is pressed.

I have tried putting an afterevent code in to setfocus on the next textbox but that does not work. When enter is pressed the focus is still in the same textbox

Hi, When enter is pressed it shows a blank textbox, it is not until the next textbox is selected or tabbed to that the text displays. There are no afterupdate events 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, Thanks for the reply. I tried before having the text boxes bound to the table but it was not working and I could only get it so that it was either changing the details in the first row in the table or adding a new row. I have the data in the txtWON come from a query so does this...

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, Here are the 2 tables

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