My table is a history of tools borrowed.  When a tool is returned I want to
select it from a drop down box to bring up the record.  The same tool is
borrowed multiple time so it exists in the table multiple times. My drop down
box contains two fields, the other one being the date ...

^ doen't seem to work

Is there a place I can view the North Wind sample other than as a sample on
my Access.
As I am using this for work, they have removed the sample and I am not able
to download it.

HI,  Does anyone know how to format a text field in a form so that it shows a
time - time format?  For example 9:00 a.m. - 10:00 p.m.?  
Current I have 09:00" - "09:00\ >LL;0;_ as the input mask and the format set
at medium time.  My data appears as 09:00 AM - 10:00 PM  

Hello...I have a Combo Box that linked to a table for a certain field in my
Form.  I'd like the user to be able to select the choices in the Combo Box,
but the last choice in the Combo Box states "Enter Comment".  I would like
that choice to be edited.  Is there a way I can make one ...

This is about an alternative to the property Painting of the Form
class.
As documentation says, this property has no effect when the form is in
datasheet view. It is very sad (for example, because our users are

I have an unbound combo box that looks up citation numbers. For example, when
I click on citation number TB00000001, in the combo box, I know that it is
record 1 . However, when I tab over to the next field, it jumps to record 2
which is TB00000002 even though TB00000001 is still ...

I have beat my head against a wall for two weeks on this problem. I have 8
queries that I need to pull onto a form. The problem: 800,000 items in those
8 queries. I have tried building a "super" query with all 8 queries pulled
into one but that is too slow and takes to long to ...

I have noted how experienced many of the users here are, and I was
curious as to any books you would recommend to a intermediate user. I
currently have the access 2000 "bible" but would be interested to hear
any others that have a great source of information and tips on access

I have been using a spinbutton ActiveX control to change the time/date on an
Access form. One click on the up button adds an hour to the time displayed.
This works quite well and essentially I am happy with the operation of this
control BUT... although this is included with ...

I have a query as the Record Source of a login form.
I placed the following code at the end of the Click Event on the submit
button:
If Me.CU.Value = "Yes" Then

I'm getting a Syntax error on this line.
   If FileExists(strPath) = True
What could be the reason for that?
Here's the all of the code:

I figured out how to write the expression I want to use
mystr=right([schoolname],8) but I have tried entering it everywhere in the
properties for the textbox and no work. I just have a field in a textbox that
I want to return the right-most 8 characters or I could just eliminate ...

Using Access 2003.
Very simple, I have a command button to close the form.  Code is as
follows (form is called "Select212Form")
Private Sub btnMenu_Click()

Access 2000
Insert starting id# in tables
in text field - need more than 255 char.
can we import responses