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 derfloh 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: vr
  • Order by date
  1. vr

    Input Mask

    Perfect. Thanks!!
  2. vr

    Input Mask

    I am trying to create an input mask for an amount field. The length is 11 with an implied decimal. The format needs to allow for negative values as well. ie: Positive: 00000001234 Negative: -0000001234 Any suggestions?
  3. vr

    linked database to oracle

    I have 2 Access front end with Oracle back end applications. I moved my tables to Oracle due to the number of records. The volume exceeded Access limitations. I found using ADO was much faster than using linked tables. It depends on your specific needs.
  4. vr

    TransferDatabase

    The primary index is on the Oracle table, but the ODBC connection still brings up the dialog to select it.
  5. vr

    TransferDatabase

    I use the following to link Access97 to an Oracle database via ODBC: DoCmd.TransferDatabase acLink, "ODBC", "ODBC;DSN=XXXX;UID=XXXX;PWD=XXXX;LANGUAGE=us_english; & DATABASE = C:\PROGRAM FILES\XXXX\XXXX.mdb", acTable, "MYTBLE", "LinkTest" A dialog box...
  6. vr

    odbc connection strings

    Try something like this... Public cndb As ADODB.Connection 'global connection variable Public dbsCurrent As Database 'Current database gsServerName = "XXXX" gsUserIDName = "XXXX" gsPassword = "XXXX" Set cndb = New ADODB.Connection gsSQL...
  7. vr

    Creating Word Document

    Thank you both! Works great!!
  8. vr

    Creating Word Document

    I am creating a letter in Word 2000 via Access VBA. It all works fine, except, I need to set the paper source to manual feed for printing. Can anyone help? This is a new word object, not a Word Merge. Here is a sample of the code: Set oApp = New Word.Application Set wDoc =...
  9. vr

    Operating System

    In Access97 I am using GetVersion, GetUser and GetEnvironment. These are not working in Word2002. I must get all three as the application will be running on Win'95, Win'98, NT and XP. Any suggestions?
  10. vr

    Operating System

    I have an Access97 database that is utilized as a datasource for a Word merge document. I have updated the VBA in Access97 to determine what operating system is running on the desktop. The directory location is based on the operating system. This works fine. The problem: I am trying to use...
  11. vr

    Mail Merge Problem

    I have a MSAccess97 database that is set to generate mail merge documents. This database has coding to allow for use on Win'95, Win'98, Win 2000 and XP operating systems. The problem: I need to be able to change the data source location in the word document based on the operating system...
  12. vr

    Easily reading INI file values

    Just one person's opinion, but I use a default table with one record (a separate fields for each item) to define any set keys and read them from the table. Eliminating the ini file entirely.
  13. vr

    Vertical Text Label

    Thanks!!!!
  14. vr

    Vertical Text Label

    I have set the Vertical property to yes for the column labels in an Access 2000 report. My customer has requested the text read: p H l vs e e l H p Does anyone know how to rotate the text? Thanks!
  15. vr

    CurrentProject.Connection equivalent in Access97?

    I use ADO in '97: Set cn = New ADODB.Connection Set rs = New ADODB.Recordset Set cmdCommand = New ADODB.Command cmdCommand.ActiveConnection = cn cmdcommand.CommandText = " SELECT * FROM Table.TableName WHERE MyField = ?" cmdCommand.CommandType = adCmdText...
  16. vr

    SQL Table Name

    Thanks everyone for you help. Bimalaggarwal, this works super!!
  17. vr

    SQL Table Name

    These are month end tables utilized for aging/archive purposes. IE: (ACCOUNT0205, ACCOUNT0206, ACCOUNT0207) The naming schema is out of my control, I just have to deal with it.
  18. vr

    SQL Table Name

    I have an SQL statement in which I would like to somehow place a variable for the table name, but don't quite know how. SELECT * FROM MyTable_0205 The table name changes each month and I would rather not have to update the query each month (02=YY; 05=MM). Can anyone give me some direction on...
  19. vr

    Clueless: Why use ADO in MS Access?

    In my opinion....linking tables works fine if the volume of records is small. I normally use ADO because of the improved performance. It can handle large volumes much faster than DAO or linked tables.
  20. vr

    Launching Dos Batch file from Access

    I create and call dat and bat files in VBA. This eliminates the need to deploy more than one file with the application.

Part and Inventory Search

Back
Top