Recent content by jacquid

I am on access 2000 and I need to convert the database to a prior version to send the database to my client. But when I run the convert database to prior access version (tools->database utilities) I get the following error: "Invalid field data type" , "some errors happend during...

Shep, I am aware of the description in Access 2000) help re TransferText Specification Name but it states "you must either specify an argument or use a schema.ini file" - which does not help if you do not know how to create a schema.ini. The agrument I managed to create using the...

I have been using a macro with the Transfer text action to export data. I had a problem with my machine and it got formatted. Now when I attempt to run the macro I get the following error :"The data being formated does not match the described in the schema.ini file." As far as I...

I have been using a macro with the Transfer text action to export data. I had a problem with my machine and it got formatted. Now when I attempt to run the macro I get the following error :"The data being formated does not match the described in the schema.ini file." As far as I...

Thanx

According to the MS access Help the System DSN or Machine data sources, has the following attributes: "Machine data sources store connection information in the Windows Registry on a specific computer with a user-defined name. You can use machine data sources only on the computer they are...

I have set-up one System-DSN with a generic data source name. I hoped to just override the database name to point to the database I would like to access at that point in time. But I now discovered that when you link the table, the table properties store the database in the description...

The code did not work but I found an alternative - place a default on the input box.

I have set-up one System-DSN with a generic data source name. I hoped to just override the database name to point to the database I would like to access at that point in time. But I now discovered that when you link the table, the table properties store the database in the description...

I got the idea to call the query from a form from "SAMs Teach Yourself MS access 2000 in 21 days" pg. 448 Thanx for the VB - I will try it.

After removing the "AS string" I get the following error message: "complie error: expected variable or procedure, not module"

When I try the debug I get the following error on the first line of code - "complie error: Expected: expression" line of code highlighted - "Public Function MyInitials(strName As String) As String"

What is the difference between Left$() and Left()?

unfortunately not it is huge.

Button code: Private Sub cmdOpen_Click() On Error GoTo Err_cmdOpen_Click Dim stDocName As String stDocName = "SwitchConfL-0-1-MainExtract-Qry" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_cmdOpen_Click: Exit Sub Err_cmdOpen_Click: MsgBox Err.Description...