Search results

  1. A

    Select All, Copy and Paste New VBA

    If I mentioned that I know I do not have a normalized datastructure... all of the information must go into a single table - I have no control over the table.... would I still be able to run a VBA to do what I am hoping is possible?
  2. A

    Select All, Copy and Paste New VBA

    I have a form with a subform, the form limits the qry and the subform displays the results. I need a VBA that selects all records, copies those records AND if possible, updates the first field (date) to the day after the copied date within the same subform. There are fourteen fields, the...
  3. A

    Question Dlookup default value with multiple criteria

    Thank you plog! The only problem I have now is that it needs to wait until the criteria fields (combo boxes) update. Should I be using a VBA code rather then entering into the default field? Also, the detail in your reply is so helpful!!
  4. A

    Question Dlookup default value with multiple criteria

    Query: qryWorkOrders (Area - Work Order - Task - Location) Form: frmMAIN Form: subDailySchedule - Datasheet Combo Box: cmbArea Combo Box: cmbWork Order Combo Box: cmbWork Task Text Box: txtLocation When Area is selected - Only the Work Orders in that area appear in the list When the Work...
  5. A

    Question Dlookup default value with multiple criteria

    First, I should say that I am new at creating access databases... my apologies in advance. I have a form with multiple combo boxes. Once the combo boxes are populated, I need the text box to look up the value in the query based on two combo box selections. I am attempting to do a DLOOKUP...
Top Bottom