Good day,
I am trying to code for the following:  
If the current time of day is less than 8:30 am and greater than 5:30 pm,
exit sub.

I have 3 tables joined (tblCSD, tblSpecialties & tblCSD_Specialties).  tblCSD
has my demographics with primary key CSDID, tblSpecialties has a list of
clinical specialties with primary key specialtiesID and tblCSD_Specialties
has the joined data of CSDFK & SpecialtiesFK.  I then ...

I'm trying to pass a TreeView control to a public global method to populate
the tree with data from the DB.
Here's the call I make from the Form Load:
Private Sub Form_Load()

Hi;
Second time I'm asking this question, and hope someone can suggest a
cure.
I'm running a form with a cbo box for data entry. I have 5 other

Hi Folks - this is weird - heard about others having refresh problems with a
combo but never experienced this until now.
Combo is on a subform: Rowsource is a table that has 600 plus records, and a
ControlSource in my main table.

I'm using following notinlist event code for a number of cbo's on a
form (that are all very similar), yet this particular one fails to
work properly.
After event is triggered, form is opened, and data entered, my cbo

I want to make customer information appear in the subform when I click a
command button. How might I do this?
Thanks Dustin

Hi, hope someone can unmuddle my brain here.
We have a db at work tracking all the phones, equip., fleet cars, etc. and
separate tables for each tracking the assigned users, who change throughout
the yr. Only 1 person has each piece of equipment at any one time.

The width property appears to be ignored and there isn't a height one
visible.  Having a form with only 2 relatively narrow columns open at
~1500pixels wide looks really bad.

The title for this may be a little simpler than the problem I'm trying
to explain.
In my database, I have:
tblPCName

I Didnt Get My Lost Post Answered Correctly Maybe Cause i Didn't
Explain my Self Properly. .
Have a Main Form Named Enquiry_Input, Where The Data Source Is a Query
Which The Query Is a Representation of the Enquiry Table, With An

Call Shell("TEXT.txt \\C:\labels.txt", 1) returns "file not found"
I am sure it is the  "TEXT.txt" that is causing the problem because I was
guessing.  Thanks

Using Access 2007, Windows XP Pro
We have a form that automatically generates an email to specific people,
based on the information collected by the form.
A number of our users who will fill out the form do not have Outlook on

I am looking for some help for my data entry form. In the form there
is a combo box, which is used to enter date ("cboLongDate"). The date
format is "Wednesday, June 13, 2007" . I need to confirm the day is
Wednesday or not before the user click on add data or close form. The

I'm using the calendar to allow my users to request/report comp time,
vacation, sick.  I decided to have them create a new record for every day
they want off.  A lot of users are complaining that they have to reset the
month every time they create a new record for say around ...