Search results

If I provided my database to someone, how do I prevent the database from being freely given to others? I know how to lock the database from being edited but I don't know how to prevent wide distribution without my consent. Any help would be appreciated.

I would like to create a hot key (e.g., Ctrl T), which will redirect a person on a form to a different form. Any assistance would be appreciated.

I have a form with an option group. Within the option group I have a series of queries (all records, closed records, open records, etc.) to sort the data. Everything works fine. My issue is a cosmetic one. When I change the query via running a report versus the option group, the option group...

I understand but it's not that easy. There are several forms for the member to complete. Also, the database may be used as a stand alone program.

I have a customer working in the primary database. Should the customer acknowledge he needs to complete a particular form, another database opens (secondary db). Once the customer provides the necessary information, I want the secondary database to close and return to the primary database at...

I cannot figure out what the error is (??). Can you see the error? =IIf(Not IsNull([Primary1Address]),[Primary1Name] & ", " & [Primary1Address1] & ", " & [Primary1City] & ", " & [Primary1State] & " " & [Primary1Zip],”BY LAW")

Thank you very much ... quick and easy

I working in a database. I want to open another database and go directly to a specific form (not the default form). How do I make this happen? Below is what I have so far. Dim accapp As Access.Application Dim appname As String Set accapp = New Access.Application appname =...

I know there is a command to set warnings on and off (e.g., Cmd.SetWarnings False). Is there VBA code that can be used so that a user doesn't see the pop up boxes when a series of reports are being printed? Thanks

I have a button on a form which runs a series of reports. Once the reports are run the Access database minimizes to the task bar (not system tray) I added a line ... DoCmd.Maximize in hopes of restoring the form (no luck). I tried adding a line to restore the form ... DoCmd.OpenForm...

I have a main table which collects address information for several people. Each state field (number) looks up the information from another table, which lists a 2-digit state abbreviation and the full state name. No problem. However, I don't know how to pull the 2 digit state abbreviation into...

I'm still getting an error - Wrong number of arguments

I cannot figure out what is wrong with this syntax. Any help would be appreciated. =IIF(IsNull[RSN_Increase]), “$ __________”, ("Increase or restore my SGLI coverage to " & [RSN_Increase_Amt] & ". You must complete section 3, 4 and 5.")

Thank you. Now that you've explained it, I see the errors. I need to think this out clearly.

This After Update action doesn't work. Am I permitted to write a compound And statement. If Me.QMarried = -1 And (Me.Primary1Relationship <> "Spouse" Or Me.Primary1Relationship <> "Parent" Or Me.Primary1Relationship <> "Child") Then Me.UnusualBefLtr = -1 Else...

Please explain further.

Can I use the Like command in an If Then statement? I'm getting a syntax error If [Primary1Name] Like 'PO*' Then MsgBox "You cannot use a post office box address. Use a residence address.", vbOKOnly, "Incorrect Address Information" DoCmd.GoToControl "Primary1Address1"...

I have a calculated field in a query. The calculation only works if the fields have values. This is what I used a the calculation: PrimaryShareTotal: [Primary1Share]+[Primary2Share]+[Primary3Share]+[Primary4Share] I tried using the Nz command PrimaryShareTotal...

Thanks. Tried but I'm still able to see other records via page up and page down

I have a customer provide his or her SSN. If the SSN matches a record in a table the form opens specifically on that record (no problem). If the SSN doesn't match a record, the form adds a new record (again, no problem). The issue I'm having is with the new record. The customer is able to...