Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JeremyNYC

    Trouble with Left Join

    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.
  2. JeremyNYC

    Trouble with Left Join

    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...
  3. JeremyNYC

    Removing Border from Image that is a Link

    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...
  4. JeremyNYC

    Power Manager: Is there a config file?

    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...
  5. JeremyNYC

    IE Divides My Div

    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...
  6. JeremyNYC

    IE Divides My Div

    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 ---...
  7. JeremyNYC

    IE Divides My Div

    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.
  8. JeremyNYC

    IE Divides My Div

    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...
  9. JeremyNYC

    Unbound and Bound in ADP

    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...
  10. JeremyNYC

    calculations on query results

    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...
  11. JeremyNYC

    IE Divides My Div

    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...
  12. JeremyNYC

    MS Access Security

    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.
  13. JeremyNYC

    calculations on query results

    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...
  14. JeremyNYC

    Which is Better ?

    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...
  15. JeremyNYC

    Which is Better ?

    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...
  16. JeremyNYC

    pass the current record to the next form

    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...
  17. JeremyNYC

    Using '=' in VBA

    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
  18. JeremyNYC

    Using '=' in VBA

    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...
  19. JeremyNYC

    Cmd to open AddTable Dialog (A2K/SQL Server)

    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
  20. JeremyNYC

    Using '=' in VBA

    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...

Part and Inventory Search

Back
Top