Search results

  1. F

    Calc total subtotal on subform with continuous form

    Hi all, I have a project with a parent form called Projects. Inside projects there are multiple tabs with continuous subforms. On subform has a field in place to total the other fields. So I have some code that totals all these fields on a button click. Sub Admintotal_Click() Me.Total =...
  2. F

    Possible to copy/paste dirctory structure?

    I have created a database that my company uses for project proposals. Of course associated with any project is multiple documents that get stored in numerous locations. I have created a blank directory structure that I copy/paste for each no project to the shared server drive. Would it be...
  3. F

    DLookup on error Form

    I have used the DLookup function many times in VBA, but I am trying to use it in a slightly different manner this time and I can't figure out wheat I am missing. I have a table called MarketRates, it has 2 fields; CCode and Rates I have a form that I want to look up the rate based on the code...
  4. F

    Append Query: Only append 1 field

    I am trying without any success writing an append query in my database. I have done it many times before but not with such a limited scope. I have a main table called zEMPMain. This is the main data storage. I have another table called CICMH. This is the table that I want to append new...
  5. F

    VBA Creating Relationships

    Greetings all, first time on these boards. I have been desperately trying to figure out a way to create relationships using VBA as I have a load of them to do. I have a base code built that I need to replicate, but I am getting hung up on a small error that is occurring. I have a main table...
Back
Top Bottom