Recent content by AccNovice

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?