Search results

Hi Folks! I've been asked to make a 5 questions test to evaluation potential new employees' knowledge of MS-Access. Honestly, I need your input on what to ask. The goal is not to make a very hard test, but rather to see if somebody as at least basic knowledge of SQL and Ms-Access. Some...

Hi everyone! I'm using Access to generate an Excel file. I'm exporting my query in Excel format. Then I open it in Access and do a bunch of cosmetic changes (such as making lines, bold titles, etc). I'm also creating comments inside the Excel file based on information stored in a table. The...

I lost a table in my MS-Access. Is there anyway to undelete the table once the database was closed? I appreciate any help you may have.

I have a table that goes like this (this table tells us what minimum we can order from a supplier): SUPPLIER PRODUCT ORDER_QTY ORDER_UNITS SUPP1 CHEESE1 200 $ SUPP1 CHEESE2 200 $ SUPP1 CHEESE3 200 POUNDS SUPP2 CHEESEA 200 $ SUPP2 CHEESEB 250 CUBES...

I want to output a query that uses parameters. How do I do that? Let's say I have 2 parameters, PDIV and PWHSE. How do I change the following line of code to use the parameter? DoCmd.OutputTo acOutputQuery, strQuery, acFormatXLS, strFile, False

I wish to use one of my database (call it DB #A) to import ODBC tables into a second database (DB #B). From what I figure, I can't directly import into another DB. I'll have to use these steps: 1. Delete Link in #A that points to #B.Table. 2. Import table in #A. 3. Delete Table in #B. 4. Export...

I want to compact the database currently opened with VBA code. I do a lot if import, update and delete in a very amount of time. By comptacting, I hope to reduce the filesize of my DB. In the last line of my VBA function, I added: DBEngine.CompactDatabase "M:\ACCESS\REPORTER.MDB"...

I have a weird problem. When I click on my button to launch the event, it runs through some of the code. It then stops on the same line, without it being a breakpoint. This error seems to come and go. Any idea what the heck this is?

Thanks in advance for any help you can provide me with. As some of you may know (I've posted about this before), I export a lot of queries/table to Excel. I saw in the sample database section, someone posting code about using an Excel object through VBA in MS-Access. Exactly what I need to...

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

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

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

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

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!