Can anyone tell me how to format a text box to display the following:-
RTA/CG/0000220/07
Where RTA/CG/ is text
0000220 come from field RTARef (How can i include the preceding zeros?)

I have a form that has two combo boxes on it. The combo boxes apply filters to the form's underlying recordset.
The first box has a list of states and the second has a list of customers.
When the user makes a selection in the state combobox I want the record set for the customer ...

I am trying to create a query with a field called CostCode.  It is a field
that disguises the cost of a product in a hidden formula based letters
instead of numbers.  The formula is as follows:
1 = P

I posted about a week ago and had some usefull feedback from J Goddard, but
ultimately it didn't resolve my problem, so here it is again;
My problem is the cursor remains in the field Text34, at the start of the
entered text, after the following code runs, I want it to leave and ...

Earlier I have requested for help on calculating the time difference in
dd:hh:mm format which is day:hour:minute...as below:
==============
Hi,

Winxp and access 2003
I have a table with these fields
CoID    CoName          Location                Street
I pull the info into the form using cascading cboboxes

I created an employee form which allows the user to delete the employee by
hitting a command button.  The  code behind the command button then deletes
the employee as well as all of the supporting tables.
How can I prevent the user from deleting the record with the delete key, so ...

I have a main form and another form(1). They both work from the same primary
key(application number).
When I navigate from the main form to form(1) and then back, the data
displayed is filtered by the same application number as I want to be able to

I have form that is bounded by a table called Inventory and what I want to
do is to push a command button that will copy a record from the Inventory
table and paste it into another table called Audited with the same identical
fields.  How do I do that.  Any tips will be ...

In my form I want to have a search box looking for two fields in particular.
One field is the Auditors Name and the second field is the Audited Date.
For example the user will type example below into a search boxes:
Auditors Name       Audited Date

I have a form that has a club and a branch.  I don't want to have users
having to data enter the combined field:
frm_data!combo_field = rtrim([club]) & Rtrim([branch])
I can get it to show the combined field in the form, but can't get it to

I am trying to test between two dates using:
If 2 > DateDiff("d", DueDate, OpenedDate) Then
MsgBox "The due date .......
but it always tests positive no matter what the dates are.  Can anyone tell

I can't seem to get this Dsum right.
Dim PreviousScore as Integer
Dim rst As DAO.Recordset
Set rst = Form.RecordsetClone

I am hoping someone can help. I need to run some sql and have it use
the results of that query to print out some documents.
Here is the query:
SELECT tblMyTable.Id, tblMyTable.Desc, tblMyTable.DocName

I have designed a Form that when you enter an amount into a field and press
enter a macro is executed to take you to the next record (On Exit Event
Procedure). There is also an Exit button on the form.  The existence of the
Event Procedure prevents access to the Exit button.