I'm sure this is simple but am foggy today. I want to convert a string in a
query as follows:
10001 to 1
01000 to 2

Can you install "Analysis Toolpack - VBA" in Access?  I use this in
Excel, and now I'm trying to copy modules over to Access, and it's
giving me trouble with
Dim xlApp As Excel.Application

In my cose i open a recordset called "rsdata" based on a query. In the
original query the data is sorted ascending on a field "Q1Score" which is
fine for the first bit of code. I want to now utilise the same data set but
now sort on field "Q2Score". How do I resort the recordset ...

Is this place like a public notice board?

I am trying another method of viewing pictues, because the database is an
employee database, we use it for licensing.  And I need to give the users the
ability to view the employee picture along with thier information.  I tried a
hyperlink but thats not good, there has to be ...

I am creating my first multi-user app at work. We have multiple
versions of Access within the company from A2000 to A2007. There is
really only one department/location that will be adding or
manipulating data. All the other departments within the company will

What is the best way to design a database for my service business?
Invoices are sent out just once a month and the customers pretty much stays
the same from month to month.  
Each customer has a customer number and each invoice has an invoice number

Does anyone know what causes this error and what it means??
Thanks in advance.  I'm pretty new at this!

Drop down boxes populated by an underlying query work for all users on many
differnt pc's with the exception on one specific pc. Set up and workgroups
appear to be identical, but the drop down boxes are empty when using a
specific machine.

I'm very new at this, and am having a problem with a button on a form to
send an email to the address listed on the record.
The OnClick event code is as follows:
DoCmd.SendObject acSendNoObject, , , Me.Email

Bought new computer. Have two problems with uSoft Works Word Processor:
1) How does one close a document without shutting down the Word Processor
program?
2) How does one retain original formatting of documents written in Windows

Is there any way to create a link in Access to a SQL table without having the
user manually create the DSN using the admin tools?  My hope was they could
access the sql table (view only) without manually creating the DSN.
Thanks for your help.

I have a database that has been running fine for over 5 years and no changes
have been made recently.  However, data seems to be disappearing immediately
after entry, when the person closes the form.  I have noticed that if
information is entered into one particular field (MRN) ...

I've been doing design in Access & VBA for a few years now, and I'm lucky I
don't have to do it to earn a living - but I do enjoy it. Though I'm no
longer a novice, I'm no expert either - which is why I regularly need to
visit these discussions groups when I get stuck.  My most ...

Please advise easiest way to link SQL server table with Access table. - thanks
Aa