With extreme respect I would like to submitt that custom DAL's are all very fine if you're a one-man operation, but it strikes me that in a larger shop or...

This just saved my bacon -- had to restore a db from a gzipped backup without admin rights to a server.

Thanks!!!!

My brother and I were at our cottage last week and the septic system backed up. We needed to locate where the pipe went out of the septic tank...

Agree with Phil on ISNUMERIC especially -- unbelievable the language doesn't have a working function for this!

This opened my eyes to some interesting ideas Cindy -- thanks.

It would be nice to have a followup on how to create a webservice that provides the data that feeds...

Surely it's the Ark of the Covenant?

Thanks -- I had this problem too! The company I work for has things screwed down tight such that the public group can't connect to the db.

There's a lot of beefing and complaining going on here, hearkening back to the early 20th century when doubtless the same complaints were heard about the Ford assembly line:

1. ...

I worked building barns and whatnot for a few years. The guys I worked with taught me how to hold a bunch of nails in my one hand, using...

I have long been a proponent of a box with a door on it rather than the "open concept" that seems to be so popular with management.

This seems to be...

I tend to agree with the poster who said we shouldn't be too harsh on someone whose native tongue isn't English.

One comment though: put the queries just before...

Isn't there an error in the first example?  Shouldn't the last record in tblsection join to the 4, Test record in tblModule? 

I think...

Dear Newbie;

First of all, I must say that the script below I scammed from somebody else -- apologies to whoever you are!

In the interests of coaching you with proper form,...

We know!

I'm assuming you have a reference set to the excel library so you can access its types.

so the following would work

Dim MySheet as Excel.Worksheet

Dim MyBook as Excel.Workbook

MyBook:="C:\temp\book1.xls"

For Each MySheet...