Search results for query: *

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

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...

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...

Hi there, I must tie together the data in 3 main tables: MtlbLegal MtblChem MtblOps There is another main parent table which will always have data: MtblDoc I've made a join table: JtblLegalChemOps, including the ID's of each of 1st 3 tables above plus MtblDoc. Relationships: MtlbLegal...

Hi there, I have a join table, JtblAmounts, linked to another table, tblLegal, in a one-to-many relationship (ref integrity is set). The primary key of JtblAmounts is AmountsID (autonumber), which is a long integer number foreign key in tblLegal. I have a form based off of tblLegal, and...

Hi there, I'm trying to devise a way for a user to click a check box or something on a main form that sets the data for that record, including all of its linked data in records across several tabbed subforms, as the the default for the next main record (and linked records in the subforms)...

Hi All, In a single main form, I've inserted a Yes/No option group (No is default) asking a users if they want to "Enter additional info?" If a user selects Yes in a particular record, I'd like for the additional info fields (Book, BkPage, BkIndex) to become visible for data entry...

I have an Access 2000 database for indexing and summarizing paper documents. There are 3 tables: tblDocumentInfo DocNumber (primary, autonum) DocTitle DocDate tblCompanyInfo DocNumber (integer, foreign) CoName CoAddress1 CoAddress2 etc. tblOperationsInfo DocNumber (integer...

Hey there, I was wondering if there is a relatively simple code to highlight each field that is entered (tabbed to or clicked inside) in a form and its subforms. I'm interested in making the background color of an active field light yellow or something. Thanks much.

Hi there, I have a main form with 2 tabbed pages (pg1, pg2), each with a different subform (sub1, sub2). Across the bottom of the main form are three command buttons (cmd0, cmd1, cmd2). I'm trying to write some code for navigating among the pages and forms, and would like to do the following...