I'm sure you all have answered this exact question because it must be common.
I just can't find the answer.
I want a cmd button on my form that runs a report, analyzes it with excel
and opens excel in one click.

I’ve been struggling with this code. It seems to work now except I don’t
understand why the message in grpConcur_AfterUpdate appears when the
condition is "if vendor <> 17 or <> 18" and yet the vendor does = 17 or 18.
Obvioulsy I have something wrong or in the wrong place.  Can ...

I have this code in beforeUpdate, but it does not work.  All I want is to
force a name in the field, making it A-Z would be nice but just making give a
MsgBox saying somethings wrong is a start for me!!
Thanks

I created two forms which are Start and Display forms. The Start Form has a
drop-down list which can select the year from, and a cmdAll button on that
form to open the Display form. The display form lists all records from
continues years and contains two fields Effective Date and ...

I Got A Code In VB6 It Mainly Use A Command Button Like This
Command1.hwnd
but In Access There Is No Property For The Command Button Or Other Controls
Named hwnd

Access2003
I have one table.
Two forms, each with a combo box in the detail section and within each
form a subForm (wanted datasheet view) showng the remaining data as it

Is there a way to code a command button in its on click event that will
prompt the user to enter a password to perform the command button's
operation?
Thank you.

I would like to apply a simple filter to a subform from the Mainform.
Main From = SearchPage
Sub Form = Cat Codes subform
Filter Box = Text49

I'm trying to count how many times something happened on Mon, Tues, Wed... I
have this code in a query trying to make it work, I have been unsuccessful.  
If I can get Mon to work......  
Thank You

I've searched through the group but I can't seem to find exactly what I'm
looking for.
Using 2000 ...
I have a combo box on a form.  The row source is a simple query.  The

If I link to a CSV ( comma seperated value) file does access think of this
as a table with records and behave the same way.
I was wondering what would happen if you had say 5000 records in a text file
and each record had 50 fields Would it be slower than if the 5000 records

Hey all, with a new version of Office once again comes a question from me
about adjusting my coding.  I'm still very much new to learning the Visual
Basic language so bear with me if you find the answer to be blantantly
obvious. :-)

I created a form will display the records from a table. The records in the
table contain years (mm/dd/yyyy) information. I would like to write the code
to retrieve the records based on the year range. For example, retrieve all
data from year 2000 or data from 2001.

What event should I use to check values entered into a new record on a
form?  The easiest one for me is "On Click" for a particular textbox,
but it requires user input. For the form itself, from "AfterUpdate",
On Current and "Before Update" are candidate--which one?  Or are there