Search results for query: *

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

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

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!

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

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

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!

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

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

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!

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

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

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!

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

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

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

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

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

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

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

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