Search results for query: *

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

Hi, I've got a Cisco 3560 switch (Device Type WS-C3560-48PS) and I've got a question about the SFP ports. Can they be used as a straight gigabit port for connecting servers? If yes, do any standard ports become disabled? Also, it seems that there are a number of variations of adapters out...

Fantastic! Thanks jrbarnett. I really appreciate it. Best, Scott

OK Thanks pwise, but this looks like it returns the distinguished name of an object on an LDAP server. Is that right? Basically what I think I need to do is to find out what Domain Controller a user is authenticated to when the application launches. Based on that I'm going to point them to an...

Two questions really..... I've got an Access front end and a SQL 2005 back end. We are replicating our SQL data to a second server in another state and I want to determine which SQL sever users will use by identifying the DC that they authenticated to. First, does my idea make sense? And if...

I'm having a bizzare issue with linked tables. Several tables are disappearing from the database window after I close Access. After restarting these tables do not show up in the database window but in the Linked Table Manager they are there. If I relink them, all is fine until I close the...