Search results

I inherited a database and am trying to view the code that is behind the buttons on the MainForm. No luck, even when I open the database directly, from the mdb bypassing the mdw attached to it. Next, I tried to create a new database and suck the contents in. Get a message that I don't have...

I thought I already posted this, but I don't see it. Is there a more elegant way to write this code? I would rather not use two IF statements. If (Not IsNull(Me.CLOS_DATE) And DLookup("logonname", "tbllogonname") <> "azura") Then Me.AllowEdits = False End If If (Not IsNull(Me.CLOS_DATE) And...

I have several forms in my database that have a closed (1=Closed) option button. Is there a way to make all of the fields for that record readonly if the closed option is set to equal 1?

I have a database that is being run on both Access 2003 machines and Access 2007 machines. What I want to do his hide the toolbar on both versions in my on load event of my splash form. Now, I know the one for Access 2003 is DoCmd.ShowToolbar "Menu Bar", acToolbarNo and the one for Access 2007...

I have written a database in Access 2003, saved as an Access 2000 format. This runs fine on Windows XP workstations. When I install the same system on a Windows 7 system, my login screen launches, the user is able to enter in their name and password. Then nothing happens. What is supposed to...

How do I set in vba the orderby, when the order by is selected from a drop-down box? Access 2000.

I am trying to open up an Access database as read-only from another running Access database. The code I have to open the database currently reads: """C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"" ""f:\common\patty\Training Database.mdb", 1) How do I change to read only?

Access 2000 format, does anyone know how to change the password assigned to a user in the system.mdw? The security wizard says to click on the user to change the password, but nothing happens when I do that.