a textbox contains numbers and characters
.... how can I only extract the numbers from that field for some
calculations ?
thanks,

I've used the combo box wizard to create a combo box that looks up records.
It's after_update event code looks like this:
Private Sub Combo16_AfterUpdate()
   ' Find the record that matches the control.

Hi I need to delete all records from a table in my
database.  I have a button on a table maintenance  form
which I would like to run the code from.  Only data
should be removed.

If I have an application that can have multiple Forms open at the same time
& even Report Viewing Windows, how can I automatically activate (or set the
Focus to) different Forms through VBA coding ?
I know there is ControlName.SetFocus but you cant do that with a Form.  How

I have a database that sits on SQL Server 2000 and users are restricted on
what actions they can perform on the objects.  Via ODBC I have an Access
database for the forms, reports etc.
One of the forms uses a subform and here is the problem.  The underlying

I was wondering what the syntax is for setting the controlsource of a report
based on the values from a form.
I have a form which has recordset, but i want it do it for a report as well,
but a report doensn't have a recordset property.

We have an application that pretty much requries a large screen (1024x768)
to view the entire app without using scroll bars. One of our users is
complaining because he uses 800x600 and does not like to have to scroll. I
don;t supposed there is anything out there that would allow us ...

I have tried error trapping a field, whereby if the value of [field2] does
not match [field1] then it should exit sub and stay there for correction.
It (A2K) don't want to do that, and currently I am having to use the
'gotFocus' event of the next field [field3] to force it back to ...

I have a complex query that takes about 7 to 10 minutes to run as a result of
a "Like" expression over a network. I would like to run this query early in
the morning when the staff are not yet at work and after an auto update of
imported data. So far what I can figure out is I ...

I have a form that just displays information about an underlying table.  The
Edit/Add/Delete records properties are all set to NO because I don't want
users changing the information shown on the form.  I do, however, have a
button on the form that I want to change the underlying ...

I am trying to center form on the Access application window. For this task I
use a function, which I copy from one Access's book. But suddenly I found
that my form is not on the center of application window, it's closer to the
bottom that to the top of the window. As I see in the ...

I want to create a matrix from information in access.
We have several packing rooms, each room can only pack certain stuff.
          RM1         RM2          RM3
PROD

After you have developed and tested a new set of features in a copy of a
database, what is your solution for migrating those changes from the copy to
the released database?  I can have single-user access to the database after
normal business hours, so the changes do not have to ...

I have made a simple combo box, based on one field in a table (category)
the sql for row source brings up the correct data, the row source shows the
correct data, but nothing happens when I click on anything in the row source.
What is causing this and how can I fix it?

I need the syntax for programming the navigation button off and on, when form
is open.
What event would I place this on.  On Open or On Load?
Thank You