is there a built in function that changes a numberic field
to a text field

Access 2002
DAO Coding
Is there a way to setup a recordset to be able to view all of the records of
a table (such as the dbOpenTable Type), so as it can see the changes that

I have this form which contains a text box. I wanted to
make it easier for the user to enter the information by
having them start entering the first letters of the name
they are going to write in completely. As they write it

To Whom It May Concern:
I get runtime error 13 'Type Mismatch' when trying to
validate a text box control inside recorset update below:
!General_Status = IIf(Len(Trim(Me.txtGeneral_Status) <  

I have been searching the net for the past 2 weeks trying to come up
with a solution for this and so far I have found other people with
the same problem but no solution.  So for all the Access enthusiast,
here it goes;

I have a question, i have a form with loads of text boxes on it, i have some
code that will be used for each textbox in a sepertae sub procedure.  The
question i have is, can i specify in a string which textbox is to be
altered.  I can do this normally by typing in each one ...

I have a numeric textbox on a form called Text409.  I have another box,
referring to that field with this in the Control Source:
     =[Text409] & " Total Units"
Since there never will be only one unit, I don't have to correct for the

I installed redemption to get around the outlook 2003
patch and have modified my code but i get a compile error
that reads "method or data member not found" and stops on
the .CreateItem line below. Any suggestions would be a

I'm trying to search the hard disk for .mdb files. I've
copies some code from the Help file but every time I run
it I get the following error: "Run-time error '5'. Invalid
procedure call or argument".

For some reason, when I'm working in VBA with Access 2002 during the past
few days,automatic error correction seems to have turned on and I can't get
it to turn off.  It gets frustrating when I try to type a line and VBA
doesn't allow me to insert spaces or type in accepted code ...

in MS Access Help file, it written that adModeUnknown is the default mode
for .mode property. Have any disadvantage to leave it in this mode or Should
I have to specify it to adModeReadWrite.
TIA

How do I set the value of a textbox to Null in VBA?
Cheers

how can i export a report to word programmatically, the
command i want is the TOOLS | OFFICE LINK | Publish to
work???
Any help is appreciated!

Hello....
I'm trying to link MS Query to Access97 though DDE
channel. I can't seem to get the link to work properly so
I wondered if anyone had any hints or tips.

I have built a mail-merge automation process in Access
2000 on Windows 98 with these References (among others):
  Microsoft Access 10.0 Object Library
  Microsoft DAO 3.6 Object Library