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

Thanks, dhookom and combo. That did the trick. Adding the Microsoft ActiveX to my reference list solved the problem. Thanks, everyone, for your help on this.

Here is the code: Public Sub Change_Field_Precision() Dim dbsApplications As Database Dim strSQL As String Set dbsApplications = CurrentDb strSQL = "ALTER TABLE [Applications Now] ALTER COLUMN [ADM_APPL_NBR] DECIMAL(9)" dbsApplications.Execute (strSQL) dbsApplications.Close...

It didn't like it. I received a '3293' run-time error. I am using the following references: Microsoft Access 16.0 Object Library Microsoft Office 16.0 Access database engine Object Library Microsoft Visual Basic for Application Extensibility 5.3 Thanks!

Andy: What if the table name/column name has spaces in it? How would the ALTER statement look in that scenario? Thanks!

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!

It worked like a thing of beauty. Thanks Golom and PHV.

What would be an appropriate aggregate function to use on a character field that takes no part in the decision process of the query? It seems if I add the field to the GROUP BY clause, it would ruin the logic.

Thanks! It works great. However, when I add another field to just return in the results, I get the error: You tried to execute a query that does not include the specified expression 'GROUP_NAME' as part of an aggregate function. Is there a special way that I can add this field just to return...

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 tried that method. It doesn't work.

I have created the new DSNs using the SYSWOW64 version of odbcad32.exe. The problem is when you go into the linked table manager in Microsoft Access, it only sees the old DSNs and not the new ones. How does one 'refresh' the links? Is there a registry modification that has to made?

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

Sometimes I cannot see the forest because of the trees. Thanks, John!

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

You both get stars for your suggestions. Thanks again for the assist.

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!