I have several list boxes on a form that are very lengthy,  i want to give
the users a way to search in each list box. Wha is the best way?  I tried a
combo box above each one but not able to go to the selected record in the
list box.

I have a continuous form that can insert new records to the bound table.
There are 2 hidden fields for columns in the table that the user cannot
directly set. One of these is a numeric (long) column that has to be set to
the highest current value in the column plus 1 (don't ask ...

I am trying to create a unique value between two fields.  The first is going
to be the current year, the second, an increasing number greater than the
preceding value up to 999.  The problem being, is when a new year starts, I
want the number to start back at 001.  I am looking ...

Hey everyone,
I am having a problem getting my subform to allow edits since its property
under normal conditions does not allow edits.  I understand from looking at
posts that the format should be :

Is it possible to use the macro code from Excel in Access?  I have an Excel
spreadsheet that when you click a button it goes to our company's databases
and pulls data down.  I want to do the same thing with a command button on
Access, but want to use the same code.  Is it ...

What please would be syntax for update rather than Insert; I want my table
which has already the record to be updated (the three fields) - see who
changed the records.
Please see below.

I am trying to use the tree view control and have modified some code found on
the Microsoft website KB 209898 in Access 2007.  This is my first attempt so
I am just learning the ropes of this complex, but usefull control.
I copy the code on the Form_Load event and when the form ...

I have a textbox called txtTOT_MINUTES and a listbox called lstHOURS.  I want
to return the sum of column 7 in my listbox.  I wrote the following code in
VBA but it does not work.  Any help would be appreciated.
Me.txtTOT_MINUTES = Sum(Me.lstHOURS.Column(7))

I have a huge problem.  We have a database to keep track of "windscreen
repairs", and one of the employees, while adding a new job, deleted the
number which was in the "autonumber" field by accident, and now it wont let
us go in to add another job or do anything.  I tried going ...

I have this code in a form; can you please tell me how can I make the
records that allow edits to have all the fields mandatory (cannot go to the
next one until the previous is properly entered)
Thank you,

I'd like to ensure that all input into a textbox, 'tboxNumber', is numeric
and/or a decimal point. The input must be text, not a numeric type.
How is that best done? The number has to have at least 2 digits to the left
of the decimal, but can have up to 3 digits on either side of ...

I am trying to prevent duplicates being entered in my form and if someone
enters number that is already in the table Projects is should go to that
record.
Do you now if this code works only if the field (strStudentNumber) is

Strange request and it must be quite simple but I don't know how to do it.
I need to run a procedure, either update query or code, that will run
through every record (either from within a form or directly to the table)
that will pick up the current record number and place that ...

I have a key field "DRNO".  Its the first field on the form.  When the user
exists the field, I want to check to see if the DRNO already exists in the
database so the user doesnt end up filling out the whole form only to find
out it already exists.  

Hi All,
I am getting the 3134 Error message (Syntax error in INSERT INTO statement.)
and I would like to know how to resolve it. Please help.
Background information: