• access 2003 complex query

    Master table has fields: Report_No,Product_ID,Test_Date Detail table has fields: Report_Det,Report_No(Foreign key),Serial_No,Quantity,Result Results table has records: Pass,Fail,R&D,InProcess Detail table have 1,2 or 3 records with different result against each record in Master table. I want to...

    Isqureshi665 pointsBadges:
  • Create “if then” formula in Access 2003

    Hello, I'm new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that's why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one for intro and...

    Jos197215 pointsBadges:
  • Access 2007 button addition

    Hello I have what I assume to be an easy question that hopefully someone can help me out on. I have a form that I need to add a button to that will pop up a box that you can write a description in. It needs to be different for each record that comes up in the original form. Does anyone know how to...

    Jdusaf5 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:
  • Pass data from Access subform to another form

    In Access - How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form

    Bdbarnes5 pointsBadges:
  • Creating Access Form

    I have a table where I want to query partial phrases or words and cannot figure out a simple way to accomplish this. I used the brackets [] in the underlying query but cannot figure out an easy way to retrieve data with partial info.

    Tbill655 pointsBadges:
  • How do I keep the original value of a field in Access 2010?

    Hello, I have an inventory with varying prices (which may change weekly).  I need to compare the current price with the original price. However, I only want the users to input one price value in a form.  I've tried to do this with a datamacro and the "old" command, but every time i update the...

    Vostro12315 pointsBadges:
  • Can ACCESS forms be used in EXCEL?

    Can forms created in ACCESS be used in EXCEL (via VBA)

    Jgenterprises10 pointsBadges:
  • Data Changing when closing an Access 2003 form

    I have a form in Acess2003 with a subform, the subform is linked on two fields, name and date. If I close the form when my master form is on the first name in the combox everything works fine - If I close the form not on the first name in the combo box, then whatever name it is on gets the date of...

    Nainey455 pointsBadges:
  • Can’t change Navigation Button Caption for subform

    I'm following the instructions in the New Perspectives Comprehensive Access 2007 and can't seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?

    Bets5 pointsBadges:
  • Changing Access form properties within your program.

    I have a form where I want to lock a control according to the selection made in a combo box. How do I go about doing this? Thanks.

    AOMCprog5 pointsBadges:
  • How can I ensure that the invoice data goes to the correct record on the subform datasheet?

    I use a form to hold the details of a client. The form has a subform [datasheet] which details each visit that the client makes. To do an invoice for the visit I have a pop-up form. I would like information from that pop-up form to be transferred to the datasheet subform. How can I ensure that the...

    Jhegarty5 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:
  • Update multiple tabs on an Access form on initial update

    I have 2 main tables, 1 main form and 4 subforms. The subforms all come from the same table. The subforms are in tabular format, and to fit all the fields I put each subform on a seperate Tabs. The Key Control Number ([Key Contl_Num]) is the Field that appears in each subform and on each tab. My...

    RKJohn95 pointsBadges:
  • Auto-Populate an Access form using a table of values

    I'm having a little bit of a dilema. I don't even know if it can be done, but I thought I'd give it a shot. I'm pretty new to Access so I'll try to be as clear as I can be, but I think this will get confusing. I have Multiple tables and a form for adding records. The master form has "Case...

    Jirges5 pointsBadges:
  • Access 2007 form creation

    Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i'm not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button a message...

    Kvs35 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:
  • Access Form Printing Problem

    I have designed a set of forms in Access.  One of the forms prints the form in total.  However tow of the forms will only print the header and footer and does not print the data input portion of the form.  What am I missiong in regards to why I can't get these two forms to print in total? Thanks

    Ranfoster5 pointsBadges:
  • Form vs. table record order

    Why doesn't the record order for an MS Access form match the record order of the table (form keeps re-ordering the records)?

    Mcoopers75 pointsBadges:
  • Paste records in OLE Unbound Excel Object in Access Form

    Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

    Brianaaskew40 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