I am needing to Parse some text fields, where a 3rd party application i
use stores data from a user created expression.
the user creates and expression such as this:
ActualSizeYN =Y? SubassyL : BackDadoYN = Y ?(BaseRailYN =Y ? SubassyL

I'm wondering if someone could help me out with this problem. We have
a database in Access for our library. We also have it linked to a web
search. If a book is authored by two or more authors, when the results
show up, the book is listed once for each author of that book. If it

I have a table for recordings, a table for playlists, and a table for
playlist details, that uses the primary key from the recordings and playists
tables as its primary key.
I would like to develop playlists quickly, by just typing in the

I need to import a text file pretty much daily.  I download the file
and change the name to a standard name and then run the code to import
the file into a table in my database.  The problem is that the file
starts with a standard name but adds the date and some other stuff to

I created an Access 97 database a while ago. It is protected by Workgroup
Security, and it is not split.
In order to compare different sets of results, a colleague has suggested
that it would be useful to run two instances of the same database on

I have another post regarding this "attendance" report of mine...this
one concerns one of my sub-reports.  It loses its alphabetical sorting
when inserted in the master report.  When run separately, it's
perfect.  Once inserted and printed in the master report...the data is

I have a table on the database that stores the details of a mailing
list such as name, company, address, email and so on. Is it possible
to update (or link) all the mailing list table fields into Microsoft
Outlook contacts? If yes, any ideas how?

Thank you in advance. Is there a way to update Runtime Versions of Access 97,
with just the Queries, Forms, Macros, and Modules, leaving the tables in tact?
Is there a bit of code to do this, or someplace to learn how to do so?
Michael

I have a form (frmAppointment) with a subform on it
(frmAppointmentsub1).  I have placed a command button on the main form
which calls the function below from the module.  The purpose of this
function is to make fields beginning with YY invisble OnClick of the

Is there a way to change the background color of command buttons?  I
know that I saw some VBA code somewhere that showed how to do this.  I
think it involved making the button transparent and then creating a box
the same size and making it have a color for the background.  Although,

dear respected Gurus,
i would like to know what is wrong with my codes, i wanted to put
PolicyNo(say any string value, which is PK in table)...how to do? as i
make one inputbox it asked the value, but says "you cancelled the

My Front End used to be around the 30megabyte, now it is 60 megabyte....
this change occured almost overnight and I have done the compress thing many
time (I am running MS Office 2003).
When I ran a couple of procedures, it went up to 1.3 gig!

I have a form (frmAppointment) with a subform on it
(frmAppointmentsub1).  I have placed a command button on the main form
which calls the function below from the module.  The purpose of this
function is to make fields beginning with YY invisble OnClick of the

does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in
column B always enters the date that the certain #  was entered into column A.
or a good tutorial will help
im using access 2000 and the generel date/time ...

In a select query I am attempting to combine two fields:
One where Field1 =  "AL" the other Field2 = "01"
I am writing:
NewString = [Field1] & [Field2]