• 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:
  • 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:
  • 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:
  • 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:
  • Set Down Arrow Action In Microsoft Access

    Hi, I was wondering if there was a way to set when the down arrow is pressed on a Continuous Form in access that it goes to the next record and not the next field. Any suggestions would be great. Thanks, Dustin

    RoadDust390 pointsBadges:
  • Remove Q in Microsoft Access

    I have a form that I scan a barcode with quantity and barcode has Q20. I need it to record on table with 20. Removing the Q. Can this be done on a numeric filed or does it have to be done on a text field. Is there a code to eliminate the q from the field when the barcode is scanned.

    Danielsang15 pointsBadges:
  • How do I place duplicate directly below the copied record?

    I have code (below) which works perfectly today attached to a button to copy a record in a form. But, it inserts the new record at the bottom of the form, I would like to make it past the new record immediately below the copied record. Is there a way to do this? Private Sub Duplicate_Record_Click()...

    Klemieux5 pointsBadges:
  • Toggle button in Microsoft Access form

    Hi, in an access form I have included a Toggle button which when "on click" imports an excel spreadsheet. What I want is to block this toggle button after clicking it the first time so if someone clicks on it again, it won't import the same database. Thanks

    Codino10 pointsBadges:
  • Microsoft Access: Hiding form fields with Null values

    Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark "x" and others do not. I need to be able to pull up someones name and see a summary of what they have "x"'s in. I created a Columnar form that has each name as a seperate sheet; listing...

    Wesleycrozier30 pointsBadges:
  • creating reports with forms/subforms

    I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and when I create complete report how can I...

    Sunshine07660 pointsBadges:
  • Change year range on ActiveX calendar on Access form

    Hi. I want to change the year range on the calendar in microsoft access. At the moment it goes from 1900 to 2100. really annoying! I have the ActiveX Calendar 11.0 version. On the microsoft website it says to add the code: StartDateCalendar.Year = 2001 but how do you do this? the only other thing...

    Dontgetit105 pointsBadges:
  • How to create a Microsoft Access form that generates a spreadsheet with parametered values?

    Hello, I have a table that has this type of fields (almost 26,000): Cia Type Account Type Call flag Country Client code related main include China 5765 not related auxiliar not include USA 3372 related auxiliar excepted USA 981 related auxiliar include China 789 In access I need to create a Form...

    Codino10 pointsBadges:
  • subform

    I have one table and a main form and a subform. All fields for these form are in this table. The subform is called from the main form via a command button. When I go to the main form and go to, say record 3, it displays the correct data, but when I use the command button to open the subform the...

    Donb5225 pointsBadges:
  • Viewing the guts of a Microsoft Access form, query and report, programmatically

    I have over 1000 MDB's which need to be checked to make sure they don't reference any external sources. So, I'm searching for 'A:', 'B:'... 'Z:', '\', etc. I need to search the guts of each form, query definitions, and reports to find any references to something external. The data is done. Is there...

    DMoseley5 pointsBadges:
  • Microsoft Access linking

    Hi, I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key). I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form. I would like to be able to open...

    Donb5225 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