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...
...file for that. I've tried googling, but there are so many products for power management that it's been difficult to find meaningful results.
SO...
* What I'm Looking For:
** File path and name for a power settings config type file for Windows 7, Vista, XP
* What I've done so far:
** Google...
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...
I didn't read all your code, but...
Does the first form stay open? If not, you can leave it open, making it invisisble instead of closing it.
As long as the first form is open, you should be able to refer to any of the fields there, from the other form, like this:
Forms!FormName!ControlName...
Yup, it was the Peter's Software link that I remembered.
---
Jeremy Wallace
METRIX Lead Developer
Fund for the City of New York
http:// metrix . fcny . org
Lori,
Ahhhhhh.
I would probably just make a look, sort of like what I've got, setting all of the colors to the default*, and then set the color of the one you want to highlight. Of course, this still assumes that they're named in some sort of scheme with a number at the end. If not, maybe...
Randall,
Thanks. That, unfortunately, creates a new table, which is not what I want. I just want to add an existing table to a query.
Jeremy
---
Jeremy Wallace
METRIX Lead Developer
Fund for the City of New York
http:// metrix . fcny . org
No, I don't think there is. If you happen to have named them something like
txtYadda1
txtYadda2
etc, then, if you really wanted you could do something along these lines (I'm writing this here, with no testing, so be sure to test this yourself...)
dim intCountFields as integer
for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.