Thank you for this extremely useful script. I was just setting up our new server and had disabled some notices in procedures pending learning (again) how to set up email...

Hmmmmm...OK. I gotta learn some more stuff.

I will investigate this and follow up with whatever I can master, as improvements, when I understand it well enough to apply it....

Extremely helpful article. Exactly what I needed at exactly the moment I needed it. See my post in reply above for more detail, but in summary I am...

I can see immediate usefulness in a project where I intend to use it today: I have large tables in Access database spread all over the country. Ancient app,...

Outstanding post! I have been annoyed for years that what we did in MS Access with no effort whatsoever took so much fiddling in SQL Server. Talk about...

Since you formatted your openargs string as "paramname=paramvalue;", I'll mention to the OP, who may not know, that the routine adhGetItem, and its siblings adhPutItem and adhDeleteItem, are very useful...

The question's a bit vague.  Do you already have tables in another database and you're trying to link to them to use a form with them?

Or do you want to...

You're welcome.

You wanted a count of how many bids were included in the same session_id.  that's teh count.  YOu can actually count any column that is guaranteed non-NULL.

SELECT Bids.Session_ID, Count(Bids.Bid) AS CountOfBid, Sum([Price]*[Quantity]) AS PriceTimeQuantity

FROM Bids

GROUP BY Bids.Session_ID;

Would that get what you're after?  Counts the bids by session id at the same time it calculates and sums...

Damn!  Where do I send my 50 cents?

For starters, there's only user information in a system mdw if you're using access group/user security.  (It's always on, but unless you set up groups and users and strip permissions...

Oh yea - command buttons have the hyperlink address as well.

You can also stuff the path into the hyperlink address property of a hyperlink type label.  You click insert on the menu bar, and insert a hyperlink.

I think you can...

I'd bet 50 cents that you have a Bit field somewhere in the table, and that it does not have a default data value, and that you have at least...