I'm trying to filter a form via VBA on a specific date:
{formname}.filter = "Date = #" & MyDate & "#"
Unfortunately the date notation swops in the Form window so i filter on a
complete other date.

I am getting the error: No value given for one or more required parameters.
The line in my code that is having the problem is:
rs2.Open sSQL, CurrentProject.Connection, adOpenStatic
Does anyone have any ideas?

I'm trying to use Automation to control Excel from Access.
So, first of all, what I am doing is that:
Dim appExcel As Excel.Application  'Global variable
Then, when clicking a button, this codes executes:

Hi. I need to calculate the interval between two dates in terms of months,
and I can't figure out how to make datediff work in the decimal form that I
need...
For example,

I have a database for making and implementing recommendations.  It  has
sections for the initial recommendation, the response, the follow-up, and the
final approval.  Each of these sections has four to six fields.  My initial
version of this database uses a single table.  The ...

I know this can be done but have forgotten the code syntax.
What I want to do is, when a user exits a form, detect if other forms/a
specific form is still open.
A reminder of the code is appreciated.

I have a subform that is opened off a main form with a button.  What I would
like to have happen is for four of the fields to link back to the main form
and be populated with their values.  The subform is a billing form that is
used by several other main forms as well so it needs ...

I created an option box which would allow users to switch between an "edit"
and "view-only" capability.  However, once the "view only" button was
selected, I could no longer switch back to the "edit" mode.  I got around
this by putting the option box into an unbound subform.  I ...

I haven't quite caught on to getting this right. Thanks in advance for
helping my syntax. Something's wrong with the quote marks:
   strInsert = "INSERT SentinelNodeSt(AppointmentID, EmpCreated,
EmpUpdated)" & _

I am having problem with the auto list members staying on the screen.   This
is the feature that helps you with VB code by listing available
options/variables with a drop down list on key words.  For example if in a VB
form module you type "Me."  it will list a drop down list of ...

How would you loop through the field [washed] in each record using the
single form mode, not continious?

I am trying to figure out a little problem I have with my database and am at
my witts end.  Here is the deal.
I have products that are assigned a certain material number.  In my form I
have a combo box that lists the material numbers and description, what I

I have several checkboxes in my table. What I want to do is when I view my
table I want to see Yes or No and not a picture of the checkbox, checked or
unchecked depending on the selection. Even 1 for Yes and 0 for No would be
good. Please advise.

Hi, The following code allows the user to search for a record using a combo
box. If the record is not found, the message appears. When the user clicks
OK, I would like the fields contents to remain selected, ready to accept the
next entry. This code is not doing it in the ...

I'm new to Access and VB - I need to create a subform 'on the fly' (ie in
code) depending on the contents of my main form. I understand that I need a
control and a SubForm form type. How do I proceed please?
Cheers,