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 bkrike 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
  • Content: Threads
  • Order by date
  1. 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?
  2. 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...
  3. 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 =...
  4. 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...
  5. 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...
  6. 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!
  7. 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...
  8. vr

    ADO Recordset Delete

    I have an ADO Recordset and need to delete a record from the recordset. I have not found the correct syntax. Can anyone help? Am reaching maximum frustration level!! Thanks in advance!! ;-)
  9. vr

    Report-Landscape

    I have a report that always needs to be on legal size paper, landscape. Can anyone give an example of how to programatically set this? I need to set this in VBA because when enhancements are rolled out, I currently have to hit each desktop to reset the paper size to legal. This is just not...
  10. vr

    Exit Access

    I have a command button to exit Access97. DoCmd.Quit This closes the Access database, but not the Access application. In fact, I have to Alt Ctl Delete to end the application. I have closed all of my ADO connections and recordsets. Does anyone have any suggestions?
  11. vr

    Assigning Function Value to Report Field

    I am trying to assign a value returned from a function to an unbound field on a report via VBA. This code: Me.Text78 = Report10d(SumDateFiled) Returns: "Can't assign value to this object." Obviously, I have not done this before. Any help would be greatly appreciated.
  12. vr

    IIF In Report Field

    Can anyone tell me what is wrong with this? =IIf(IsNull([acctnumber]),[empnumber],[acctnumber]) I have this in the control source of a text box on a report. This is returning #Error in the preview of the report.
  13. vr

    Link Table

    I would like to link an oracle table in the on_load event of a form and then delete the link on the unload event. Does anyone have any samples? I am currently using: ON_LOAD Dim dbsCurrent As Database Dim tdfLinked As TableDef Dim tdf As TableDef DoCmd.Hourglass True Set dbsCurrent =...
  14. vr

    Need List Box Assistance

    I have a form with a text box to fill a list box. The user wants to be able to input a value in the text box, depress enter and have it load to the list box. Can anyone help?
  15. vr

    Cursor Size

    Does anyone know of a way to change the cursor size in VBA? Another wacky user request... LOL
  16. vr

    Subform

    I have a Mainform (one) with a Subform (many). The recordsource for each is an SQL statement to an Oracle database. Each field is then set to the rs("field).value. The Mainform works fine. The Subform does update the fields consistently. Can anyone tell me how to correctly set the...
  17. vr

    Null Date Error

    I am trying to write an SQL statement to update dates on an Oracle table. When the date is null in the recordset, an error is received. Access VBA is not allowing Decode or To_Date to be utilized. Can anyone provide an alternate solution?
  18. vr

    App.Path

    I use app.path in VB. Can anyone tell me the correct way to convert this to VBA?
  19. vr

    Select Case in Query

    Can anyone show me an example of how to put a select case statement in an Access query?
  20. vr

    Need Help With Keystroke Events

    I want to assign a password to Shift+F11 to only allow authorized personnel into the database design.<br><br>I am having trouble.&nbsp;&nbsp;Can anyone help???<br><br>

Part and Inventory Search

Back
Top