Recent content by scotttom

Thanks gmastros! LEFT(Replace(Replace(RIGHT(Convert(varchar(30), GetDate(), 121), 12), ':', '), '.','),8) got me what I need. Thanks for pointing me in the right direction!

I'm looking for the best way to get a time to a hhmmssmm format. I've got the following.... replace(Convert (varchar(8),GetDate(), 108),':',') + '00' But unfortunately I need the milliseconds and not just "00" at the end. Anybody know the best way to get there? Thanks in advance! Best...

OK PWise I spoke too soon.... I have one more nuance... What if I wanted orders that ONLY have beer. Using your select statement if I search only for beer I get order 1 and 3 returned. In that case I'd want only 3. Make sense? Thanks again, ST

BRILLIANT PWISE!! I owe you another beer!

Right. That would give me OrderID 1, but I wouldn't know what orderID to put in the WHERE clause because that's what I'm asking for. I'm asking for the orderID that has Bread, Beer and milk as details. Any other thoughts?

Sure..... Boiled down it is this... tblOrders..... OrderID Desc 1 Bread, Beer and Milk 2 Bread 3 Beer tblDetails...... DetailID Item OrderID 1 Bread 1 2 Beer 1 3 Milk 1 4 Bread 2 5 Beer 3 Ok...

So I'm stumped as to how to get a list of orders that contain a certain combination, and only that combination, of items. I need the exact combination of items. Unfortunately if my query has 5 items I'm getting orders that have one of the items included and I don't want those. Hmmmm...

Perfect. Exactly what I needed. THanks.

I'm looking for some guidance for getting a sum of one column when certain dates match.. Basically I'm trying to map capacity usage. I have a table like this that holds the data... Number DateStart DateComplete 200 1/1/2011 1/3/2011 300 1/2/2011 1/4/2011 What I'm looking...

OK... thanks for staying with me here... I've recreated the sub form, recreated the main form, decompiled, compiled, imported all objects into another MDB and still no love. After update does not fire. OnDoubleclick and onkeypress does but not afterupdate or onlostfocus. What could be going...

HI Duane, Essentially I can't get ANY code to fire on afterupdate or OnLostFocus on certain records. Basically, my goal was when a certain field was updated, code to open a specific form based on the value of another field would fire. I reduced this down to a single msgbox for testing, set...

I've got an subform whose datasource gets set dynamically based on values in search fields on a main form. My problem is this.. The afterUpdate event on a textbox control in the subform does not always fire. I've reduce the code to a simple msgbox and still nothing... sometimes. I've tried...

I need a bit of help with a SQL query that I'm running through VBA. I have a table that has strings of various length (asd, asdf, qwerty) in column tbl.ProjectPrefix. What I'm looking to get is the value of tbl.Text if the value in a text box starts with any of the values in tbl.ProjectPrefix...

Hello, Is there a way to manually change the LOGONSERVER environment variable? I'm testing an app that uses this info to choose a server to connect to and I need to make sure it works. Thanks in advance for any info.

Thanks for the reply DallasBPF. I'm going to be using straight cat6. I appreciate the help. Scott