Search results for query: *

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

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

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

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

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

Hi, Here's another brainbuster form an anoying newbie ;) How do I run a query and have it store the value in a variable? For instance: LocationStr = "SELECT [Location] FROM [dbo.Users] WHERE [Badge#] = '" & UserHolder & "'" Well I want LocationStr to remember the value...

I'm trying to import some data, simple enough right? Well maybe for some of you. I exported some of the columns to Excel. They were updated and now need to be imported. The problem is that I can't/don't want any duplicates and can't delete and update because I only exported some of the columns...

Ok, I must be doing something really stupid here and need some help. I'm trying to change a forms RecordSource to match a Reports RecodSource. Basically what I've done is created a print/export routine based off certain critera selected by the user. So, if they want to print a certain report by...

HELP!! I want Access to update all of the linked tables everytime I start it. Can anyone help?? Thanks

Help...I'm trying to get a label to show the .mdb file size. Any suggestions? Thanks

Help...I'm want to display the .mdb file size in a label. Any thoughts? Thanks Dodge