I am looking for a method to strip out any line breaks or carriage returns.
I have imported some data and one of the fields has line breaks & carriage
returns. I need to convert this to a CSV file with no returns and line
breaks etc.

  If someone can please help with the following task:
1) using a combox (selection from a query) to select which record to display
in subformList.
2) based on user click on which row on the subFormList, all the details

I have a listbox named programlstbx which the user selects a couple programs
to make labels for mailing purposes. I have it coded as follows
Private Sub LabelsLink_Click()
On Error GoTo Err_Handler

Does anyone know how to add the value in a calculating text box on a form in
to your DB. HELP.

I came across Microsoft's Article Q148463 "Parsing Titles Beginning with
"A," "An," or "The"":
http://support.microsoft.com/kb/q154600/
But I don't know how to use it.  The field that I want to change is

I have created a subscription database to store subscriber and subscription
information.
I currently have a problem whereby 1 subscriber can subscribe to a number of
different ones which is fine but I want to now print off lables for everyone

I have a form with a field that requires the user to input a date (DATE1),
then another combo box that requires the user to also select a period based
on the financial calendar that (DATE1) falls into.
eg. if a date of 31/1/2005 was entered they would select 'week 45' from the

Could anyone tell me how to update a table from a form.  I have both the
table and the form but need to know how to do the update using a button.
Thanks in advance,
Paul

I'm using AccessXP. I have a supplier form with a details
subform. I can find  any supplier and populate the main
form and subform with details. A supplier can have
hundreds of rows in the subform which is in form view.

Could anyone tell me how I can set up my form properties so that each time it
opens, it displays a different background picture?  

Would anybody be able to tell me how to add form contents to a table? I
have got the form and the table set up, i just need to know how to link the
two and actuallly do the update using a button.
Thanks,

I have an Access form and it has always worked since the day I finished the
design. Today for no apperant reason Microsoft Visual Basic "Compile error"
window popped up when I tried to execute an On_Click event on that form
saying "Wrong number of arguments or invalid property ...

I have an application I distribute to different companies.
It is the same application except for one form and table
which is specific to the company - reflecting their
specific use of the application.

Is it possible to select multiple records in a form using check boxes ?
Suppose I had all the records from a specific table or query displayed in a
simple form; each one with a check box next to it.
My coworker only wants certain records from that form printed in a report

I have 3 conditions which affect the visibility of fields on a form.
Which form event will check these conditons and display the 3 fields
correctly as I move from record to record?  Right now I have these
procedures running on the form after update event, but it doesn't work