Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Dodge
  • Order by date
  1. Dodge

    Win3k > Win3k Slow Write over LAN

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

    Function Not Avalible?

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

    Form opens as a Module?????

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

    Formating Question

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

    Formating Question

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

    DAO/ADO Problem

    Thanks, big help
  7. Dodge

    DAO/ADO Problem

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

    DLookup Formating

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

    SELECT Query

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

    SELECT Query

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

    SELECT Query

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

    SELECT Query

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

    Deleting Dup Record

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

    Deleting Dup Record

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

    Deleting Dup Record

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

    SQL Value

    Thanks, Worked like a champ...
  17. Dodge

    SQL Value

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

    SQL Import Script

    Thanks, Worked like a Champ Dodge
  19. Dodge

    SQL Import Script

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

    Report RecordSource Help

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

Part and Inventory Search

Back
Top