Recent content by vr

Perfect. Thanks!!

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?

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.

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

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

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

Thank you both! Works great!!

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

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?

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

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

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.

Thanks!!!!

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!

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