We have a need to replace sub strings in certain message text.  We use
the Office Assistant to display help and often use the imbedded
formatting commands.  Those of you who have used them know they look
like this: "{cf 5}" or "{cf 0}" or "{ul 1}" or "{ul 0}", etc.  The

I have written and distributed my first application using ms acces as
the database and seperately programmed visual basic as the UI.
I need to update the application which required a database change.
What I need to know is how can I re-distribute my application with the

I hope that I explain this in a manner that makes sense.
On the form that I am working on, I have a box that I've setup to input
the amount  of scans that I've done for a client (call it the SCANS
box) and in the next box I've made it automatically input the cost of

I have a database where I collect shipment data from various tables.
However, I have a problem. Whenever I want to see shipping data for
orders that were set to ship on or before a certain date (in this case
January 30th) the database will return 2 rows for an order as you can

Help please.
I would like to automate the printing of  a report.
The report actually is a single page and prints a label. I would like to be
able to print the report multiple times based on the value of the items

I have the following Table:
Table: TASKINFORMATION
- TaskName
- TaskType

Dear Access 2003 Users,
Is there a way to pop up a MessageBox warning when a user changes data
on a form?  Basically, I have one field that I really want people to
think about before changing, so when they get to that field (which is

I have a form which contains a subform.  The subform is a datasheet.
With the datasheet I have the following fields
1) ID
2) Type

i want to set the caption of specific field using vba.

Hi - I have a date field in a Access database in the format
YYYY/MM/DD HH:MM
I have set up 2 date parameters as below but only want to enter the
date and not the time. If I do not enter the time no records are

Here is the scenario.
Access XP using VBA.
I have a text field.  The text that I have in the field is m-1234.
I am running a >= seek.

How to call procedure, which is on SQL Server from Access using visual
basic?
Thanks,
mw

When I filter a form by part number it returns 3 records.
If I move to the third record and print it, the form returns to the
first record.
Can I force it to stay on the chosen record?

I have a MS Access db that is hooked into a .NET application.  I created
this a while ago and when i try to access the crystal report code it asks me
for Server, DB, Uid and pw.  I have no clue what i set them to.
I would like to remove the logon completely if possible to bypass the ...

Dear reader,
I found out a strange behaviour in a query of the type Total (summation
query).
In case of a normal select query with a criteria setting Is Null for