Search results

Rats! I didn't want to do that but I guess I have to. Thanks :)

Got it from a tome on SQL I have, "The Complete Reference SQL", ISBN 0-07-211845-8. I think I used it once or twice waaaaay back in college. Here's a search result I found that may help explain it (click on "Set Operations" in the TOC links): http://hsqldb.org/doc/2.0/guide/ch07.html It would...

Can MS Access perform the EXCEPT or DIFFERENCE clause? If so, what is the Access version of the syntax? TIA!

Oops, you're right, I should've added the file extension :o I initially didn't use one and it worked fine. Great idea about the documentation! :cool:

Re: "there isn't enough memory to perform this operation" SOLVED! I had the same issue :mad: I added a Label to a completed form and !bam!, I got this error message and couldn't get the form back...which was a lot of work to create. After searching I came across this...

Yes, everything dimensioned and set and like I wrote above, everything is being populated as checked by the Locals window. The variable DriverName was assigned the name of the ODBC connection. I just changed that value to the one you mentioned (and is in my documentation as well) to WebTrends...

I haven't and I don't know how. Just found out that WebTrends has a proprietary "db" that is essentially a collection of flat files :mad: What one 'pings' to get data from the WebTrends data source is just a bunch of files, not a real db:( Don't know if that helps any.

The documentation doesn't give much. It's for a WebTrends database and though it does use SQL it is a a little limited e.g. it doesn't support JOINs nor GROUP BY. From the text for the ODBC section: It further states ADO is the only way to access the data and the database is an ODDB, which...

I have a small VBA module that pulls data from an ODBC data source and appends the data to a local Access table (from this thread: http://www.access-programmers.co.uk/forums/showthread.php?p=607605#post607605 ). It works as long as I have a Linked Table from the ODBC data source. If I remove...

Thanks Paul. Your code, along with the Help VBA example for .AddNew, I figured this out (it works!): Do Until objRecordSet.EOF 'Go thru each record until we hit the EOF marker rsTable.AddNew 'Sets up a spot to add a new record in local designated table For i = 0 To...

Your first idea is good but I want to perform all the operations w/in VBA. I really don't have much idea how to do it so, yes, I would appreciate more info, particularly on your second suggestion of opening a second record set. I haven't done a search yet but any recommendations on books for...

Just a note, I'd still like to know how to do this (my original question). It's very possible this could grow and I'd like the know-how.

Beaverton. Kinda between Tectronix and Nike. That's one heckuva commute you got!

Hehehe, you're right Paul, ya got me! It's been YEARS since I've had to perform proper database design. Thanks for the reminder :)

If you go into the VBA editor in Excel and access the Help there you will get information about the pivot cache object. For example, I found the following that may be of use if you can't pull directly from the Excel sheet: You could have Access open the Excel wkbk object, save the specific...

First, I'm very handy with VBA for Excel but basically a beginner when it comes to VBA for Access. I have established an ADODB connection and can pull data with VBA in Access 2003 (XP OS). I have the following code: ... Set objRecordSet = objCommand.Execute 'Pull the record set 'Test Do...

I have an import specification and it works fine. It is used for a .csv file. My end user has changed their output of the .csv file. The fields are the same, however, the order has changed. Naturally, this causes a stink with the designated Import Specification. Is there an easy way to...