Search results for query: *

dhookom: I'm going agains the backend of another application, using Access to both select records (from the Tasks table) I want to update, and then to Update them from a local employees table. The Task IDs are always assigned in order, but I may be getting Tasks 1, 7, 1005, because the...

I have limited VBA skills. How would I do this? I couldnt' find any documentation on the modulus operator.

Thanks for the notes. Here's a definition of round robin, answers to the above questions and an example of how the records should look: ROUND ROBIN: A round robin is a logical arrangement of "turn taking" within a computer environment. In a web server setting, for example, two servers would...

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

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

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

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

I could create associative tables to get down to 1 key field per table, but would this solve my problem...also, not sure I could do that w/o a lot of rework. Any thoughts along this line or alternative solutions are much appreciated.

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

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

When I tried the above I get prompted for both claim_folder_id and for Forms!FRM_AUDIT_CLAIM!SUBFORM_AUDIT_CLAIM_ITEM!SUBFORM_AUDIT_ITEM_DETAIL!audit_claim_folder_id ADDITIONAL INFO I should mentioned that the subform on FORM 1 is displayed as continuous forms and thus has multiple folder...

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