in Access 2003 I am trying to get sql query to run using a field as
input, but I want to input into the field a value that uses the "like"
operator to find any value that starts with the value placed in the
field.

The following code is working for everything  but the column formatting
on lines 9191 and 9192.  It doesn't trap out - just doesn't "take".
"fChart" is a pointer to the open form that has the Chart object on it.
--------------------------------------------------------------

Hi i'm now using BeforeUpdate
event to call my function which checks through my form.
If the checks are ok then the form is allowed to save.
However a new page is not created when this is done.

I'm using a laptop that has an access database i designed.
When I open the main form and start scrolling down the form page then scroll
up again, certain field heading labels vanish. They are visible when the
form is opened but when scrolling they disappear. However, when I enter ...

Dear Tom
With this code:
Public Function FTP(ascii As Boolean, send As Boolean, pathname As
String, FileName As String, server As String, serverpathname As String,

i have a table with 2 columns, i just need to export just one column
into a text file?  Can someone help me with this?  thank you in advance.

I've got an IF statement that i want to check a load of text boxes on a
form to see if they have all been complete
If ((Form_form1.txtReceiptNo.Text = "") Or
(Form_form1.PaymentMethod.Text = "") Or (Form_form1.PaymentAmount.Text

Hello there! I'm Still pretty new to access only been using it for a
couple of days.
If a record has been partially filled out or even completly filled out
and then the form is closed or the user clicks to view an alternative

I am trying to run an Excel macro from an Access module, however when I
run the code the macro runs but then I get an error in Access. The
error is: Run-time error "440", Automation error.
My code is:

Need some assistance, I am trying to take recordset from Access that
contains Names;
Name1
Name2

Choosing ADO or DAO for Working with Access Databases
-------------------------------------------------------------------
"When you use the Recordset property to set the Recordset object of a

I'm converting the backend of an Access 2000 database to SQL Server
2000.
The existing database has user and group security through a specific
workgroup file.

I'm looking for a way to determine if the client machine has access
installed and if so, what version.  The reason I need this is to determine
(programatically) if the Access Runtime is required to be installed and if
not, which version of the program database needs to be ...

Hi, I have a form that has an amount paid, billed amount, and expense
amount field.  All three of these fields always has the same value.  In
order to minimize keystroks, I'm trying to input the value in one of
these three fields and have the other fields fill in automatically.  I

I'd appreciate any help I can get.  I'm not sure what I'm doing wrong,
but....
I've searched these groups for some solutions but no luck.
I have an unbound form (frmSearch), with several unbound text boxes on