I have a subform (continuous) that receives the info thru a query.  In the
query is an added field for providing the amt of time in a given time period.
This works fine and provides the info in a short time format.  What I am
wanting to do is to have the subform display the ...

I have a form where I compare two records from two different tables.  
If the records match, I need the onEPLSDb checkbox checked off and the
RecordScrubbed checkbox checked off.
If they don't match, I only need the RecordScrubbed checkbox checked off.  

I am trying to open a form using a numeric variable as the stCriterea.
My Code is:
   Dim stDocName As String
   Dim stLinkCriteria As String

Can someone help me figure out why on one workstation i have Access2003
front end reading a backend db on our server without any problem ( user
has 'limited' Privileges on XP) and on another workstation with the
exact same OS and Access version the user (with 'limited' privileges)

Hello...
I'm trying to apply a filter on a form (main) from two sources (tables).  
The first set of combo boxes pull from a main table and populate the
remaining text boxes on the main form.  This works with no problem.  I have

I created a refresh button that requery one of the fields on subform in the
main form. It works perfectly when I click this button. I'd like to use this
code every time I go to a different record  on the main form. I pasted it
into "on change" event of my ClientID on main form, ...

Hi, I did post this question but think I may have asked it wrong or posted it
to the wrong place.....
I have this query as the row source for Enforcement Subtype field.
SELECT Enforcement_Subtypes.Enf_Subtype_ID,

Good morning,
I am using Windows XP Pro and access XP Pro (2003).
When I use an input form that I've created I sometimes get halfway through
the form and say "oh hell, I'm tired!"  At this point I reach for the small

This is basics stuff - but trying to understand.  If I run this, I get
expression type mismatch at the set rst statement.  I can't even get to the
with statement.  I eventually need to get to a place where the user chooses
an entity with comob0, then this code will determine if ...

Is there a way to open a form based on which group of users is logged on?
For instance, I have created Role - 'DataEntryUsers' and 'Admin'.
If 'DataEntryUsers' log on, then either I should turn subform to read only
or create another form to be called.

To facilitate navigating the database, I hide and unhide certain main forms
and I needed a way to "remember" which form I came from so I can unhide it
when I am done with my little side trip. To remember how I got there, I have
set up public variables (strings) called TargetForm ...

I have a switchboard which operates normally when any item is selected.  If I
select Item 3 which opens Form2 it works great.
However, I want to open the switchboard normally and then AUTOMATICALLY open
Form2 so that the user saves a key stroke (yes I know this is stupid).  What

I posted this before, but got an answer I did not understand.
I need to have the date a check box was clicked stored in a table.
I created a macro. The action was SetValue. The item is caled [Email
Verified Date]. The expression is Date().

Hy,
how can I doin in MS access base, that  is one table of base invisable for
sometihing people to users of base. Example if we have base with tree table ,
I want thta one table be visable only for one (administrator) user. How can I

I have a report that shows sales by customers.
I would like to set the report so that if the user clicks on the customer a
2nd report will open and show detail for that customer.
Can I do this if so how?