Search results for query: *

Finally fixed with the help at another forum. My subform's record lock was on "all records", once it was removed, it worked fine.

I have done what you suggested, still the record will not be deleted!!!. It gives the same message. Thanks in advance for your help.

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

Hi DoubleD: It gives type mismatch error at dbs.OpenRecordset("tblEquipmentCheckList").Updatable

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