Search results

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

Thanks for responding to my questions! I was aware that you can see what modules are using a table but was hoping that I will be able to drill down further.

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?

Thanks you so much - your advice where spot on!

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

That is strange because when I tried to create a second AutoNumber field on the table I got an error saying "Microsoft Office Access allows only one autonumber field per table" To answer your question of why: Table A currently contain 395615 records. When I import the next 10420 records it...

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

Thanks you very much for the feedback. The stuff in the brackets is not on a table. Thanks my question was answered.

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

Thank you very much - your answer is doing exactly what I wanted!

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?

Thank you very much for responding and answering my question!

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

Thanks you very much - your advice was very helpful. I tried to add to your reputation but got the following message: You must spread some Reputation around before giving it to namliam again.

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?

Thanks you very much for your feedback! The AGT Footer contained a "Force New Page" of After Section that I changed to None and the problem was resolved. Thanks for the help!!!!!!!!!!

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