Search results

  1. E

    Question about updating table from a form

    Help - I'm at a loss! I have a form that I am using for invoicing for a Trucking firm. On this form, I have three fields that I am having problems with. These fields are From, To and Mileage from a table named Location. The user selects "From" from a combo box then goes to select "To" from...
  2. E

    Table Security

    I actually did mean table. The employees update the table, no form. Is there a way to grant permissions to a table?
  3. E

    Table Security

    I am working in Access 2000. There is a table in the database that is maintained by two employees. All other employees should only be able to view and query the table. Is there a way to do that without having them log into Access?
  4. E

    Need help with Unmatched Query!

    Thanks - it worked perfectly!!!
  5. E

    Need help with Unmatched Query!

    I created an unmatched query with the wizard and it works fine - when I want to compare with only one field. Is there anyway possible for it to compare two fields? I need for it to look at field1 and field2 when checking for unmatched records. Any ideas?
  6. E

    Query Selection - Multiple choices, one field

    Thanks - that's what I am working on.
  7. E

    Query Selection - Multiple choices, one field

    Thanks, that works. I am still working on it looking cleaner for the user. Maybe some sort of list to pick from. Any ideas?
  8. E

    Query Selection - Multiple choices, one field

    I have a database which keeps track of a trucking business. Each truck has a trailer number. I have no problem having a query prompt the user to enter a single trailer number to query on. What can I do when the customer needs to select more than one trailer number to query on?
  9. E

    Cannot "Find" records while in a form

    Wayne, Thanks! That change did the trick.
  10. E

    Cannot "Find" records while in a form

    Here is the code to open the form with a double click: Private Sub CID_DblClick(Cancel As Integer) On Error GoTo Err_CID_DblClick DoCmd.OpenForm "CUSTOMER", , , , , acDialog, "GotoNew" Me![CID].Requery Exit_CID_DblClick: Exit Sub Err_CID_DblClick: MsgBox...
  11. E

    Create new table with Macro?

    I've never worked with macros in Access, please excuse the ignorance. I have a report that I can only produce after running queries - one that makes a table and two more that append to it. Is it possible to automate this with a macro? If so, how do I get started?
  12. E

    Cannot "Find" records while in a form

    I have an Invoice form with Customer ID and info fields. The Customer ID field is a combo box. If the Customer ID is not found the user can then double click on it to bring up the Customer form in order to add this to the Customer table. On the Customer form I have a Find button. The user...
  13. E

    Don't want zero vaules to print

    Thank you both! I was able to use all three methods in my reporting/form filling.
  14. E

    Don't want zero vaules to print

    I am filling in preprinted forms with Access. There are fields which are calculated in a query. Those fields which are zero in value appear in my form, which is OK. But, they do not need to be printed on my report. How can I have my report do this?
Back
Top Bottom