Search results

Instead of setting "hide duplicates" to true on my report, I would like to show all the duplicate values but have the first one formatted to stand out (bold, bigger font, or something of that sort.) Anyone know of a way to do this?

Thanks so much Pat. As usual, you are so right. I made the change and the query runs in about 1/5 the time without the Dlookups. Just want you to know how much I appreciate your help. As a "frequent poster" here, I do so appreciate your uncanny ability to get to the heart of each question and...

Pat, I would love to know a faster way to do this. Here's the SQL that I'm using: INSERT INTO FinalsImports_6 ( RefDes, DefectCode, TestDate, RepairsID, Qty, PartNo ) SELECT FInalsImports_4.RefDes, FInalsImports_4.DefectCode, FInalsImports_4.TestDate...

Hi, I am using Dlookup in a query in database A. I want to run this query from database B, via a VB .execute statement. But the query fails, with error #3078. I believe it's failing because of the DLookup. The table that Dlookup needs to use is, of course, in database B. My theory is that...

Hi, I am doing a Left Join to try to look up values in a large (about 100,000 records) table. If the value isn't found, I'm using the nz function to supply a value. This query runs very slowly (takes about 2 minutes). I can understand why... I suppose that for every value it's trying to look...

I don't think checking for the .ldb file will work, as most of these db's are set to open in exclusive mode.... then I believe that no .ldb file is created. Anyway, seems to be working OK now that I've changed from "goto" to "resume".

Never mind, I figured it out myself! I had my error hander using "go to NextDB" when it should have been using "resume NextDB". Using GoTo left the error handler active, so the next time it encountered an error while still active, it couldn't handle it. (Is answering myself worse than just...

Hi, I have code that cycles through a bunch of different db files, opening each one and peeking in it briefly for some info, then closing and moving on. If the db file I want to peak in is currently in use, I just skip it. The way I do this is through error handling, something like the...

Thanks, the link looks very useful.

And that is that.

Hi, Recently our IT department has upgraded my PC from Outlook 2000(?) to 2003. This has installed the Microsoft Office 11 dll (mso.dll) but since I still have all MS Office apps EXCEPT outlook, in the previous (2002) versions, I now have two copies of the Microsoft office dll on my desktop...

Thanks, but I can't see where this will help me. This seems to be a tool for entering dates, which I already have. What I need is a tool that will REPORT dates in a calendar-like format. By the way, I tried to order the tool from the aislebyaisle website referenced above, but could not get...

Can't see where that would be any easier. Using data definition query to turn "primary" off and on requires the same effort as turning "unique" off and on... am I missing something?

Hi, I would like to create a report that prints out as a monthly calendar, with customizable "appointments" showing up on appropriate days, as read from a table in my db. I want this to look like a typical wall calendar--- a box for each date, the SMTWTFS heading across the top, etc. I could...

I ended up solving this problem by 1. using data definition query to temporarily remove the primary key 2. Run the update query 3. Use data definition query to re-add the primary key. Seems to work fine. I'm sure that Pat's method would work fine too; I have never used data definition queries...

Thanks Pat, that sounds do-able. I would certainly like my serialno's to be permanent and unchanging, but am having to deal with and repair errors in data sent to me.

add 1 to the existing numbers. That is, change 1,2,3,4,5 to 2,3,4,5,6. I guess I can temporarily turn off my primary key, run the query, and then turn the primary key back on.

Hi, I have a table that uses SerialNo as primary key. From time to time (its a long story...) I need to go in and update the SerialNo by adding x to it. Here's the problem: lets say the table has SerialNo's 1,2,3,4,5, and I try to add 1. I get 4 KV error's because of course, 2,3,4,5 already...

Nope. Same result.

No, sorry I didn't make this clearer. This query needs to run from code, unattended, as part of a whole bunch of other stuff. The code will be cycling through a table and varying the parameter according to what's in the table. As I said, I DO know how to do this by copying the whole SQL string...