Search results

  1. S

    "Pretty" command buttons in Access 2007

    Perhaps this has been covered but I'm having trouble finding the appropriate search terms. I have a .mdb database (created years ago and modified many times) that I'm looking at with Access 2007 on my Vista machine. The buttons currently on the main form and any new command buttons I create in...
  2. S

    Semicolons within listboxes

    I have a form with a two-column listbox on it. The first column shows the invoice number and the second column displays the (text) description. The user types some text into a textbox, clicks Search, and the matching results display in the listbox. Recently a record was added where the...
  3. S

    Non-printing Controls

    I have a document with a button (cmdReset) that I want to appear on the screen but not to print. Anyone know how to do it?
  4. S

    SaveAs & ChangeFileOpenDirectory

    I have a document named test.doc saved in C:\one. I open that document in Word (2003). Now I want a macro that shows the SaveAs dialog defaulting to C:\two instead of C:\one. I've tried... ChangeFileOpenDirectory "C:\two\" Dialogs(wdDialogFileSaveAs).Show ...and...
  5. S

    Wildcards in SELECT statements

    I've got a database with a table [AddressBook] with fields like [FirstName], [LastName], [Address], [PhoneNo], etc. And I've built a form with a textbox [txtSearch], a command button that runs the code below, and a listbox [lstSearchResults] where the results should appear. There's more to it...
  6. S

    One click creates a new database

    I have an Access 2003 database (All Employees.mdb) that I’m working on. It has a table (Employee List) with 3 fields (Name, User Name, Password) and a record for each employee in the office. There is also a form (Employee Info) which displays this information for the user. On the form is a...
Top Bottom