Within a recordset each record has data within brackets e.g. (12345)
How can I delete the contents and the brackets? The string "(12345)"
can be both in the middle or the end of the total field string.
Thanks

On a single form I have five Cmd buttons each with a controlTip text.
When the mouse first hovers over the first button it takes approx
1-1/2 seconds to have the text show up. After the initial 1-1/2 second
wait period you can move the mouse around all five buttons with

What is the correct syntax to reference the tab control in access 97 on my
form? I have tried:
Dim i As Integer
 i = Forms![Myform]!TabControl.Value

I have a Continuous Form with two Combo Boxes at the Top:
Combo112 & Combo148
Both Combos work fine to Filter the data based on their Drop-Down value, but
I need to Filter the data based on the results of both Filters:

I wanted to know how compatible Excel codes are in Access. I have an excel
worksheet that calculates units of measurement  ie: SqFt, BdFt, LinFt..
I just wanted to know if I can use the same principles in Access that gave
me the results in Excel.

I have one button that is an Update button, meaning that when I click
this button the text boxes come available (through enabled) to input
data into. Upon clicking the update button there are two buttons that
I have that I would like to come available as well, save and delete.

I have a combo box in a form called "type of sale" (retail, finance,
wholesale), and 2 fileds called "cash down" & "finance fee" .
I need the "cash down" & "finance fee" fields to turn yellow if the combo
box "type of sale" has been select to "finance" .

I need to select from two table in this SQL statement.  How can this be
accomplished?
DoCmd.SetWarnings False
VDSQL = "INSERT INTO tblVoidDetails " & _

In Access 2000, I am trying to set the value (True or false) to a check box
in code.
me.chkDeptManager=True
I get the message "You can't assign a value to this object"

I have an auction database that I built for the March of Dimes(with the help
of many people from this forum and thank you for that). It works fine except
for one thing, how can I set it up to except a minimum bid? In otherwords, If
the starting price is $5.00 a person HAS to bid ...

I have an order-database with a form based on an product-table for
registration and updating of the products.
When I receive an invoice, the prizes are sometimes incl VAT and sometimes
ex VAT. In my products table I've a field for both of those values.

I have a report that needs to print a detail line item from an unbound
control.
I read a database to populate this unbound control (see code below). However,
the problems that I'm having is that the vba code works correct meaning that

I'm changing my Combo's (cboToDate) Row Source using code in another combo
(cboFromDate) but although cboFromDate's After Update code includes the line
Me.cboToDate.Requery,
cboToDate will still show the data it had in it, before I used cboFromDate

I have a number of date and currecy fields in a subform.
If the textbox field value get too big to fit into the space,  the field
displays ###'s.
How do I stop these ###'s from appearing without increasing the textbox width?

Will the following code just remove the newly created QueryDef "qryLHFull"
or will it also delete the data from the original qry "qryLHVol" itself?
Private Sub Report_Close()
Dim dbMyDB As Database, qdMyQuery As QueryDef