1
  • Access Subform Repeating Data

    I have brought in a subform into my main form and link the child and master fields, but under each page the subform repeats the information down the page, but in the report on its own (i.e. before it is a subform) it doesn't repeat - what do I need to do to sort this?

    SJJ5 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:
  • How to pick a source for a subform in Access 2003?

    I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A's plainid the DB the user is in. To check the DB-A's planid against DB-B' plainid then use the data to fill a sub-form. If...

    Techexpressinc10 pointsBadges:
  • Access Report Headers

    I have a problem trying to display a report header at the correct time on a report I am building in Access (2003). Lets pretend I have a report with 3 levels (cuz I do!!!):  Proposal, Supplier and Parts.  The report is for the Proposal.  It is grouped by Supplier and then has a subreport for the...

    Clangingsymbol5 pointsBadges:
  • VBA Access forms and 1 table

    I have an application where a start form, launches a second one and then according to text input/selection more form open (as a 3rd level form). I want all the answers to be recorded in one table as a singe record, but instead I get 3 different records, with responses from each form. What do I...

    AlienBee5 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:
  • 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:
  • Erro in Subform in Ms Access Reports

    Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there: NZ(), Val(),...

    Rahmedarain200510 pointsBadges:
  • Master/Child Link problem in Subform

    Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the foreign key in the...

    Dataempress115 pointsBadges:
  • Why won’t my Access subform stay put?

    Hi, I have a main form with a subform below it. The subform supposed to be invisible and 5" from the top. When I click a button, it becomes visible and 0" from the top. When I double click the button, the subform is supposed to go back to being invisible and 5" from the top. For some reason,...

    Dataempress115 pointsBadges:
  • Access – Bound sub form trying to set the value of an unbound field

    I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

    TJay85 pointsBadges:
  • Unable to restrict the display to top N records in subform in Microsoft Access 2003

    I have an application in MS Access 2003, which has a form and a subform. The subform displays, in its detail section records. I want to restrict the display of records of subform to top N records. When I use the query "select top 10 * ...", it executes successfully in the query editor window but...

    Zafarkhurram10 pointsBadges:
  • Access Subform Blank

    Subform doesn't appear in either form view or design view. Can move database to another computer running Access 2003 and subform works perfectly linked to the same tables.

    Billa15 pointsBadges:
  • Filtering a Subform

    How do I filter a form based on a value contained in the subform?

    Johnandy5 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:
  • 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:
1

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