I have a list box on a form that is populated from a look up table. I have
typed in the data into the look up form in a specific order but the data gets
automatically sorted to an alphabetical list. How can I prevent this from
happening? Thanks. Steve

Hello, first poster.  My question is this:
I am working on a cemetery database, I have only one table and one form at
this point.  On my form, I want to auto-increment the number in the Grave
field based on the number in the Row field.  

I am a novice user, so please be gentle with your responses.
I have created a form for data entry into a table.  One of the table fields
is the amount of days that a claim has been open for.  I have inserted a
DateDiff function in the default value field in the properties of the ...

I am struggling to make the data I have collected in my text boxes appear in
a list box that is linked to a temporary table.  The Idea is to write each
set of text boxes as a record to be added to the listbox (called Display) and
to the table called tblTempTable.  Can anyone help?

I am tryin to send a gif file 'to the back' and put a com mand button 'at the
front' and set to transparent so that i only see the gif file
but when i click on it, the command related to the command button is to be
run.

I am sure there is a quick answer (I hope), but I am boggling my min
trying to figure it out. I have a form with a drop down box tha
pulls values from a table (tblInfraction). The selection from tha
table updates to another table (tblMain). At first this would be fin

Private Sub Ship_to_Click()
On Error GoTo Err_Ship_to_Click
   Dim stDocName As String
   Dim stLinkCriteria As String

Can an event procedure be written in perhaps the "On Enter" or "On Got Focus"
property that would open a combo box upon entry into a field in a subform,
then close it when a selection is made?  If not, is there a key that can be
pressed that would open it?  I have some users who ...

I know this may be simple for most, but I am not that knowledgable about
doing this.  I have a website with an Access 2000 DB.  I have built the
tables to collect all the data I need and I am having someone else build the
forms.  I want to be able to open the DB on the web server ...

I've asked this question before and got the right answer on how to set the
AllowAdditions property to "no". It greys out the go to end of file
navigation button and that's exactly what I want.
Now I've built a pop up. When I open the form on its own, the EOF nav button

I have a multi tab subform.  One tab, which is named "Bid Subform" has a
control, "CostTotal", which I wish to be a calculated total of a control,
"LineTotalCost", which is on another tab/subform named "BidLineItem
subform2".  I have tried 2 expressions in the control source ...

I understand that using the Image control, storing the image path in a text
field, and loading the image at runtime is superior (spacewise) to using an
object frame bound to an OLE field, but I have two questions:
1. Since, in my application, it is up to the user to import an ...

I have created a form (Main details) with 5 subforms (Visit1,
Visit2....Visit5). The subforms are only visible one at a time (5 tabs).
Subform Visit1 has a field (Date of visit) which is used to calculate
scheduled future date of visits in 4 other subforms(V2.....V5). I have

How do I check yes in yes/no box for filtered records?  I filter records in a
form and when I am done I would like to check yes for each record in the
current set of filtered records.  
I normally start with 7,000 records and then filter down to 400 depending on

I have a form that temporarily copies its value to a second field on a form
until it is later changed.  The following code is place in the AfterUpdate of
Field1.
Me.field2.value = me.field1.value