Recent content by susor

Followup Jim -- You might have known this followup question was coming. I don't have the Access Developer Edition here, just regular old Access 2000. Is it pretty much impossible to do this without the Developer Edition? Scott

Jim -- Excellent -- that's what I needed to know -- thanks again for pointing me in the right direction! Scott

Jim -- Thanks a bunch! Awesome article! Now, before I jump head first into this thing, I noticed that this methodology is Active X oriented to pure Visual Basic code. Does its functionality apply identically to Access VBA code? Scott

Whoa! Jim, that stuff flew right over my head! LOL! I'm not sure about what those links should tell me, but I can't seem to relate their content to what I'm trying to do in Access VBA. They don't look like Access VBA to me but maybe I'm missing something. Scott

From Another Thread ... I was able to piece this together ... ******************************* Private Sub DownloadOIG_Click() On Error GoTo Err_DownloadOIG_Click CopyFile "http://oig.hhs.gov/fraud/exclusions/downloadables/updatedleie.EXE", "C:\NHDB\OIG.exe" Exit_DownloadOIG_Click...

Resurrecting This ... This is an old thread I dug up because I have the same need and this thread appears to have been abandoned without solution two years ago. Is there a way to download a file from a web site to a specific folder on C: without the download dialogue appearing? Scott

In my case, its one table with three 1-to-many's, plus one of the children has a 1-to-many with one of the other children. Don't ask. I didn't design it. There are also a couple of other things in the query such as a min function (looking for the earliest record of a grouping) and a...

Similar Problem I have the same problem except I'm joining FOUR tables. All have primary keys but I am getting the "Recordset is not updatable" message when I try and update. Is there another reason besides the lack of primary keys that would cause this? Scott

Problem Solved! It was the short circuit between my brain and my keyboard. I had changed the place to LOOK FOR the file, but I didn't actually change the place where the file was going -- two different things. Somebody please shoot me. :) Scott

I'm doing something new here -- well, new for me anyway. And I'm far from a network guru so I need to know if this can even be done. I'm trying to drop a .doc file (report) into our fax software (LightningFax). In testing I dropped the .doc file into the same folder as the Access database on...

I am trying to output a set of two files for faxing into Lightning Fax software. The first one (report) is coming out just fine. However, the second one (fax data header) is giving me fits. Two problems: (1) On its first pass, it creates the record in the "Header_Master" table OK but when...

AncientOne -- Thank you for the addition. Actually I did need the different variations and from dcx's code I was able to expand my searches to what I needed. I guess I really just had a brain lock on getting the basic code snippet from my head (English) to the box (SQL). Scott

dcx693 -- That did it! Thank you so much! Sometimes its amazing how somebody else can look at something and see how it needs to be done instantly. Great job! Thanks again! Scott

This SEEMS simple, and I know it can be done with TSQL in ASP because I have the working program in front of me. But ASP uses a strquotereplace function and that doesn't exist in MS Access SQL. Anyway, here is what I need to do ... Table1 has a field called LastName. Table2 has a field...