Search results for query: *

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

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

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.

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

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.

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