Search results

DCrake - great stuff. It works well. At first I had trouble because of conflicts with the project name. I always used the default. Now I changed it to something unique. But now I'm confused. There is the database name (e.g. GlobalModule.MDB), the Project Name (which I also called GlobalModule)...

Thanks Guus2005. Its simple and its just what I needed.

Thanks for all the input. Pete's suggestion is where I began with all this. That was the obvious way to do this but I was looking for an alternative so that renaming of one of the queries would automatically result in the string getting updated. (The_DOC_Man's explanation is very insightful...

Does anyone have a function that, when called from a query, will return the name of that query? I need this for the following reason: I have about 20 queries that I run sequentially, each one adding its own records to a single common target table. If I have one column that shows the name of the...

But you entered that as a fixed string!

Put what in each query?

Thanks for your response but it seems like you just manually entered the name of the query. Thats not what I want. I want it automatically entered. I have about 20 queries that I run sequentially, each one adding its own records to a single common target table. When I look at that table I want...

When I run this query I want a new column to show the name of this query. Any idea how I can do this?

I mean also functions and also subroutines. How do I create a dll from Access?

Is there a way, similar to Excel's "personal.xls", to put all my reuseable Access code into one central module? Thanks in advance.

Thanks. Now I found it!

I found SearchInQueryDefs. Its very good. Only one problem: it seems to already exist in my database. I get the error: Ambiguous name detected. When I rename the function in VBA it works. How can I find where the twin is?

Thanks! Follow-up questions: 1) In your expression: DCount("*","tblWhereUsed","[fldPartNumber]='" & [fldPartNumber] & "'") could you explain then last part: '" & [fldPartNumber] & "'" 2) Where can I read up more on the Internet about using aggregate function?

I am a beginner with aggregate functions. I have two tables, one describing parts, and one describing assemblies that use those parts: tblParts show all the part descriptions, including fldPartNumber. tlbWhereUsed shows zero or more fldAssemblyNumber records for each fldPartNumber. I want a...

I did that but I can't see on the report the other two queries that reference this one.

The report is 27 pages long. Snapshot works fine - thanks. By "PDF'ing" it do you mean: while in the report's Print view, to print the report using a PDF-writer driver? Well if so, then that works as well. (I use PDF995). - thanks. In either case I prefer the rtf format because I want to append...

Compact & repair - DIDN'T HELP. Re-compile for errors - WHAT DO YOU MEAN? NO IT IS NOT A SPLIT DATABASE. IT IS A VERY SIMPLE STAND-ALONE DATABASE. When I run the Export - I see it going through the pages and at around page 24 it crashes.

When I export my report to rtf format Access crashes with the familiar "Microsoft Access has encounterd a problem and needs to close" message. Any ideas? Thanks in advance

How do I determine which forms, reports or other queries use a specific query in my entire database? Thanks in advance.

I tried <Ctrl><Alt><Prn Scrn> and then Pasted into Word but, along with the form window, it gave me the entire Access application window. ...