I Have a text file that has a date field in it format like this 07152008.  I
am using the import function but if I give it a date format on the import
specification it has a problem, so I import it as text.
What's the best way to convert it to a date field?  Should I set up a

In access 2007 I can set a table field to be a memo and further set it to
contain rich text by setting the filed's TextFormat property. My question
is... how do I do this in code? I can't seem to find that property, or am I
going about it wrong?

I'm using an Attachment control on one of my forms.
When the user double clicks on an attachment control it automatically
presents a pop up menu for handling the attachments.
The same menu can be reached by right clicking on the control and choosing

MSysObjects only lists 12 local tables, but there are well over 100 in my
MDB.  Does anyone know why?  The tables that are not listed in MSysObjects
cannot be queries through DoCmd.RunSQL, DLookup or Recordset operations.  
Help!

I want my application to allow a user to press a button to record their
voice. This functionality worked just fine prior to Access 2007. The old code
that worked was this:
Private Sub RecordMessage_Click()

Hello all..
I have userform, not linked to tables. I have textboxes which I caluclate
data from and then input that into tables.
So what I want to do is, make a budget program. The user enters a brand new

I'm having trouble closing database app.  It occurs only after I click a node
in a treeview control then try closing the app.  I get "Microsoft Office
Access has encountered a problem and needs to close.  We are sorry for the
inconvenience.".  Here is the code:  (only started do ...

I try to convert the math calculation from the Excel to the Access in a
query because the original is not user friendly.
The partial of the code and the Excel formula are as below. When I ran the
program, I got error message: Type Mismatched on GasRateInMMCF = (((CalF32) ^

Hi, can any one help me to creat a backup for selected
date range(Just like 01 July 2008 to 31 July 2008)as
seperate zip file or dbf file or such backup system.
Basicly we enter data of a month, there should be able to

Hi, can any one help me to creat a backup for selected date range as
seperate zip file or dbf file or such backup system.
Basicly we enter data of a month, there should be able to create a
updation to protect that data without changing by someone. Is there

I have a problem with trying to connect to an access db. I have Office 2007
installed and running on machines in my office and have put together a split
database in the accdb format. The only problem is that I have one machine
that I need to have show a pivot table from the ...

Bit of trouble here.
   For aItem = 0 To UBound(InputArray, 1)
       rs.AddNew
       With rs

I wander why Copying from Access report (chart) to word not working ?! its
copy just the tables only?

I just moved my porgram from single user to multi user. I have three users
and each have FE on their computer and the BE is on my computer and I set BE
sharing  to Everyone and permission Level to Co-Owner. When a user is
connected to the

I have an Access app that runs unattended on a server (in an RDP session) and
stops occasionally for some unknown reason. I have complete error-trapping
with e-mail notification of any trappable error, and I do not get notified in
this situation (I do get notificaitons of other ...