Search results

Nigel- Excellent idea. I was starting to look into vba coding and stepping through recs. I like your technique. I am going to modify it a bit. After A_HS is loaded into the new table, I'll mark records in B_HS which match in the new HS table. This way I can filter out all those in B which...

I'll try the union something like: select distinct hs.name, hs.city, hs.state into new_hs. union both tables w/ new hs_id. then go back and match hs_a by hs.name, hs.city, hs.state and create a cross-ref table of old id to new id. do the same with hs_b. that may work. I'll see. There may be...

A dup is same Name, City, State The tricky part is the id numbers are not relliable cross both db's. They do not match. the id number may or may not be the same in both db's. So a union is good after both tables are cleaned up of dups. Then, B_HS could union append. I just can't loose the...

My head is spinning from reading posts from every website on the best method for deleting dups. I could use some direction on the best method and sql/vba code to do this: I have two dbs, I want to merge these 2 high school tables. Problem is each table has dups and then I want to merge as...

Thanks guys! I do like the MOD version. Something an oreilly book would use :) Speed is always good, so I'll use the multiple open vs. Filtering the recordset. FYI- Found this good example on DAO filtering of recordsets: http://msdn.microsoft.com/en-us/library/ff837300.aspx

THANKS! Sounds like 10 open queries it is. I wonder if maybe bookmark with filtered set of 10 then do processing, go to top of loop and bookmark a filtered set of 20 then do processing. Mmm. I think in ADO you can do something like this with seek or find.

I searched all over for a good example of filtering a recordset then refiltering and want the most efficient way of handling the following: I have query returning all people as level name 10 smith 20 jones 20 jackson 40 simpson so my db.OpenRecordSet ("qryAllPeople") will give me...

Strange. But my local pc test works without the Microsoft CDO library checked in the references tab. Is this because outlook is loaded on my laptop or is the CDO class defined in another microsoft access library??

I'll see if they can load outlook. They do have a MSDN subscription to everything. They may balk at IIS being installed. From what I read and searches there is no sendmail like dll/utility already installed on an xp/win7 virtual pc. SO-At a minimum, I need to run the cdo solution (install...

I have a client with their access db on a virtual machine running only access. They use a terminal service to connect. This pc does not have anything else installed. No outlook, no other apps. I need to send mail and am required to use smtp. I have the code to send via smtp 2 different...

I wish my client would just use your example db. The grid reservation works GREAT! I may try to import my clients tables and see if they bite on switching over. Then simply add the calendar report. The best of both worlds - form & report charts! Thanks!! I'm rollin' now!

I may just export the results to a spreadsheet and format the 'print chart' using this excel template updated: The excel template is nice, but my users may not be savy enough to export from access and use excel. I would rather have them stay in access. AND I wanted to have the start/end date...

On a NY radio interview with John Lithgow (back when 3rd rock was hitting its stride), The dj asked what was the best film, tv, or show you were in. The dj rattled through the bio-spec sheet in front of him.... John Lithgow chuckles and immediatley said "Buckaroo Banzai, it was the most fun I...

Coach- The Orchid DB is great. I now have to think about taking my existing db and importing tables and reports into this one. I like how the arrow bmps are hidden in the form and simply switch pix via code. nice. If anyone else has suggestions, I'd love to hear/see them. I'm going to keep...

Any suggestions on making a gantt style chart for reservation system? I'm thinking of doing cross tab so I can sum by room number, but could use your help so I don't spin my wheels on crosstabs as they are so much fun :) also-I was thinking I need to sum by week in the query to create the...

I have the same issue. One PC is XP w/ 2.81 and two others are Win2000 with 2.7 Is there any issues with loading 2.81 on Win2000? or should I only load 2.80. Thanks.

Thanks Gromit! 'Dats da ticket! Made a slight mod to first clear out the table then execute the append query. (I changed from a maketable to an append query so I don't have to check if the table exists before deleting it.) Also added a parameter because the query has a filter using a form's...

All I want to do is run a make table query (or append) and show the user how many records were processed. If I try to set recordset equal to the qdf.Execute I get the Compile error "Expected Function or variable". I'm not sure what I'm missing...I've searched numerous threads and tried...

We use dreamweaver for our website development. We wish to have users register and log their downloads of pdf's in an access database (web host won't support mysql). I then want to extract the user info to create new records in exchange public folder or append to a user a note showing what they...

Very strange. It appears access believes two rows are "identical" even though there is an autonumber field. And I added an "oldid" field as another index. Still getting the error message. These four fields can NOT be identical on two records; If I make 1 small change to any of these four, the...