Search results for query: *

I have a shared database that 10 users input orders into. At the end of the year I want to archive the past years orders into a spreadsheet and delete the records from the database. Unfortantely the admin user is not very good at enforcing that all users logoff wnen this process is started...

Hi All, Can anyone please provide a small sample of code to verify if the database I have open in Access 2002 is opened in exclusive mode. Thanks in advance for the help. Dave

Hi, I have an MS Access 2000 Database that I support. My customer received some message about recording and one user powered off his PC. The dabase still thinks these records are locked by another user but I the only user on the system. How can I clear record locks?

Q, You can try this: Private Sub Report_Open(Cancel As Integer) Dim varDate As Variant varDate = Now() - 30 Me.FilterOn = True Me.Filter = "Date >= '" & varDate & "'" End Sub Hope this helps, Dave

Hi, I'm a new user to Access and need help with creating page totals in an Access report. The report will be used as an invoice and will need to have an item count and total amount per page of the invoice. Also the last page of the invoice needs to display the items and totals for all pages...

Hi, I'm fairly new at Access and would like to know to how to create page totals. I'm creating a multi-page invoice. The customer has asked that at the end of each page a total be displayed for the invoice items on that page. Also on the last page they asked to display summary lines of each...

Steve, Yes, option 1 would work. But the users are used to using navigation buttons for another application. As a last resort I will use option 1. I would like to try option 2. I know how to get the current record for the form, but how do you go to that record in the listbox? (Recordset...

Hi, I am a beginner at Access 2000 and I have a question to ask. At the top of my form is a listbox with all the records for that form. I used the lookup wizard to create the listbox as a way to navigate between records. The listbox works fine, when I select a record in the listbox the form...