Search results

First, it's company policy to not link on the mainframe. It's not my decision, and I'm not here to defend that (as pointed before). And no, I can't get to change their minds. My initial question was if there was an easier way to do this, which meant importing directly into another DB (or in...

Let's make a test. If you remove your where clauses, can you save it?

Then where are the =<> IN signs? What do you do with these values? Unless I'm mistaking, you just can't say WHERE NAME. It helps to say WHERE NAME = "Bob".

It never was a link problem. The only link I talked about, was between DB #A & DB #B. Perhaps I wasn't clear. The imported table comes from Source #C.

What is this suppose to accomplish: ([Forms]![BemExceptionsQueryForm]![Descritption] & "*")? I don't get your WHERE statement.

What I do is this: 1. Create a copy of the table (structure only) 2. Execute a query like this: INSERT INTO TABLE2 SELECT Name, Address, Etc From TABLE1 GROUP BY Name, Address, Etc 3. Replace the old table by the new one.

You suggest that I have a dummy table in DB #B, and use an insert to populate it, with an SELECT statement to my ODBC table. This would be fine if my table was from Oracle, MySQL or other more "standard" sources. It comes from a mainframe. The way it is set, I can't link to it's data (or risk...

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

Do your fields from the SOFTWARE table accept Null values?

Another possiblity could be to simply format it in the queries. For example: SELECT 'MT' & Format(ID, '0000') as MyID FROM ...

This could be possible, through VBA. I'm not sure this would be the fastest or more normalize, but it should get the job done. 1. Import the Excel spreadsheet into Access with an autoincrement ID number (supposing your Excel file doesn't contain the MT001, MT002). 2. Add a column to the...

Have you tried the TOOLS\Database Utilities\Linked Table Manager?

Please, please, oh please, never use FrontPage. I'm not a anti-Microsoft programmer (heck, I like Access!), but FrontPage is an aberration that deserves to be dealt with. It messes up HTML like no other. To answer your question, the answer is No. FrontPage is not a part of MS-OFFICE. Have you...

Have you looked at the function DateDiff? It would be a great start. Also, try searching the forum. You should find a couple of nice answers to this.

Create a subfolder \ICO where your database is. Copy all of your .ICO files there. If they have access to the DB, they should have access to the .ICO! Note: Use the full path. For example, use \\Server1\Bob\DB\ICO instead of D:\DB\ICO.

Instead of "", you could use the constant vbNullString.

FYI: In a query, you would use [FIELD] is NULL.

First, go to the Microsoft Visual Basic Editor. You can do this by right clicking almost anywhere on the Database Window, and selecting "Visual Basic Editor". Next, once inside the editor, click on TOOLS, then REFERENCES.

First, evaluate the number of hours you worked on it. No matter what salary per hour you want, you'll need this. Since you already work there, you could go for your salary. Your boss will probably not complain and will easily understand if you say "I worked 100 hours on it, pay me 100 hours for...

Keyword here: Link Table. This is how your front-end databases will know where to look for. If you need to refresh this link, or make sure the path is still valid, you go to TOOLS\Database Utilities\Link Table Manager. And yes, you can test this on the same pc, or at home.