Hi I have a combo and it keeps on putting the data on two
lines I have made its width bigger but it still does it.  
How do I make sure it doesnt do this?
Thanks

I have a subform that has some locked text boxes that are used to display
calculated values...  The text boxes themselves are formatted as "Currency"
with two decimal places...
If the user clicks into the text box (even though it is locked) all of a

How do I code to automatically add an empty row to the db
in a specified table.
It would be great if you can
Many Thanks

I'm trying to parse a number out of a size field.  The data in the
field is ## x ## x ##.  There could be different lengths of numbers, so
I'm trying to use the Mid with the Instr method.
Here's my code:

How do I delete all rows in a table through code?
Sue

The following function works:
=DCount("[ActionCode]","qryrptTrackingReport","[ActionCode] In (2,4,6) AND
[FollowUp_Date] between Date() and Date() + 7").
However, the following does not work I get (#Error):

I have a query that returns the result of a last name that is typed into an
unbound text box.
instead of typing the entire last name, ie "Smith" i want to type S, then m,
then i

I have set up an Access query (which works) which I want to include in my
form code.
The query SQl is
SELECT Sum(EquipmentDetail.UnitPrice) AS PackPrice

I am working on a new Access 2000 application. I would like to use some
fancier menu's - particular the "hovering" type and the ability to
explode/implode menu's using the "+" and "-" signs...
I am also looking at developing this thing to look more like a web based

I have a combo box control on a form, the form is based on mt table
tblmaintabs and the combobox is called "cmbmaincompany" and the input is
stored in a field "txtcompany" in my table. I have Limit to list set to Yes
and the following code in the On NotinList property of the combo ...

This is easy...I think.  I dbl click on my cboSize and it opens the
size form.  I enter the dimensions and then requery the cbo when
closed.  All that works fine but I want the cbo to be equal to the new
dimensions entered rather than having to pull down and select it.

Can anyone please tell me how to type a symbol into a field (if this is
possible).  I want to put a telephone symbol into a text box.
Thanks in advance
Sandy

Access97
I have several users in our company using an Access front-end mde on a
mix of W2K Pro and XPP OS's. Most work fine.
Only on a couple of the PC's I am striking the dreaded "Error Message:

Hi, I am using ADODB methods to open and read a database.  In doing so, I
frequently get run-time errors that tell me the database is "Locked".  I
would like to add logic before the db open statement (i.e., cnn.open) that
determines if the database is open or locked.  

I have 3 tables
table 1 is the main table that is populated from the main form
table 2 is populated from the sub form attached to the main form and info is
cleared once information has been transfered to table 3