How can I use a button's click event to host code that allows a user to
cancel a new record when one field in the form belonging to that record has
been filled in?
Thanks,

Could anyone please tell me what the equivalent is in VBA of the "Like"
function that you can use in query criteria etc. and the correct syntax
for using it?
Many thanks - David

I have a drop down box that finds the "salesrep name" in my "sales rep list"
with the select query that the drop down makes.  It stores the rep number on
the form.  I need to do the same lookup but pass the name instead of the rep
number.

I have a table called "Lab_Results"  which has fields LabID (autonumber,
primary key), SSN (text), Date (date/time), LabType (text), and LabValue
(numeric)
I tried to set my form up so that the SSN and Date were at the top and would

On my Main Form I have a CmdButton I want to disable if the Focus in my
subform is the AutoNumber
and when a record is selected in the subform I want it enabled. I have tried
several different ways

I have a Date/Time named "CALLED_ON".  I would like to add up all of the
dates in "CALLED_ON" throughout the table tblRESUMES which equal today only,
e.g. if today there were 50 calls, at midnight it would rollover to 0 because
new day and no calls made at midnight.  I woul dlike ...

I am embarressed asking this question because I feel I should know the
answer, but which property do I use to programatically change the state of an
unbound checkbox from True to False?
I thought it would be the Value property but I get an error stating that:

Hi;
To make a security system to prevent copying,i want to use some information
from the current
system (that my program will be installed on) hardwares.

Hi;
I want to get serial no. of a system H.D.D .I used this WMI script on win xp
but it doesnt work.AFAIR wmi is installed on Win XP by default but dont know
what i have to replace in this code ,or what other is wrong:

Here's the problem I need to solve in vba.
rptMyReport is showing on the screen in preview.
I need to automate as much as possible the naming of a pdf file without user
intervention.

G'day all,
I'm pretty new to Access (but have a fair amount of Excel VBA experience) so
I suspect this will be the first of many posts.
I'm creating an Access 2000 front end for a SQL Server database using linked

This may sound stupid, but, does any one knows how to disable the mous
wheel from cycling through the records. I know I'm doing somethin
wrong, but can't find it.
Thank

Ok form has 1 bound combo box and 1 listbox the unbound listbox updates the
regoin fine by using the following:
Private Sub Select_region_AfterUpdate()
   Form.RecordSource = "SELECT * FROM [WCC Dealers] WHERE REGION = " &

I am writing a macro to be used on different spreadsheets.  I need the
keystrokes to program to go to the first empty cell in the leftmost column of
the spreadsheet.  Do you know the keystrokes that will work in a macro?  I
used the keystrokes on a spreadsheet that took me to ...

I have a system that allows reporting from imported data. I keep a track of
what has been imported via a table called tblImportLog. The data itself goes
into tblImportData.
When a report is requested, I look in the log to see if the data is present,