Search results

  1. A

    How do I use an Ampersand in a field name

    I am trying to us an Ampersand in the name of a field label when I use an Ampersand it is replaced with an underscore. I am trying to get the field name to display "AT&T" please advise.
  2. A

    Mass Merge of a Table

    I have a table with 45 fields and 900 records and a majority of the information has changed. I have a complete file in excel with all of the past information and current information merged together. If I try to break the relationships in the database import the excel file and recreate the...
  3. A

    Expression Builder

    In my database I have a field that tracks the status of my orders. 1 = "Pending"; 2 = "In Progress"; and 3 = "Finished" When I create a report the value shows up as a 1, 2, or 3. Is there a way to display "Pending", "In Progress", or "Finished" in the report?
  4. A

    Enable/Disable Part of a Form by a Check Box

    Can I have the check box toggel two different controlfields so when the box is checked one field is enabled and the other disabled and if i uncheck the box they both switch? This is waht I have but it does not toggle the field (control2) that is supposed to be enabled when the check box is...
  5. A

    Populate a combo box with a query

    I have two tables (Vendor and Notes). Each note is associated with a vendor. When entering notes I want to be able to link a string of associated notes together using the subject field on then Note table. For the row source I want query all note subjects associated to the vendor the note is...
  6. A

    Use a button to export a report to excel

    My end-users are running Access Runtime and they don't have that option so if there is a way to code it that would be awesome.
  7. A

    Use a button to export a report to excel

    Can you export a report into excel using a button and VBA? If so what is the code to do that?
  8. A

    Enable/Disable Part of a Form by a Check Box

    I actually would like the data to be deleted if the box is unchecked. Can that be done?
  9. A

    Enable/Disable Part of a Form by a Check Box

    On a Form I want a field to be disabled unless a check box is clicked. If the check box is unchecked I want it to fo back to be disabled. Any Suggestions?
  10. A

    Update current records with an excel file

    I have an excel file with updated information for 2 columns in my database. The values are different for each record and I was wondering if there is a quick way to update the files. Thanks
  11. A

    Open Find/Replace Dialog Box

    Using VBA, how do I open the Find/Replace dialog box when I click on a button? Additionally, I want the default "Match" value to be "Any Part of Field"
  12. A

    Lock/Unlock by clicking a button

    I was hitting the ... without changing to the "[Event Procedure]" thanks
  13. A

    Lock/Unlock by clicking a button

    Locking the field works perfectly. The button I want to push to activate the field also creates a new record in the database. When I try to add Code to the Button, it opens in the Macro builder. Is there a way to have the button create a new record and unlock the field? I cannot figure out how...
  14. A

    Lock/Unlock by clicking a button

    I would like to keep a field on a Microsoft Access form locked until I click a button on the form, how do I do that? The Button name is NewNote and the field I want to unlock when clicking the button is VendorID. Any Suggestions? Thanks
Back
Top Bottom