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!

  • Congratulations Chriss Miller 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: *

  • Users: JeremyNYC
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. JeremyNYC

    Cmd to open AddTable Dialog (A2K/SQL Server)

    Anyone know how we can open the add table dialog in an Access 2000 ADP that's using a SQL Server back end? We've got the toolbars and menus locked down and are using custom ones. When they open a view in design view (via a query manager form), we run code to show the correct menu and toolbar...
  6. JeremyNYC

    Rename a Report in an ADP I've Set a Reference To

    I've got an application with an ADP front end and a SQL Server back end. To enable the users to share reports, there is a separate ADP that sits on the file server, and the front end file (one on each desktop) has a reference to this file. Because our release date for a new version of this is a...
  7. JeremyNYC

    Tab Caption Goes Away

    I've got a multi-page subform with a tab control on one of the pages. The code that moves you from page three to page four, which is where the tab is, changes the tab captions according to some information stored in a table. Only it's not working. Actually, it is working, and then it's...
  8. JeremyNYC

    Is a Job an Acceptible Solution?

    I'm an experienced Access developer working on my first SQL Server back-ended project (Access adp front end). It's a large, open-source (well, except for Access and SQL Server <g>) database for non-profits. There are some parts of the application that we expect people will play with, and some...
  9. JeremyNYC

    Reset User Password Without Knowing Original

    Is there a way for sa/dbo to reset a user's password without knowing the original? I'm an Access/Jet guy, and it's easy peasie over in that world. I've looked around and found sp_password, but that requires the original password. If there's not a way to do this, doesn't this create all sorts of...
  10. JeremyNYC

    Menu Bar Order

    I know I should know how to do this, but I can't figure it out. Last week at some point, my menu bar got moved to beneath my toolbar, and I can't get it to stay above the toolbar. Every time I open Access it's Tools over Menus, even if I just open Access, change the order, and close it. I tried...
  11. JeremyNYC

    Can't See Images...Sometimes

    Win XP Pro IE 6.0.2800.1106.xpsp2.030422-1633 Sometimes I can't see images, I just get the x. I'll try to load just that image file and I can't see that. I can see most images, most of the time. On my.yahoo.com I can see all of the images except the cartoons at the bottom (I don't care about...
  12. JeremyNYC

    Error 3163, But Size Isn't an Issue

    I've got a database that's been in production for two years. This issue has never come up before. I have made no changes to any code or tables affected by any of this. In code I have the following: strSql = &quot;INSERT INTO TblMemoRecipient (ActionID, &quot; _ & &quot;EmployeeID...
  13. JeremyNYC

    How To Get Good Answers To Your Questions

    If you use this site to get help, please read this post. It will help you get the help you need and it will help others feel better about providing that help. No One Is Getting Paid To Answer These Questions People on these forums help because it feels good to help. We can't read minds. We...
  14. JeremyNYC

    I've got a SQL nut I can't crack. A

    I've got a SQL nut I can't crack. Any help would be greatly appreciated. Here are the tables: tblAccount ========== AccountID Other Stuff TblUnit ======= UnitID UnitName tblUnitEmployeeLU ================= UnitID EmployeeID MemoNumber CC (true/false) tblEmployee =========== EmployeeID...

Part and Inventory Search

Back
Top