Search results

I wrote a batch file for the first time. Hoping for some feedback. :) This retrieves a copy of the latest frontend database and copies it to the user's C drive basically. I've tested it a fair amount in different scenarios and it seems to work. The batch file is stored on a network drive...

I have two forms, a datasheet form that shows invoices, and a modal form that shows a single invoice. There's a column on the datasheet form that displays "Edit" in every cell; the user clicks 'Edit' and it opens the specific invoice in the modal form: Private Sub Edit_Click()...

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