In an Access query I am trying to sort on a text field containing
strings like mx1, mx2, ... mx9, mx10, mx11, ...
What I get is a sort like: mx1, mx10, mx11, ... etc. It seems I need
to convert these to numeric but I have tried cInt and a number of

Although someone (ken?) responded to this question, I am unable to find the
reply...
Hi, Ken,
I should have mentioned that I went with your suggestion of using the

I have a Lookup Box on a Form that looks up specific numbers (No Duplicates
allowed) and an After Update Event Procedure to alert the user if they try to
duplicate the number.
This number can be deleted as required.  The problem is if someone

To Ken and others who can help...
I tried to follow Ken's instructions (reprinted below) very carefully but I
did not get them to work for me.  
Here's what I did:

I didn't even set up my security protocols, and some how I have a dialog box
prompting me for my password.  It has a name and password box, but I never
set up a login with my name on it, but there it is?  How does this happen?  
I'm locked out of Access all together.  What the ...

I need to be able to keep a database in Excel, but link it to Access.  I have
done this, and everything is fine except in the zip code field and some phone
numbers.  In my Excel spreadsheet the zip code field is formatted as
special/zip code+4.  Most of these show up on the ...

I now have Access 2007, and cannot scroll fast through records in a form
like I could in Access 2000. Is there a way to turn something on, so I don't
go one record at a time? I have to scan one record at a time to get from
record 1 say to 350. DB has over 500 records. Why did ...

I have an After update Event procedure as follows:
Private Sub Envelope_Number_AfterUpdate()
If DCount("*", "[Main Table]", "[Envelope Number]=" & Me.Envelope_Number) >
0 Then

I need to be able to add multiple names to a field on a form from a list box.  
I have a form that records training sessions, and I need to be able to add
multiple names of people at a session to the name field, this is selected
from a list box.

Hi I am fairly new to Access. I see code posted for various functions but
have no idea how to use this. Does anyone know of any simple guidance which
would explain the procedure for me?

Access newbie. Win Xp. Access 2003.
I need to open two tables side by side to compare them but the tables
reside in two different access databases. Is it possible to do it
without linking or importing one table into the other db.

I need to enter a date but it will be year,month,day ex: 07/06/26.  How do I
put this in the input mask?  Thanks in advance.

Does anyone have a list of the default idMso values for the default Ribbon
tabs?  All of the examples I've seen reference "TabHome" and "TabCreate", but
I haven't been able to find the idMso names for the other tabs, ie. "External
Data", "Database Tools", and "Datasheet".

Hii guys this is my first post here , first of all Thank you for reading this
message and even more is you can help me with this issue .
I am trying to do a querue from various tables and need to include a
computed field which will work like the if command in Excel ie

We have about 70 users on the DB and about 8 of them can not run a command to
print a report.  They get the message "The Microsoft Jet Database egnine
could not find the object*. Make sure the objects exists and that you spell
its name and the path correctly."  I know that it is ...