Search results for query: *

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

SQL : SELECT DISTINCT [SwitchConfL-00-MainExtract-Tbl].cl_number, [SwitchConfL-03-AgentInfo-Tbl].given_names, Initials([given_names]) AS Test FROM ... MODULE CODE: Public Function Initials(strName As String) As String Dim strInitials As String 'do the left$, instr$ stuff here and put...

Thanx, I created the function but now when I try use it in Query I get the following error: &quot;Undefined function <name> in expression. (Error 3085)&quot; - Help! I added the function to the query using the build wizard.

My VB is limited how would I achive this?

I have never used modules before and my VB is extremely limited. Could you give an example of how to achieve this?

What I wanted to do was write one &quot;re-useable&quot; function in VB! Currently I am using Instr, left & mid - this works fine. I want to do something a little more involved that I can re-use with little effort.