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

    Finding the number of working hours between two dates/times

    This looks like it's going to get ugly! I have two date/time fields [Date_Opened,Date_Closed]. I need to find the time in days, hours, minutes that it took to resolve the case (ie. Date_Closed - Date_Opened) Here's the catch. We only work from 7-6, Mon-Fri. I am playing with the datediff...
  2. joelindquist

    Converting Bitmapped objects to vector objects?

    I have a b/w sketch that I've scanned in, and I need to add a pattern to it. (It is several solid black shapes.) I am just wondering what would be the best way to convert these bitmapped solid color shapes to vector objects once scanned in so I can apply a pattern fill, and bevel to them...
  3. joelindquist

    Checking values of listbox options (selected or unselected)

    I've got a dilemma in that I need to perform an update query based on the values in a listbox. Not bad so far. Enter my Dilemma... I need to check if there is a null value as the only option in the list box, and if so, use a query to overwrite this value, or if there are multiple values, (no...
  4. joelindquist

    Testing to see if a field has a value

    I've got a form field (Email) which will not always contain a value. I need to use this field to generate a hyperlink in VBA. It works fine when it contains a value, but when it has no value (No Email address) it pops up an error dialog. I've tried the Access VB reference, and find nothing to...
  5. joelindquist

    Access Database Logon Name through VBA

    Hello, I am using microsoft access 97 with a dedicated workgroup information file. I was wondering id there is any way to retrieve the Logon Name in VBA. It is a knowledge base software, and I'd like for access to automatically fill the userID class so that people will not have to...
  6. joelindquist

    I need to generate/run a query based on a form input with VB

    Here's the deal. I am building a knowledge base for my employer. One of the requirements is that it has a Boolean search tool (term1 and term2 or term3 not term4). I've successfully coded a function in PERL which parses the input, and generates a SQL query from the input string. With help...

Part and Inventory Search

Back
Top