Hi there,
I have a spreadsheet that is basically a flat inventory database and contains > 5000 rows. It has a category column (System) that can be used to filter thru the data. The System field may be A, B, C or D. The spreadsheet also has other columns:
Item
Quanity on Hand
Unit
Projected...
Hi there,
Would anyone know how to code the following?
1st Code Problem:
In a table/query, search through the records and
identify all the records that are identical except for their values in 1 field (of any field in the query), then
in a dummy field added to the query, concatenate the...
Hi there,
In a form, I have a bunch of combo boxes that vary in their 'top' and 'left' positions.
However, I'd like for their drop-down lists to all be positioned the same, having the same top and left position when selected. Is it possible to force their positions?
Thanks,
Eric
Hi there,
I need to create the effect of (1) setting the LinkChildFields and LinkMasterFields = some ID, and then (2) setting the fields to null. Can the LinkChildFields and LinkMasterFields be manipulated in this way?
Thanks much,
Eric
For Option #1
I was able to make doable code for setting the values of the temp variables to those of the underlying record's controls, creating a new record, then transferring the control values into the new record.
var1=form!field1
var2=form!field2
....
docmd.gotorecord, acnewrec...
Thanks for replying SeeThru,
If the current value of SomeControl (a combobox) has already been entered, a NotinList event triggers the pop-up form that contains an option group. The options in the option group are:
1. Insert all of the previous record's values into a new record for revision...
Hi,
I'm not sure how to code the following:
If SomeControl on a loaded form (behind a popup option group form) had the focus, then copy the value (or assign the value to a temporary control like TempSomeControl), then in a new record added to the loaded form, paste or apply the value to the...
{Copying to a new record fields including a combination primary key}
Hi there;
I have a bound subform (Company subform) that's linked to a mainform by a combination 3-field primary key:
DocID
CompanyID
DetailsID
The bound subform has another subform (Details subform) that is not bound to the...
Hello,
I have 2 tables joined in a query. In a combobox on a form, users must view columns from both tables—I can set this up. The combobox’s control value is currently set to the ID of one of the tables (ChemID). However, the ID is NOT a unique ID in the table (a join table). What will...
Hi there,
This is wierd! I have a combobox, comboCompanies, on a main form. All I want to do is be able to select different CompanyID's from the combobox and have the form update itself to the record I just selected. Don't think I've set this up any differently than other combo's that have...
Hi there,
I'm having a prob figuring out the best way to do this:
I have a form that's set to add a new record when a user opens it. On the form is a combobox (comboName) that the user can type in. If the user enters a name that's new or not already in the combobox list, everything's fine &...
Happy New Year!
I have an unbound subform that has 4 list boxes (combo boxes that are limited to their list). This subform is to basically be used as a summary subform, in which users should be able to view the records they may have just entered into 1-4 other dialog forms; the record sources...
Thanks for replying.
The Chr(13) & Chr(10) code works for regular labels, but it doesn't appear that it works in the actual tabbed page label, which is where I'd like 2 lines of text.
Any other ideas?
Hi there!
Is this possible?
Can a hard return and new line be added to the textual label describing the page name of a tabbed subform?
I'm aware chr(13) and chr(10), but how can such things be applied inside the page's name label?
Thanks much,
Eric
Hey there,
I have a table/query with a combination primary key and I'm trying to create another field that is automatically numbered with the count or number of records for a particular combination of the PK fields. The fields are:
Doc part of PK
Party part of PK
Number new field to...
Hi there,
I have a main form in which I'll place a combo box or option group, and upon a user's selection, some code will open up a table or another form, add a new record, enter a value, then close---all while being transparent or invisible to a user working on the main form.
This sounds...
Here's an example of the data:
MtlbLegal=property legal descriptions, like parcels, sections, townships, ranges, etc.
MtblChem=chemical data, mostly chemical compounds and their properties, like specific gravity, hazard rank, etc.
MtblOps=operations, such as manufacturing, assembly, storage...
Jeremy,
Very good comments and questions. Thanks for your replies.
In terms of RI, if it's enforced, then I receive errors like 'a related record is required' in one of the other tables. I'm trying figure out a work-around for that (data won't be entered into all of the 3 tables all of the...
Thanks Jeremy,
Not enforcing ref integrity allows the data from the 3 tables to be entered, combined and tracked in the join table.
I'm rather new to VBA and am not sure about how to go about adding the flag field(s) you mentioned, or coding for the follow-on deletions/updates for that matter...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.