Recent content by joelindquist

Thanks Michael. You've saved my #$@ once again. I am working on a query to get resolution time for service tickets, therefore lunch breaks are not considered. Vacation days, however will be, and I am using your code to which I was directed by evalesthy. Thanks again, -Joe

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

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

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

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

joebickley- That is what I was originally looking for, but Maq's idea returns their Windows Login ID, which is going to work even better. Thanks, though.

Worked Like a Charm, Thanks Maq.

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

I would make a table with 2 or more fields(productID,OrderStatus,ExitStatus,ReasonCode,) as a control table. Use all of the fields as a composite primary key. Either do this, or pull from a table you already have which contains all of the possible combinations. Then write some VB code for...

This info has helped me as well. For some reason, however. If I use a variable to hold the SQL, it will not work. If I define the SQL directly in the second line, it works fine. ie strSQL = "Select......" me.listboxname.rowsource = strSQL Doesn't work but me.listboxname.rowsource...

OK. All I really need to do now is execute a query contained in a string. After reading the help files contained with Microsoft Access, I was thinking that I could use the DAO function QueryDef, but I get an unknown object type error when I compile the module. I also get this error when I use...

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

I just Graduated, and was converted from a college co-op to a contract employee. I had a similar problem which I have recently solved. I had to build a knowledge base software to be used internally through an application front-end, and externally through a web front-end. I got pretty scared...