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 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: njellis
  • Content: Threads
  • Order by date
  1. njellis

    Set Query Criteria via VBA

    I have a query (qryHTMLOutput) that I need to pre-set a criteria on a single item (Phone1). I have a button and when I click that button, I want it to set the criteria based on what's on the form (i.e. me.phone1) I can't seem to figure out how to do this. I have tried this: but I think it only...
  2. njellis

    Make phone numbers clickable

    Good Day all! I have an access database we've been using for a few years now. I have a form that pulls data directly from the client info table. One of the pieces of info is the client's phone number. I would like it if I can make the phone numbers clickable with the "tel:" hyperlink tag. Is...
  3. njellis

    Exchange 2007 Server sending spam

    Exchange 2007 Server is sending spam. I have tried to isolate where the issue is, but cannot figure it out. Small personal exchange 2007 server with just 4 users on it. Sends/Recieves email for 2 domains. Xeams for spam filtering, and my VPS for outbound mail. So mail flow looks as such...
  4. njellis

    If Statement not working...

    I have tried and tried different things, but my if compare statement isn't working. I want to take the second character entered, then via an IF statement say "If Operator = "X" then set caseSelect to "1"" But it keeps jumping to the else. When I run it, it shows that it is a correct string...
  5. njellis

    DropDown Value into Formula

    I am trying to run a query in which ColA + ColB = ColC ColA has a specified value (I.e. any number) ColB (the problem) is from a dropdown list which is pulled from another table (TripCharge). Info for the table (TripCharge). 2 Colums PriKey | Value 0 $0 1 $10 2 $20...
  6. njellis

    Mutiple Accounts in one view?

    I have 4 email accounts in outlook. 3 of them are POP, one is IMAP. Each has it's own separate PST File to keep things organized. Is there a way, similar to in "Mac Mail", where you can have all unread messages from all the mail boxes appear in one location? Thanks!
  7. njellis

    Scanning while in PC or on USB

    Doing a lot of Adware/Spyware removal, I've wondered for some time now which is the most efficient method of removal. If you remove an infected harddrive and connect it via USB to another machine, and run a scan: does it do as through of a job as if you loaded the program on the infected HD and...
  8. njellis

    Form Autofill Data from Query or Other Form

    Thanks in advance for any help. I'm new to access and trying to learn up :) I have Forms: CustomerInfo NewAppointment The tables themselves are linked by CustomerID. So there is CustomerID and CustomerID in Appointments table. I have the CustomerInfo form with a "Schedule Job" button, that...
  9. njellis

    Access 2003 - Auto Update Query in Form?

    This is my first access database I'm working on, and I've got the hang of things -- but still trying to figure out details to things. So, I apologize if my question seems remedial. table1: CustomerInfo table2: Appointments Query1: CompleteJobs Query2: IncompleteJobs Form Src = Customer Info...
  10. njellis

    Wacky Mouse Issue!

    Thanks for taking the time to read... Starting a few months back, at no particular point of hardware or software change my mouse started wigging out. I have a Razer optical mouse, what happens is it will not regain focus when you click between different windows. It will however usually work...
  11. njellis

    Outlook 2K3 w/ Hotmail Inbox Problem

    Thanks for taking the time to read this. I've been struggling with this issue for a long time now, and it'd be great to get it resolved. When I use outlook 2003 with my hotmail account, for some reason the inbox never updates itself. What I mean by that is, if I receive a new message that's...

Part and Inventory Search

Back
Top