Search results

One of my queries which has always worked before now gives a "No Current Record" error. I didn't change the query. Another query which is almost identical save for the fact that it uses parameters and a WHERE statement still works. This started about an hour after I split the database into...

I'm trying to implement a simple communication log feature. I have two tables, Members and Logs in a one to many relationship. I want to add a button to the Members form called "Create New Log." When clicked, it opens a modal dialog window where the user can fill out the fields for the Logs...

I'm trying to write an update query that will link records between two tables depending on whether an integer value derived from one table falls between the values of two integer values from the other table. I have a Members table, and a Rates table. The Members table has DOB. The Rates table...

I took this example code from rogersaccesslibrary.com: SELECT tblOrderDetails.OrderDetailID, tblOrderDetails.OrderID, tblOrderDetails.ProductID, tblOrderDetails.Price, (SELECT Sum(Price) FROM tblOrderDetails as OD WHERE OD.OrderDetailID <=...