• Access form won’t clear after each entry is added

    I have an access form with an add button. The button adds the record to the table, but the form won't clear that entry out. How do I clear the entry?

    Bonniw5 pointsBadges:
  • How to pull a query on a particular table based on form selection

    Ok this is not as simple as the title suggest, this is what I'm trying to do: I have a database with about 30 tables (which are actually linked to Excel spredsheets). I need to be able to query each table and make a report only showing certain information for it. I started by doing individual...

    Brianaaskew40 pointsBadges:
  • Microsoft Access 2013 button placement on form

    In Access 2013 (Win 7) with controls aligned vertically, is there an easy way to have equal spacing between them?

    LeonFromWA5 pointsBadges:
  • Access Forms

    Can information appear on a form based on information on a table? I have information on a table that I want to appear on a form, but I want the info to change on the form based on a change made in the table. EG I have a person down on a rota as doing an overnight, the name will change each night,...

    quinny5 pointsBadges:
  • Access 2007 setting up repetitive entry form

    I'm doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?

    Net201015 pointsBadges:
  • Forms in Access 2007

    I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem?

    Jenkinac40 pointsBadges:
  • Need to modify an existing form in Access 2007

    I have just migrated to Access 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.

    Mantis5 pointsBadges:
  • Importing from an Excel worksheet to Access form

    I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word #NAME? in them. How...

    Horses5 pointsBadges:
  • Forms

    I have a form (frmInvoices) used to enter new invoice data. It's control source is tblInvoices. But on my form, I have 3 fields to pull data from: (tblcustomer.customerid) and (tblnewinvoices.id; customerid; and datecreated) I can't figure out how to populate datecreated and id from tblnewinvoices...

    Noreene5 pointsBadges:
  • Access 2007 – All Access Object Forms Section – Collecting data using email

    In the forms section under the All Access Objects section, I am trying to collect data by using e-mail messages. I am trying to send this form out to a group of individuals and then I would want them to return that information to my email. From there I want to export that information from the form...

    JOrtiz895 pointsBadges:
  • How do you create an order form where you can enter multiple product line items?

    I am trying to make an order form in the data base for product.  I want this form to have customer ID and Company name once on the form then numerous qty, item name, and item number lines to be able to type more then one product ordered on the same order form.  I am having quite a bit of...

    PorcelainConfections10 pointsBadges:
  • Form in Access 2007

    How to build a demand form which will draw grocery items from main inventory table with related data and quantity ordered will be filled up manually?

    pgd1235 pointsBadges:
  • Finding a specific record with user input

    I am very new to Access, but have used Approach in the past. When I used Approach, I could create a find in a form, user would be able to enter the find criteria in the blank field. I can not figure out how to do that in Access. Help!

    5boznme10 pointsBadges:
  • Access 2003 changing the company name

    I am working in a 2003 access db that was set up by someone else. the Company name has changed. How do I change the company name so it prints out correctly on our work orders?

    bathgenie5 pointsBadges:
  • Creating a form in Access 2007

    i have a customer table with the following fields : name code : this should be generated automatically domestic export I want to create a form to add, edit, delete and view the records. when a new record is added, the user has to choose between domestic and export (option group), and based on the...

    agarwal12310 pointsBadges:
  • editing in grid forms

    How do I add,edit,delete in gridforms with Microsoft Access?

    vidyam5 pointsBadges:
  • How to add a text box within a option group on a form?

    I need help trying to add a text box to my option group on Access 2010. Within my option group I have it listed: Materials Labor Heat Rate Other: (text box) Or at least thats how I want it, but as I input the information to the "other" text box, it shows up on ALL the forms. I guess my question is,...

    Amroberts120 pointsBadges:
  • Getting last 6 entries for each person

    Hi everyone, I am trying to create a query that pulls the last 6 exam scores for each of the operators at the plant I work at.  I have a table that has the last 2-3 years worth of data.  The current query I have just organizes the data without filtering the last 6 entries, and I cannot figure out...

    DASiuda25 pointsBadges:
  • Access 2007 – Controlling Master ID when launching detail form from master form

    Hello, I have a master table, and a detail table. (One master record to many detail records, and an ID number that links them.) I have a form that shows the master record data, with a button that launches a form that shows the detail records for that master record. (Where condition ="[Master ID]="...

    KAnneAxcesDev5 pointsBadges:
  • barcode entered, still dlookup not populating “item” and “price” in the form

    I have two tables, one is "inventory" and the other is "sale". I created form using the fields from "sale". in the "inventory" table, I saved barcodes of all items. Here, I want the form to populate the "item" name and "price" of the barcode I enter in the barcode textbox of the form. Currenty, it...

    Akarimfox5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following