I'm working in Access2000 and am having trouble finding a way to take
imported "OLEPath" field values in my database and filter out or
eliminate all the alpha text so we only get numeral values, allowing
for number formatting. only the first and the last 4 of every value is

How can I link a subform to a recordset in such a way that when I browse the
recordset of the parentform the linked records are shown in the subform?

I'm using Access 2003.  When I run the sub below I get the following error
message:  "Compile error.  Wrong number of arguments or improper property
assignment."
I'm trying to append about 50 tables through vba to a table called "tblAll".

I have a database with hundreds of reports.  I want to change a property in
all of them.  How do I do it programmatically in vba?  I have not worked with
the reports object model before.
Thanks,

Kind of struggling here.  I need to read in a text file that contains prices
from a vendor.  It is a formatted text file, so the first line is a heading,
second line spaces, third line heading, fourth line all dashes,  then the
good stuff.

I am trying to create VB Code for a form that says...
If [Status] = "Complete" And [Ended] Is Not Null Then
   [Complete] = "Yes"
Else

I want using list while using if condition
e.g  cell A1 = Lorry expenses" i want cell b1 will show the following in
list format i will select any one of this.  Kindly inform what formulla i
will use?

I'm trying to get the differences between two times in Access 2003.
I tried using Format([StartTime] -1 -[EndTime], "Short Time") which I got
from the MVP website. However, when I use it for the following times:
Begin Time: 08/29/2006 6:26:00 AM

I'm am trying to get a button on a form to open a Word document. I works in
one database, but not in a second that has tables linked to the first. Both
databases are accessing the same .doc, at different times. Here's my code for
the button on the second database:

There doesn't seem to be a grid control available with Access.  A vsFlexGrid
came with our edition of Access but it didn't seem to include a license to
use it.  What needs to be purchased to have access to Msflxgrd.ocx.  Or, is
there another worthy grid control that is cheaply ...

This one should be easy (but not for me)
I need to pass a Subforms name from a event on the form to a module which
will then fully qualify the subform name.
On event (lost focus Or wotever)

how can i undo the changes in the subform?
i have the code like below, but it doesn't work
Private Sub undo_Click()
   Me.undo

I have developed an application starting in 97 and upgraded to 2002. It has
about 30 forms, 200 tables, 200 querries and about 10 VBA modules. I can
create an MDE with Access 2002. I can open the program with Access 2003. It
opens and runs. When I try to create an MDE it says it ...

Can someone please provide a link to or sample of Access code that displays
mdi files on an Access form.
Thank-You in advance.
Top Dog

I haven't actually played with coding any VBA to make anything happen regarding Excel.  (I'm running
2k3, as part of Office 2k3.)  So while I know VBA (not as an expert mind you), I'm starting from
scratch when it comes to dealing with Excel, regardless of whether we're talking ...