I have an excel table I'm importing. It has line items keyed on PO and project containing dollars. I want to sum up the dollars by PO, then post the summed...

I want to include an unbound combo box in the datasheet view of a data entry form. It's actually a subform. The unbound main form controls set the record...

I have a front-end database with NO tables (only links), half-dozen queries, a dozen forms, and three code utility modules (all told, code is maybe 300 lines...

I'm sure you answer this over and over again. I did search first and found not a suitable answer... I have a header table and detail table linked by ID. In a...

I have a listbox (lbProjects) that should enumerate all the Projects assigned to a given Capital Request. The form (frmCER) is bound to the Capital Request...

I've created a field in two different tables called "GroupCode". It's defined as a number, field length byte. In my Labor DB, I set the field to a value of...

I have a listbox called lbSelectList. It has 5 columns. I want to rifle through the selecteditems collection and use columns 1,2,and 3 in sql statements (not...

I've had the fosusername() function running on a client's computer for a long time. Suddenly, it can't find the "tacomp90.ocx" library when executing...

I need to execute the transferspreadsheet action with a subset of all the records in a table (or query) based on a list of choices the user selects in a...

I have a combo box (cbLaborRate) in a subform (sfmDailyLabor) of a form (frmLaborEntry). The combo box record source needs to refer to a combo box control...

I have a form with a subform linked to it (Subform displays child records...) Now I want to be able to check a box and substitute a different set of...

I have a subform with a caption. I have an ON Load procedure that executes the following code: Private Sub Form_Load() Me.Filter = " = '" & strSessionID...

What's wrong with the following used in the row source of a combo box on a form with other controls (including cbVendorID)... SELECT DISTINCTROW ., ., .,...

I have a textbox (cbPONbr) on a subform (frmPO) on a tab of a tabbed main form. On the same tab, but a not in the subform, I have a list box. I want the...

I want my main form to be non-updateable, while the multiple subforms that display child data should be updateable...How? -- Jim

I need to produce a "Letter of Authorization" out of my database on request. The letter contains a number of fields from half a dozen related tables with a...

When I set up a subform, it seems to default to the multiple-records-one-record-per-line format. I want to show one record per page, allowing scrolling. How...

OK, I just need a nudge in the right direction. I have a vendor table with a number of related tables. I've set them up and set up the relationships (using...

I have Access 2000 and Excel 2000...when I try to create a pivot table using the Wizard it says "The PivotTable Wizard can't find Microsoft Excel 97 or...

I want the Control Source (or perhaps it should be the "Default Value") in a form to be the following using VB. Go to the last record in "Table A" "FieldName"...