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

  • Users: KeyserSoze
  • Content: Threads
  • Order by date
  1. KeyserSoze

    TOAD for Oracle - Icons

    Hello. Is there a way in TOAD Data Point to create icons that represent query and automation files? Currently I have to use File/Open to run the file and it would be easier to just click an icon. With this method a user would not have to remember the directory location and file name of a...
  2. KeyserSoze

    Import Error Files - Export$_ImportErrors

    I have created macros that import several Excel files into tables. From time-to-time, there are problems when the data in the Excel files contain values that are not compatible with the fields in the tables, thus creating import error tables in my database (i.e. Export$_ImportErrors...
  3. KeyserSoze

    Changing a table field's property

    In a Microsoft Access (2000 format) database, I have a table that contains a field that currently has the following characteristics: Data Type: Number Field Properties: Field Size = Decimal, Precision = 2 Is there a way in VBA to change the precision from 2 to 9? Thanks!
  4. KeyserSoze

    Get max date record from group of records

    I have a Microsoft Access query that gives me a list of records from a table. Each record has an identifiable key based on QUARTER_CODE, PERSON_ID_NUMBER and APPLICATION_NUMBER: SELECT DECS_HIST.PERSON_ID_NUMBER, DECS_HIST.QUARTER_CODE, DECS_HIST.APPLICATION_NUMBER...
  5. KeyserSoze

    ODBC in Windows 7 - 32-bit applications

    I have recently converted from Windows XP to Windows 7 (64-bit). I have discovered that my 32-bit ODBC connections in my Microsoft Access database no longer work. From doing some research, it suggests that I create new system DSN's using the ODBC administrative tool (odbcD32.exe) located in...
  6. KeyserSoze

    Getting user login in secured database

    I have a database that I have created users and groups in a workgroup file. In some activities, I would like to store the user's login in an auditing table. Is there a way to lookup the user's database login name? Thanks!
  7. KeyserSoze

    Automating Mail Merge - Header Record Delimiters

    I have a mail merge working that takes a data source that is a text file and merges it with a document. Everything works fine except that when the data source is linked in, a "Header Record Delimiters" dialog box pops up wanting the user to confirm the field and record delimiters to be used...
  8. KeyserSoze

    Dynamic check boxes in form

    I'm writing an application where I will have a series of checkboxes on an Access 2000 form. I can create the checkbox objects with no problems. My question is this: can checkbox objects be painted onto a form based on information from a table? In short: I would like to dynamically create...
  9. KeyserSoze

    Convert character to hexadecimal value

    Is there a function in VB.NET 2003 to return the hexadecimal value of a character? For example, the hexadecimal value of character µ is B5. Thanks!
  10. KeyserSoze

    Ampersand in caption property conversion

    I have some code in a form that takes data from an Access table and places it into the caption property of a label object on the form. This data has the ampersand (&) character in it. When the label object is painted onto the screen, the ampersand changes to a underline (_) for hot key...
  11. KeyserSoze

    Converting unsigned number

    I have an unsigned number that is stored in an 13-character format (for COBOL afficionadoes, it's stored as S99999999999V99) in ASCII. I would like a way to take this number and convert it to a readable format with the minus sign placed to the right. Is this possible without building...
  12. KeyserSoze

    Code to choose directory

    Is there code in Microsoft Access 2003 that will display a directory tree dialog box that will allow a user to choose a directory and populate a text box with the name of the chosen directory? Thanks!
  13. KeyserSoze

    Calculate days in Access query

    I currently have a query that gives me a list of records when I run it: SELECT VR_TRACKING.LOC_CODE, Folders.CurrentSSN, Folders.StudentName, Folders.EntryTerm, Folders.EntryYear, Folders.CuriclmCode, Folders.StudentType, Folders.Tracking_ID, VR_TRACKING.TRANSFER_TS FROM VR_TRACKING INNER JOIN...
  14. KeyserSoze

    Temporary file read/write access via VBScript

    I am new to VBScript, so please bear with me.... I have to write a script that runs when a user logs in and writes information, such as logon time, IP address, etc., to a text log file. The text log file will reside in another directory and all users will append to it. I do not want the file...
  15. KeyserSoze

    Editing a sub-report in Access 2000

    I have a sub-report inside of a report form in an Access 2000 database. In Access 2003, if I wanted to open the sub-report in a new window, I would select the sub-report, perform a right-click and select "Subreport in New Window". How can the same thing be done in Access 2000? I need to...
  16. KeyserSoze

    Edit field in Word mail merge recipient list

    Hi: I have a letter document and a data source that I am doing a mail merge. The one thing that I would like to do before I create a new document with all of the data from the data source filled in is to change a particular character (0) in the data of one of the fields of all of the records...
  17. KeyserSoze

    Copy contents of one structure to another

    I have two public record structures in my application as follows: Public Structure Input_Record <VBFixedString(1770)> Dim Confirm_Buffer As String End Structure Public Structure Input_Record_Detail <VBFixedString(1)> Dim IN_REC_TYPE As String...
  18. KeyserSoze

    Excel screen repaint problem

    I have a form in Excel 2002 VBA that opens another form. The second form does manipulations on a worksheet. When the second form is closed via an "Unload Me" command, it seems to remain painted on the screen behind the calling form. Also, when you grab the original form, it creates...
  19. KeyserSoze

    E-mailing workbook in Excel causes error

    I have a subroutine that e-mails the active workbook by pulling up the SendMail dialog box. However, after the user hits send, the following error is produced: Run-time error '91'; Object variable or With variable not set Here is the routine: ----------------------------------------------...
  20. KeyserSoze

    Hidden sheets in Excel

    I am designing an Excel workbook that uses VBA to do manipulations on sheets. I will have only one sheet visible while the other sheets that are used for data manipulation and reporting will be hidden. Question: Will I have to temporarily unhide a sheet before I can modify it and then re-hide...

Part and Inventory Search

Back
Top