Search results for query: *

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

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

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

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.

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

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

I need to determine the OS from an access app using VBA. Basically I need to place a file in different locations based on the OS that the app is being run on. Should be easy right? Thanks for any help in advance.

I'm having trouble getting this to work and it seems like it should be so easy. The code below works on my machine but throws this... "Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation." when i run it on the server. I've...

I need to see if a .xls file is open before I transferspreadsheet to it. If it is send up a msgbox telling the user to close it. Then after the transfer I want to open the .xls file. Easy right? It does not seem so. Any help out there? Thanks in advance as usual. Scott

OK this should be easy..... SELECT vProjection.Date, vProjection.Project, vProjection.Term FROM vProjection WHERE (((vProjection.Date)<#5/30/2008#) AND ((vProjection.Term) Is Null)) ORDER BY vProjection.Date DESC; I'm getting results with vProjection.Date > 5/30/2008. vProjection is a...

Hi, I am looking for a single result from this query. I need the ONE record with the smallest date. My table looks something like this... Project SYSDATE SYSComp ABC123 1/1/2008 1 ABC123 2/1/2008 0 And here is my query... SELECT Project, MIN(SYSDate), SYSComp FROM...

Hello I've need some guidance.. I need a view that is based on a query of a number of fields. One of which "Notes" is a SQL2000 text field. (Unfortunately I can't change it at this point) SELECT Project, MIN(Date) AS UPLDate, Comp AS UPLComp FROM dbo.Activities GROUP BY ACode...

I need some guidance..... I need to run a stored procedure but I don't want to wait for the results. This SP can take up to 4 minutes to run and I don't want the users to have to wait before moving on in the code. I found an article with a model that I followed, but it does not work and I...

Hi, I need to send a query to a stored procedure where I don't want to wait for the results. This SP can take up to 2 minutes to run and I don't want the users to have to wait before moving on in the code. I have returns records set to no but I can't figure out how to just move along...

Hi, We are looking for a solution to help us with code management for a Access 2000 format VBA application. We need code check out/in functionality. I've heard that 2007 has this feature by using VSS, but I'm leery of being on the bleeding edge with such a critical app. Are there third part...

Hi, We are looking for a solution to help us with code management for a Access 2000 format VBA application. We need code check out/in functionality. I've heard that 2007 has this feature by using VSS, but I'm leery of being on the bleeding edge with such a critical app. Are there third part...

Why am I getting a result of .0000000 Convert(numeric(10,7),(2000/(tblCatalog.Concentration))) AS ADDTHIS Thanks in advance!