Recent content by Dodge

Hi, We have 3 Win3K servers, one of the servers is performing VERY slowly when data is transfered from one of the other servers, however data being written to it from a client, works great. IE: 3 servers: s1, s2, s3 Data Transfer from: S1 - S3 > FAST S1 - S2 > SLOW S3 - S2 > SLOW S2 - S1 >...

Have a nubbie question for ya'll. I have created a small database in Access 2000 that is running an expression with-in a query, runs great on my pc but I get the following error any time I try to run it on a different pc, it to is running Access 2000: Function is not avalible in expressions in...

Ok, Last night saved the program I was working on and all was well. This morning, when I opened the project VB told me I had an error in my main.frm, the log stated: " '0' could not be loaded Line 0: The file E:\Secure\XMC3.0\main.frm could not be loaded." When I try to open the form...

You RULE! Worked like a champ, Thanks Astrid...

I am trying to use a variable to define a field using DAO, for example: Dim dbs As Database Dim rst As DAO.Recordset Dim Location as String, PartStr as String Dim RecParts as Integer Location = Combo1.Value PartStr = Combo45.Value Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT...

Thanks, big help

Can somebody explain to me why I can never get DAO or ADO techniques to work. For example, I want to update a record using DAO, heres an example of what I did: Dim dbs As Database Dim rst As dao.Recordset Dim sSelect As String Set dbs = CurrentDb Set rst = rs.openrecordset("select...

Is it possible to use a Variable at the beginning of a Dlookup statement? For instance: Dim Location as Variant Dim PartStr as Variant Dim CurrentQtyStr as String Location=Combo26.Value PartStr=Text11.Value CurrentQtyStr = DLookup(["'& Location &'"], "dbo_Inv Master&quot...

Thanks Nic, It seems I'm going to have to create a Modual after all, just would have been much simpler to use a query. Mac, 'go' has nothing to do with what im trying to accomplish. As I stated above its a utiltiy used by some sql analyzers. So, it's not reconized by Jet or SQL Server only the...

Mac & Nic, Thanks for the replies. The 'go' keyword is not a transact-sql statment. It is simply a utility/command used by osql, isql and the query analyzer. So in other words doesnt even apply to what it is i'm trying todo. If anyone knows how to create a mulitple SELECT query in access...

Well I did some reacearch and it turns out that 'go' is a resrved keyword recognized by the Query Analyzer in SQL Server. I am familiar with VBA.

Hello all, need some help... In Access 2K I'm trying to run mulitple SELECT queries, for instance I want to run the following: select count(*) as OOB11 from [OOB Station1] where [Line]='1' and [Shift]='1' go select count(*) as OOB2 from [OOB Staion2] where [Line='2' and [Shift]='1' It works...

You both qualify as SQL God's! Or at least to me because I sure could'nt figure it out. Thanks for all the help. Dodge

Thanks JJ, the reason I would like to use an SQL statement is because the table is in constant use, if I do it the way you suggested there would be some down time that the company just hates, or I would have to come in on a weekend to do it, witch I my have to do. But thanks for the suggestion...

SQL God's...I need your help. I want to delete duplicate records out of one of my tables, but not all of them. For instance if I have 3 records that contain the same [S/N] I want to delete all but one of thoses records. Any thoughts? Thanks Dodge