In my text box I have locked my fields "Yes" and in my form on "open" the
fields are set to true, I have a command button (Add) I set the fields to
false. When the user press the add button.  When the user goes to the next
record I set the fields "On Current" to true so the user ...

I am experiencing the following problem ONLY whenever I enter a new record on
a form, be it using an "Add Record" type button, or using the record selector.
Regardless of which field I decide to input data into, as soon as I type one
or two characters, the cursor jumps back to the ...

I have a form that contains a list box (list of companies). When you click
on a company a form that has 2 subforms opens. The main form is the
corporations. The first subform has the sites pertaining to the corporation
and the second has the types pertaining to the sites. There ...

I have seven fields in a record to record hours.  Each field is defined as a
Date/Time field with a Format of Short Date with the Mask of a short date.
I want to add these seven field together to get the total time for the day.  
(The reason I do not have a seperate record for each ...

I hope this is the appropriate group for my question.  If not please let me
know.
I have the following statements to display a message to the user:
   User_message_2 = "1) All Tables will be transferred"

I am using VBA to create about 150 command buttons on a page with click
events. Each buttton is named cmd*, where * is a row and column number,
like cmdA1. I wanted a quick way to delete the buttons from the Detail
Section during testing. I am using the following code. I have ...

Using a form to import data for two related tables I had set the “Required”
property of the tables’ fields to “yes” in order to force the user to put
data in every field and avoid the known problems coming from Nulls.
Later on when I decided to use the Not In List event to prompt ...

Is there a way to have a msgbox automatically close after a pause?  I need to
display it for about 15 seconds then disappear.

I have created a form and am using a command button with code which will
export all data to an excel spreadsheet and format the spreadsheet how I
want i.e. autofilter etc.
Is it possible to add some code to also format certain cells within a range

I have two tables named Customers and Contracts related with a one-to-many
relation.
When I delete a contract record I want the relevant customer’s record to
remain if the certain customer has other contracts. However if the certain

I have a form with a checkbox control and a text field.  If the checkbox
control is not checked then I want the text field disabled (enabled = false).
This is being done in the form_current event.  It works fine in form view,
since in moving between records in form view the focus ...

I'm having a problem with resorting a listbox. I have a  combo-box where I
want my users to select come choices to sort by: eg: "Supplier Name", "Data
Souce" etc.
When the form is first loaded it is sorted by "Supplier Name"

I have a form in which I created a command button. When I click on this
command button, I want it to open a query, which I have done. This query has
an employeeID field and a name field. When I select the row in which I want,
I would like the EmployeeID information from the query ...

I have a front-end database that in addition to traditional database
processing I also allow the user to open a number of external application
documents: Excel, Windows Journal (Tablet PC), etc.  My question is what is
the best way to prevent the user from changing the original ...

I need to automatically save a running total in subform into a record in its
parent form without the user pressing an update button/code.
I have code for the update button that updates the parent record just fine.
me.Total =nz(POItemSubform.Form!SumofCost)