Search results

  1. A

    Update Record 1 with a value on Record 2

    Let me first start by apologizing for this vague question. Unfortunately I am so ignorant that I do not even know what to ask for. I tried to look for the answer but each time I read an article I get even more confused. I am trying to do the following but have no idea where to start: I have...
  2. A

    Can you see what modules use a field in a table

    I was wondering if anybody knows of an option in Access where you can take a field in a table and identify all the modules that use this field?
  3. A

    Identify records that are on 1 table but not another

    I am trying to identify the records that are on Table1 but not on Table2. After I have identified these records I want to update Table2 with these records. My questions (and please feel free to laugh at my ignorance) are: 1. What query type do I need to use to identify the records on Table1...
  4. A

    How do you populate a number field with an incrementing number?

    In an existing access database there is a macro with an action = TranferText that import a file into table A. The last field on Table A is RECCOUNT (Number). This field is not in the import file. Is there a way that you can use the Default Value to populate this field with an incrementing...
  5. A

    What triggers the parameter input box on a query

    I have the following query: SELECT [20 AGENTS].PER, [20 AGENTS].BRANCHKEY, Sum([20 AGENTS].GWPREM) AS GWPREM, Sum([20 AGENTS].GEPREM) AS GEPREM, Sum([20 AGENTS].GCINC) AS GCINC, Sum([20 AGENTS].NWPREM) AS NWPREM, Sum([20 AGENTS].NEPREM) AS NEPREM, Sum([20 AGENTS].NCINC) AS NCINC...
  6. A

    How do I find out what objects are using a specific form

    My aim is to find out what a specific function is doing. When I ran the access database I could see the name of the form that is being used. Can anybody tell me what access function I can use to find out what access objects are using this form?
  7. A

    Question on TransferText Action in a Macro

    I have an existing Macro that contains the following action: TransferText Transfer Type: Import Delimited Specification Name: STAT01 Import Specification Table Name...
  8. A

    Where on a Make Table Query can I see what file will be created

    I am looking at an existing Macro that contains an entry: OpenQuery - 002 Company Export (This is a Make Table Query) I looked on the above mentioned query but cannot see what file will be created by this query. Could somebody be so kind as to point me in the right direction?
  9. A

    How do you remove a page break

    In my ignorance I have tried everything without any success. I am looking at a report that contains the following sections: Report Header - This section contain no info Page Header - With column names of AGT + NEP AGT Header - Not sure what this is but this section contain no info...
Back
Top Bottom