12 Resources for

subform

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

MS Access. 2 subforms from same table.: I have a form called "customer issues", which is a single form view. Inside of this I have a subform called "communications", which is a datasheet view.This works by each "customer issue" having multiple "communications".The "communications" table has Date, Time, Subject,Notes. As the notes could be long I want to...; Tags: subscriptions@..., Microsoft Corp., Microsoft Access, subform; Discussion threads 2007-10-15
Access ADP form synchronizations: I'm having a problem getting a complex form to keep the subforms sync'd in an Access ADP file. Here's the scenario:Main form has a list box and a subform. List box contains a list of current job openings. Subform contains information about the posting that is selected in the listbox....; Tags: Recruitment & Selection, brianmullins@..., subform, job, Access ADP, Microsoft Access, Subform; Discussion threads 2007-10-05
Copy field from previous record on a subform: I have a form with a subformAdd a new record on the form and assign a key.Subform shows a new record with the key.Click a field on the subform.Ctl-" does not copy forward from previous record.I want to use record clone on the subform (which doesn't work either) so I...; Tags: rapodgorski@...; Discussion threads 2007-07-05
How to reference an Access subform: Referencing subform controls always throws Access users for a loopÂ while they're new to using Visual Basic for Applications VBA. That's because Access views the subform as just another one of the form's controls.To refer to a form, identify the form via the Forms collection as follows:Forms!formnameReference specific controls and subforms...; Tags: Access; Blog posts 2007-07-05
Transfer data from one subform to be calculated in a second subform: I am working in an Access2000 database which I created. I have a Payment Data Entry main form which has 5 subforms. frm_PaymentDataEntry is the main form.On tab1 Payments there is SUBfrm_Payments. The field [Payment Amount]updates to tbl_Payment so that the totals can be calculated on tab2.Tab2...; Tags: Operational accounting, sue.berger@..., payment, SUBfrm_Payments, subform; Discussion threads 2007-05-21

'Find' on both form and subform: I have a Access 2003 form with a form and subform. Can anyone guide me on how to create a contextless find so the user can search both the form and subform. At the moment the find is defaulting to where command button or the cursor is positioned. To...; Tags: Scripting languages, subform; Q&A 2005-10-19
Create an AutoLookup query in Microsoft Access: Another helpful application of this conceptI use this same technique to keep track of our fiscal calendar in Access. I have one table that just has one field, which I call "current week" which I populate with the current fiscal week number (1-52, depending on when your fiscal calendar...; Tags: access, calendar, date, fiscal, fiscal calendar, GSteve, hardware, Invoice Details, Microsoft Access, Microsoft Corp., subform; Discussion threads 2005-08-31
Access 2000 Sub Forms: I have a Parent Child Database. The Parent has Names & Addresses, while the Child has payment dates & amounts.Sometimes I want to put check the "NO PAY" box on the Main Form. I wanted the Subform Payment field to be disabled.In the Main form I checked the "NO PAY"...; Tags: abramowitza@..., Main Form, Microsoft Access, MRA2, Pay, programming, subform; Q&A 2005-07-07
Access Programming: In my access database I have a form with a subform.This subform is used to enter multiple lines of data and ofcourse is all stored in various tables.I want each line in my subform to show an item number, starting at 1 and increasing by 1 each line and the...; Tags: item number, Microsoft Access, programming, software, Sprocket, subform; Q&A 2005-04-12
Listbox help: I have a Access database that was created in the XP version. I have a form that has a subform embeded. On the regular form I have a combox; in the subform I have a listbox; I want the listbox in the subform to pickup every selection I...; Tags: Databases, subform; Discussion threads 2004-11-24
Access Forms/subform: I have a master form with an address and subforms with an address that I would like to default to the address on the master form under certain circumstances. I cannot figure out how to pass the master form information to the subform. Is there a way to...; Tags: foxne273@..., main form, Microsoft Access, programming, subform; Q&A 2004-10-13
Provide easier navigation between Access main and subforms: For the experienced Microsoft Access user, navigating between main forms and subforms is an intuitive function. By pressing the [Tab] or [Enter] key within Access, you can move from control to control on a form or to a subform. As far as Access is concerned, an embedded subform is just...; Tags: Microsoft Access, Susan Harkins, subform, main form, Ctrl; Technical articles 2003-08-13

Additional Resources

Ms Access 2k Subform with check box selection: I have a subform which generates a list of equipment which is assigned to an employee through a query. I wanted to know if there was a way to add an unbound check box to each line of the subform to allow the user to check selected items to...; Tags: dd10321@..., Microsoft Corp., Microsoft Access; Discussion threads 2007-09-16
Calendar date into a query: I would like to make a form showing a calendar with a subform underneath that displays the results of a query. The criteria for the query would be the date highlighted on the calendar - each time a new date was selected the query subform would change to show...; Tags: shona@...; Discussion threads 2007-08-27
Access 2000 Sub Forms: I have a Parent DB with names address etc. I have a Child DB with Fees paid. I use a Form Parent DB Info with an subform Child DB Info on it.How do I get a total in the subform? It has a footer but it doesn't show...; Tags: abramowitza@..., Microsoft Access, MRA2, Parent, programming; Q&A 2004-10-13
How to show Access subreport totals in main report: Reports and aggregate functions go hand in hand. Using the same aggregate function, you can evaluate groups of data or the entire report. For example, the expression SUMAmount will return a different value depending on which report section it's in. Subreports expand on this capability. You can even display aggregate...; Tags: Microsoft Access, Expression, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins; Blog posts 2008-04-28
unrelated form/subform msacc. form to update when sub data done: HiI have 2 transaction files - 1 for creditors, 1 for gl. for every creditor transtion entered on the main form, there may be 1 or more detail transactions on the gl sub form. I do not want the crs form to update table until gl subform data has been...; Tags: duberyr@...; Discussion threads 2007-10-03
Question: How can i search data on a Subform using command button and Combo box on a main form in Ms AccessVBA attached to combo boxPrivate Sub SeekByID_AfterUpdate Dim rs As Object Me.Filter = "" Set rs = Me.Recordset.Clone ...; Tags: muchipisibetty@...; Discussion threads 2007-11-19
Creating records in a subform from the main form: Hi all,.I have a small issue I would like to resolve with VBA. I have a form which it's fields are bound to a table. Within that form is a subform which is a subtable.Tables relationship is a one to many from the main table to the sub table. On...; Tags: ithopkinton@..., acNewRec Me.Lane; Discussion threads 2007-09-21
Access 2000 Date Function: All I wanted to do on a FORM was:If the date is null Not entered then enter the System Date. Here is ny code which for some reason WILL NOT recognize the Date Function...Private Sub Command12_ClickOn Error GoTo Err_Command12_Click‘ THIS SECTION DOES NOT WORKIf IsNull([Forms]![Form1]![Dates subform]![DateServ]) Then'[Forms]![Form1]![Dates subform]![DateServ] = #1/1/2222#...; Tags: abramowitza@..., Form1, Forms, IBM Lotus Notes, Microsoft Access, MRA2, Notes Subform1, programming; Q&A 2005-09-22

<< Previous
page 1 of 1
Next >>

Content Types

Blog posts (1 results)

Discussion threads (6 results)

Q&A (4 results)

Technical articles (1 results)

Help Desk Trouble Ticket Form: The Help Desk Trouble Ticket is an important document for the technical support professional. This form contains all the essential fields for maintain ...; Buy Now

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now