I need help to solve this problem.
I have two tables, Main table (tblProdDataLog) and linked table (tblProdDetails) with one to many relationship.
I have a main form called frmProdLog and the subform on it called subfrmProdDetails. The both forms are linked on child-master field "DataLogNo"...
This is what worked.... I appreciate your help. Thanks again.
Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim LastDate As Variant
Dim DueDate As Variant
Dim CurrentCardNo As Integer
Dim LastLineNo As Integer
Dim rst2 As Recordset
Set dbs =...
I found an excellent answer to your question at the following site:
http://www.candace-tripp.com/_pages/access_downloads.asp
Search for "popups" on this site and download it.
p27Br:
Your suggestion to use rst.field(position) works. However, further on it gives an error that cannot update -database is read only. I think DoubleD is pointing out the same thing. If using Group By makes it not updatable, how could I go about doing this? i.e. getting the last check date...
Hi everybody:
After pulling my hair for several hours I have come to tek-tip forum for help.
I have a simple database and it is maintenance program which shows outstanding machines due for maintenance depending upon established frequency.
Primarily it has two tables, tblEquipmentChecklist...
Thanks! It worked great. While it highlighted the name in
the list box still I had to select the highlighted item and thereafter click the button to view the selected name's detail form. So I reviewed Q218621 from Microsoft Knowledge base article and it served the purpose.
I have a listbox that has two columns: EmployeeID and FullName (which is an employee full name). I have a textbox and what I would like to accomplish is that when a user types a letter in the textbox, the item in the list box (EmployeeID is a boundcolumn for the listbox )should be highlighted...
I have a listbox that has two columns: EmployeeID and FullName (which is an employee full name). I have a textbox and what I would like to accomplish is that when a user types a letter in the textbox, the item in the list box (EmployeeID is a boundcolumn for the listbox )should be highlighted...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.