Search results

I have 3 tables containing with relatively the same layout. I wish to extract the ID of each of these tables using 1 query (that I could later use to access all of these IDs). Joining these tables is not an option (it would probably be too easy!). Any leads on how to proceed? I know how to do...

Trying to debug this, I can see that it is only when I enter a criteria that the pop-up show up. Without it, it runs fine. Any clues?

I have a somewhat complex query. I calculate the value of field [MFCFCST_CS]. If I run it like this, no problem. I have the good values. In the next column, I use it in another complex calculation. When I try to run the query, I have a pop-up, asking me the value of [MFCFCST_CS]. I'm quite sure...

Technically, it won't be a number value. It would be a text value. Table Example Field1: AutoNumber Field2: Text (formatted autonumber) With some VBA, when a new record is created, you could fill the formatted autonumber automatically. With some code looking like "24E" &...

Ever thought of using an AutoNumber? You could have a table containing only that field. This answer is so simple, that I fear I misunderstood your question.

I export a lot of queries or tables to excel files. I want to format them (having column titles in bold, for example). Ideally, what I would want, is to have tables containing what kind of formating [X] file would have. Using VBA, I would format it. Before doing all of this work, is there some...

Thanks, it works. Is acSpreadsheetTypeExcel9 for MS-Excel 2000? It's kind of very blurry on that.

Hi everyone! Thanks in advance for any answers you can give me. I would like to export the data of 2 tables in the same XLS files, but on different Sheets. I have figured out how to do it manually, but I need to code it. So far I've tried exporting to an existing file, but it overwrites it...

The previous employee who's job I'm currently occupying locked the VB modules of several MS-Access 2000 files. I can open the database normally, just not see what the code behind the command buttons of the forms are like. As you may well imagine, I have no clue as to what password he chose. My...

Thanks for the feedback. You've all been very useful. I'm mesmerized by the fact that running a query can automatically output the result in an Excel file. Any idea how it's done? The help file isn't very useful on this. I would suppose the Query would have properties, stating such things.

Don't worry, already did! 2 Gigs hey? Not that bad. Since I may have many newbie questions, I'll post them in this thread. Can you export an SQL query directly to Excel, without running a Macro or VBA Module? There seems to be a lot of this in my databases.

Try to open the database from a co-worker's workstation.

New poster here, but be sure I'll be posting a few times each week since I'll now be using MS-Access for a lot of things. I would like to know, what size limits has an MS-Access 2000 database? If there is one, of course!