Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Accesser
  • Order by date
  1. Accesser

    Is this possible in Excel? About inventory.

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

    2 Code Questions

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

    Is there a way to position drop-down lists via VBA?

    Thanks for your reply and info Jiqjaq.
  4. Accesser

    Is there a way to position drop-down lists via VBA?

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

    Toggle LinkChildFields and LinkMasterFields?

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

    Please help translate expression into VBA

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

    Please help translate expression into VBA

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

    Please help translate expression into VBA

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

    Copying to New Record Fields Including Combo 3-Field Primary Key

    {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...
  10. Accesser

    Multiple Bound Columns in a ComboBox?

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

    ComboBox isn't keeping up with the drop-down value

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

    Check whether or not a record exists before adding a new one?

    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 &...
  13. Accesser

    Interesting probs: binding unbound subform to main, and sorting sub

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

    How can a hard return & new line be added to a tabbed page's name?

    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?
  15. Accesser

    How can a hard return & new line be added to a tabbed page's name?

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

    Auto set field equal to the number of records

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

    Automatically add new record, enter value, then close

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

    How can 3 tables be linked in many-to-many relationships?

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

    How can 3 tables be linked in many-to-many relationships?

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

    How can 3 tables be linked in many-to-many relationships?

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

Part and Inventory Search

Back
Top