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 Rhinorhino 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: *

  1. RAtkison

    VB - Accessing DBase tables (.DBF) = VERY SLOW

    The first thing I would check is the index on Piece_Num.
  2. RAtkison

    MS Access 97 (Please help I think I messed up :..(

    The only way I can see that you deleted some rows out of the Addresses Table was to run a delete query. On the Query tab, it would be listed with an X! beside the query name. If you didn't do that, the rows may not be deleted. To find out just double click on the table Addresses, right click...
  3. RAtkison

    checking a value in an access table

    Are you using ADO? Check out the Dir command in vb. You can use it to find a directory or a file on your hard drive. RKA:)
  4. RAtkison

    KeyUp Event never executes

    Make sure the KeyPreview Property of the form is set to True. RKA:)
  5. RAtkison

    Inserting a word in Notepad in a specific location

    The mid function will get characters in the middle of a string or it will place characters in the middle of a string. a="123456789012314455" mid(a,6,2) = "RA" ?a 12345RA89012314455 RKA:)
  6. RAtkison

    Problem after deploying application...

    I always install the mdac_typ.exe file myself. RKA:)
  7. RAtkison

    Inserting a word in Notepad in a specific location

    Here's something to think about. Dim sLine as String Open sFileName For Input As #1 Open sFileNew For Output As #2 Input #1, sLine Mid$(sLine, 63, 9) = “Your Name” Print #2, sLine Do While Not EOF(1) Input #1, sLine If left(sline,10) = “Visual Basic” then Mid$(sLine, 63, 9) = “Your...
  8. RAtkison

    Edit same record twice, SQL Server, ADO

    You might try refreshing the data control. RKA:)
  9. RAtkison

    Problem after deploying application...

    In the directory where the setup files are stored should be a file called mdac_typ.exe. For ADO to work properly on the users machine, this file must be installed. Hope it works! RKA:)
  10. RAtkison

    Full Screen

    Try Me.WindowState = vbMaximized RKA:)
  11. RAtkison

    Application uses a value of the wrong type

    This is what I came up with. cmd.CommandType = adCmdStoredProc Set params = cmd.Parameters params.Append cmd.CreateParameter("@RETURN_VALUE", 3, adParamReturnValue, 0) params.Append cmd.CreateParameter("@code_id", 200, adParamInput, 4) Hope it helps. RKA:)
  12. RAtkison

    Save as

    Create a variable with the old file name and new file name. Then use: FileCopy sSourceFile, sDestinationFile RKA:)
  13. RAtkison

    vbCrLF

    On the text box, be sure to set MultiLine to True. RKA:)
  14. RAtkison

    Disable Ctrl-Tab?

    On your form, set the KeyPreview to True. Try this code to see if it will do what you're wanting. Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) If KeyCode = 9 And Shift = 2 Then KeyCode = 0 Shift = 0 End If End Sub RKA:)
  15. RAtkison

    Extracting Data from Access Database Within Compiled VB EXE

    The database is separate from the exe file. The data is probably in Access, SQL Server or some other database. Re-compiling the VB application should not have any affect on your data. I don't know anything about your application or your data so please be careful. Always backup your...
  16. RAtkison

    executable doens't work properly on other pc's

    In the directory where the setup files are stored should be a file called mdac_typ.exe. For ADO to work properly on the users machine, this file must be installed. Hope it works! RKA:)
  17. RAtkison

    How do I........??

    This is a broad example that will hopefully get you started in the right direction. It's looking at a SQL Server database. To connect to Access you would change the connection string. Also to do this you must reference Microsoft ActiveX Data Objects Library. Public Const ConnectionString =...
  18. RAtkison

    is it possible to do a select from a query???

    It appeared to me from what I tried that you could use a query name interchangably with a table name. It seemed to look at them exactly the same. I would try putting in the query name, such as "Select * From Query" just like it was a table. It seemed to work in Access and VB. Hope...
  19. RAtkison

    is it possible to do a select from a query???

    You might consider taking the SQL from the Access query and paste it into the VB str_sql variable. That way you don't have to depend on that query always being there and it gives you a little more control. I'm not sure about the answer to your question but maybe this will help. RKA:)
  20. RAtkison

    Rename file from Visual Basic6

    Great question. I just didn't want to take credit for something I didn't know. RKA:)

Part and Inventory Search

Back
Top