Search results

Hi. I have an button that opens a report when clicked. Here is the code associated with the button: Private Sub Preview_Med_Expense_rpt_Click() DoCmd.OpenReport "rptMedExpense", acPreview, , IIf(Me.FilterOn = True, Me.Filter, "") Me.FilterOn = False End Sub It works fine, but I need it to do...

Hi. I have a shared Access 03 database, and the Default Record Locking is set to "Edited Record." Also, the options are set to warn when a record is being deleted. However, When 2 people have the same record open, they can both make edits. I never see the circle with the slash you're supposed...

Hi guys. I have this code for a button, that lets me filter records by selection, then preview a report on the filtered records: Private Sub Preview_Rpt1_Click() DoCmd.OpenReport "rpt1", acPreview, , IIf(Me.FilterOn = True, Me.Filter, "") End Sub It works fine, but I need to do it again for a...

Hi. I need to create a field that will allow me to input a list of numbers, and then another field that will calculate the total. I'll explain how I used to do this in Filemaker Pro: 1. Create a number field, set it to repeat (say 20) times. This allows you to input up to 20 different numbers...

Hi. Is there a way to set the default view in Access 03 and 07, so when a user opens the file, the correct view is already open? For example, I have a simple contacts db. Inside are two views: a table view, and an individual client view. I want the individual client view to be up by default...