Recent content by JeremyNYC

Ugh. Answer found three minutes after posting. Ouch, ouch, ouch. Sorry. https://dba.stackexchange.com/questions/215326/left-join-with-where-microsoft-access-sql --- Jeremy Wallace ABCDataworks You can find us on the web, and my e-mail is fairly easy to guess.

UGH. As noted below, I found the answer almost immediately after I posted this. It's a long post, so I'm top-editing to save people the time it would take to read through this all. Hi folks, Way back in another lifetime I spent a ton of time here helping folks with their problems. Now I'm...

This should be easy, and I've done it plenty of other times, but it's not working this time. Maybe this is because of the table? I'd like to not monkey with the table, but if I must I must. The following is a snippet of the code from an email I want to send using VerticalResponse: <!DOCTYPE...

I run a non-profit where we run creative writing workshops for kids 8 to 18. We have about 50 laptops. They're not all Windows 7, but some of them are, so I chose this forum. If there's a more appropriate forum, please let me know. I have a standard configuration I use for all of the laptops...

I just undid the fix and it still validates. Hmmm. I'll leave that page broken for a little while, in case anyone is interested enough to play with it and figure out why the validator didn't catch it. For now, though, I'll just say thanks again to Vragabond for finding the error of my ways...

Excuse me while I cry a little. Good to know that simple mistakes here in the land of HTML can be just as devastating as those in the land of VB, SQL, and anywhere else I've got experience. Thanks much for finding that for me. I'll try to catch the next several dozen on my own! Jeremy ---...

Oh. Yeah, sorry. That was dumb of me. I was trying something else out, and I put it at that same URL. I've moved the pages that were giving me trouble back to that URL. Jeremy --- Jeremy Wallace ABCDataworks You can find us on the web, and my e-mail is fairly easy to guess.

Thanks for the response. I did have that stuff in the main page, I just didn't show it here. But removing the body tags from the footer only managed to make the footer look broken in both browsers. This is definitely an improvement, as it will make it easier to fix, though I'm still not having...

A bound form can support 25, 50, or 100 concurrent users, depending on several factors: * the quality of the code * the quality of the network * the size of the data set * the complexity of the task being performed by the form. Jeremy --- Jeremy Wallace ABCDataworks You can find us on the web...

Ah. Sorry, I didn't get that when I first read your post. It sounds like you'll have to use a subselect (or a couple of queries) to get this. To get the second date, you could do something like this (aircode): SELECT tblToolUse.ToolID, MIN(tblToolUse.DateUsed) AS FirstDateUsed...

First, I'm a database guy getting my feet wet with HTML, CSS, PHP, and whatever other letters I can find lying around. I've done a bunch of looking to try to solve this problem, but it's quite likely that I just don't know where to look. Sorry for the newbishness, but here goes... I'm...

Have a look at the stuff on my site: http://abcdataworks.com/security.htm DEFINITELY read the white paper before doing anything with security. --- Jeremy Wallace ABCDataworks You can find us on the web, and my e-mail is fairly easy to guess.

Hmm. I thought I'd posted this, but this SQL should work, if you rename things: SELECT tblToolUse.ToolID, Min(tblToolUse.DateUsed) AS MinOfDateUsed, Max(tblToolUse.DateUsed) AS MaxOfDateUsed FROM tblToolUse GROUP BY tblToolUse.ToolID; Jeremy --- Jeremy Wallace ABCDataworks You can find us on...

First, I'm not entirely sure it's correct that it will pull all the data across and then filter it. I'm pretty sure that's not true, though I wouldn't stake much on that bet. On the next question, there is a negligible performance gain to using a saved query or saving the sql in the property...

With that few users and that few records (50,000 is a small number), there's no real need for MSDE. Vich, it sounds like the you are asking whether to use a bound form or an unbound form. While an unbound form gives you more control over what's going on, it requires a lot more work. Even though...