I have a form on which I have a combo box which filters a User Name field
combo box on the form, depending on which User Name I select.  The code I'm
using is
DoCmd.ApplyFilter , "[LoggedByID] = " & str(Me![cmbFilterMgr]) on the After

I am using the following code to place a number in a text file. I open up
the file, find the data and print it to the file. The problem is if the
number is negative the first character in the field of the text file is the
negative sign (-).  Is there a way to convert the number ...

Thanks for taking the time to read my question.
Just wondering if it is possible to change the appearance of buttons on a
form.  Can you make them appear Flat, Raised, Sunken with code?
I have done this with Labels, and have onClick events on the Labels, but the

I have two subforms sitting on a form (on a tab control).  I want to link the
two subforms so that if they change to another record on the top subform, it
goes to the record in the bottom subform.  The main form is not bound to any
table.  It is just be used to hold the tab ...

I have an access report exported to a excel spreadsheet. Everything works
fine, but the content data gets restricted somewhere. For eg., I have a
comment field with datatype memo in access, if i export to excel am not
getting the full data exported. I am not sure where am doing ...

I have a simple form in Access2002 where users
will be modifing data in a memo field.
When they click the close button, I want to
prompt them to Save the changes or not.

I am using Access 2003 running as 2000. My PC's OS is WIN XP Pro on a windows
2003 network.
I am the developer with sole ability to view and maintain the database. The
database should sit on the network but will not run the VBA code below when I

I have the following function that I apply to a form for an applyfilter.
Function filterHistory()
   DoCmd.ApplyFilter "filterHistory", "[tbl_Dividend]![Ex_Div_Date]>Date()"
End Function

I have the basic code setup but it isn't quite working. I have a button that
when clicked:
If my hyperlink field has any value other then null, I would like to open
that hyperlink. If the fields value is null then I want to do something else.

I have problem trying to make fully automatized delete of existing data in
table via VBA code.
I want to skip warning: "You are about to delete __  row(s)from the
specified table. ... Are you sure...?" that Access always asks.

is there such control as multi-select listbox or combo box for access?
if yes, how to activate?
if not, what are you using instead?
tia,

Hi,
I have an option box with 3 values that when selected changes the record
source based on tasks completed and not completed, this works fine(I have
this code in the Criteria of the [Tasks] tick box.

I have 2 tables, Vehicles (PK "VehID") and Other Info (PK "OtherID"), joined
in a one to many by VehID field.
I have a main form "Vehicles" with a subform "Other Info" displaying related
records.  From the main form's "Add New Record" how can I also set the

Hi, all;
I have split my database to allow me to continue to work on the FE while the
client uses the existing FE to enter production data into their local BE.
The scenario is this: I pass them a new FE that, upon startup, looks in the

Sorry if this question has been asked. The threads that I went through
mentions a form cannot be printed and the best way to print a form is to save
it as a report. I tried tinkering with it and sort of managed to output to a
report format ( via a print button, not sure if it is ...