I try to to set the value of a text box through code and it will always
display the same value in every record. I think i cant display a
recordset in a text box. What way i use so that i can display my values
in the text box.

Here's my plan for creating nightly backups of the production back-end file
(the IT staff in their infinite wisdom have prevented use of Windows
Scheduler and users do not have administrative rights to Windows).
Candace Tripp has an automatic backing up program that  I modified for ...

I wrote a query in Form_Open method but i didnt bind it with the
textbox. How to i bind this whole method with the text box, as right
now the textbox shows the last value of the recordset. The textbox is a
part of a subform and it shows three times the last value of the record

I want to append a number of records onto an existing table.  Each record
will have an ID number (it is not an autonumber as it is too variable).  It
is currently set as an integer field.  I want to be able to work out what
the highest existing number in that field in the table ...

I would like to combine two of my tables into one:
Task 1  - Forecast  - #
Task 1  - Plan         - #
Task 1  - Actual      - #

I would like my Post Code field to be autoformated in CAPS when entered in
the table. How do I do that?
Julian

I have just had a play for half an hour (OK not exactly a beta test!). I
must say I was quite underwhelmed. Yea it looks nice, navigating things was
bit quirky, but it's only a beta right. AFAIK, the ribbon was designed
primarily for Word and Excel users so no breathtaking new ...

Hey All...
I have a form that has a Before Update event of:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.NewRecord Then

I have an unbound form to generate reports from in an mdb that we share
on our network drive. The users selects several options for the report,
such as what to view, the sort order, etc. These choices are then
stored in the tags of the controls. The report creation button reads

I would like assign a number to each row in the table. The number can
be row number. For example, the first record in the table can be number
1.
I can do this thru VBA code. Can I do this via SQL ? If so, how?

I have a table listing drawing numbers for jobs. It's primary key combines
Job and numeric part of the drawing number. The structure allows the number
part to repeat for each job.
    Job       Dwg

One of the fields I have is a Client Number which is entered manually in a
Table. This Column is sorted ascending in a Report I have, but insted of
sorting them incremental ascending the Report sorts them by the figure they
start with, then the second figure etc, so I end up with ...

Lets say we have a form that displays time card entries based on the
calendar control date on the form. So the user clicks on a date and the
form filters the table where the time card entries come from to get you
proper data.

I have created a input form that enters a number in a talble.  If I
open the form again it enters a new record instead of editing the
existing record. It seems like it should be very basic but I see no
way to do it other than a complicated macro.

Hello. I was hoping that someone may be able to assist with an issue
that I am experiencing.  I have created an Access DB which imports an
Excel File with a particular layout and field naming.  Next the user
can go into a Form which basically a dynamic query with a friendly