I have a form with a unbound field to input to filter out the data, what do
I put in the code to filter two unbound fields instead of one? Other unbound
field is named SelectSide. Thanks
Here is my current code.

I made this sub() so that anytime I need to I can remove all the trailing
returns from any given field in a table.  I need to pass 2 strings to it, the
name of the table & field.  But it doesn't work.  Can you not pass 2 things
to a sub?

What is wrong with this code.  I get a compile error on "!cboCycle" that says
"Method or data member not found".  If I change !cboCycle to !cboDept I get
the same error but !cboDept compiled earlier in this code.
DoCmd.RunSQL "UPDATE tblEquip INNER JOIN tblPMCurrentTasks ON

I'm getting the following message when starting an Access 2003 databse:
Your database or project contains a missing or broken reference to the file
'richtx32.ocx' version 1.2.
How do I resolve this?

Good day,
How do I remove the letters from a string of text.
is this possible to do with an expression in a query?

I am getting runtime 2450 based on the following code. I checked the spelling
of the form it refers to and the spelling is correct. Can anyone help me.
Here is the code:
Private Sub Form_Current()

Hey all,
I am trying to delete a table in the backend database using code in the
button on the frontend.
I know there was a post already answered concerning this, the answer using

Access does not recognise my date format correctly and shows errors
Hi,
Access does not recognise my systems date format correctly in a link table
to a .csv file.

I have my code import a table from another database, but the trouble is, if
there's an old table by that same name [Name], then it imports the new one as
[Name1].
Can I have it overwrite the old one, or what is the code to just check if an

I'm having a problem with Access mdb files ballooning to some absurd size
after generating some records by collecting value from a form and writing
them back to a table with some VBA code.
The database has 4 modules, 1 form, 1 table with a max of 100 records.  It

I am using sendobject to automatically send emails from with an access 2000
form.
When i do this i get a messge that a program , ie ms access is trying to
send an email and whether or not i want to stop the process, how do i get rid

How Do I import a table from another ms access database into the current one?
I have:
strFolderFile as the complete path to where the database is
strTable as the Table in that database that I'd like to copy into my database

Good morning everyone,
I have a report that prints out scorecard information for each vendor. Each
scorecard takes up 1 page so a different page is for a different vendor. I
have adobe acrobat distiller so I'm able to convert the report to a pdf file.

I have a form used for entering client case data (frmCaseInfo).  This form
has the field StartDate on it.  There are times this field is left blank due
to the fact that the initial record is sometimes added weeks or even months
before a start date is decided upon.  Users often ...

have an autoincrement
Dim Job As Variant
Job = Nz(DMax("Job", "JobTable")) + 1
the data in the Job field is always an integer but the field has been