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 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?
  3. 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?
  4. 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?
  5. 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?
  6. 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...
  7. 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