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 Shaun E 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: mbannen
  • Content: Threads
  • Order by date
  1. mbannen

    ROUND ROBIN: How to assign values from one table to another

    I have two tables: Table one: Tasks Table two: Employees Within the Tasks table is an Assigned To field. Imagine there are 100 tasks and 10 employees. I want to file the ASsigned To field in the Tasks table with names from the Employees table using a round robin approach. I don't know VB...
  2. mbannen

    Refresh multiple subforms at same time?

    from a main form (form_main) I open another form (form_not_main). I modify data in frm_not_main and close it. I then want to refresh multiple subforms on frm_main (the subforms calculate values based on data modified in form_not_main. Tried a whole bunch of refresh things on every event that...
  3. mbannen

    How to create N copies of a record, and randomize some data

    GOAL: Enable users to create a user-defined number of copies of record, while randomizing certain data within the new records and appending those records to a table. I have two tables: tbl_source tbl_run Users enter data into tbl_source via a form (frm_enter_data), which writes the entered...
  4. mbannen

    Reserved Error -1517: can't run append query on linked spreadsheet

    Just started getting this error message today. Factors to consider: - have an access data with 20 some excel spreadsheets linked into it - have a copy of the database in 97 and a copy in 2002 - the spreadsheets are in Shared Workbook mode, and are being used by both Excel 97 and Excel 2002...
  5. mbannen

    Unable to edit records > how to fix??

    I have two tables 1) TBL_CLAIM_AUDIT_DETAIL 2) MCT_AUDIT_ITEM I want to pull in audit_cat_nme (category name) from MCT_AUDIT_ITEM (table 2) and still be able to update audit_item_status in TBL_CLAIM_AUDIT_DETAIL (table 2). But it ain't workin'. Here's the query: SELECT...
  6. mbannen

    Capture value of field w/focus, use value to open another form

    I have two forms, each with sub forms. The first form's subform is displayed as continuous forms and contains a value called 'folder_id'. I want to enable the users to click on a folder_id and open another form/sub-form, displaying only records for the clicked-on folder_id. The second form...
  7. mbannen

    Open a form based on the value in the first forms subform

    FORM # 1 I have a main form (FRM_AUDIT_) that contains a sub form (SUBFORM_CLAIM) that has a value (claim_folder_id). I want users to click on the claim_folder_id to open another form (FRM_AUDIT_CLAIM) where the claim_folder_id on form #1's sub form (SUBFORM_CLAIM) is equal to the folder id...

Part and Inventory Search

Back
Top