I'm kind of new to this so please forgive, if I'm asking a somewhat basic
question. I have a supplier database that I'm trying to setup. I thought it
would be really keen to set it up so that when you entered the country it
would automatically list the international calling code ...

Is there a way to click on a command button and set the value for all
records in a particular set to another value?
Thanks
DS

Hi everyone! First post, so please bear with me! Thanks in advance for your
help.
I have been creating a database in Access 2000, and had just completed the
finishing touches. I sorted out the startup options, so that screen X was

I have two tables..
Both have field names (AccountDescription, Amount, WTAX, InputTAX, NetofVAT,
StatementCode)
The Statement Code is either a BS or P&L.

My lookup table is sorted alphabetically when I look at it alone, but when
it is displayed within the combo box of the the column that is using it as a
lookup, the order seems random.  How can I get it to show alphabetically
within the combo box?

I was told I need Microsoft Access to use this program. I have it, but I
haven't been able to "figure it out". The help page hasn't been of much use,
or I just flat don't know how to use it. The CD of course is "read only" and
I need to make changes. And, where do I put it? On ...

I am really FRUSTRATED and I hope someone can shed some light.  I am using
digits of my own choosing for "CUSTNUM" field -- the primary key for this
table.  I assigned a text data type to the field, as I do not intend to
perform any math on the entries in this field.  When I go ...

I have a field that contains email addresses.  I would like to send everyone
a mass email.  How do I get all the address to Outlook in a msg.  Or, I will
be happy if I am able to click on each one and have outlook open in a blank
msg, like a hyper link.  

the last few days i receive the  following error
Microsoft Visual Basic
run-time error '-2147221164 (80040154)'
class not registerd

I am working on exporting information from another system. One of the
queries I need to write includes data from 15 months prior to present date.
How do I write this in SQL to only include information no older than 15
months?

I've written a macro to export a table to Excel format, and then email it.
When it is opened in Excel, 'Wrap text' is automatically set to ON, which
means the information does not display as it should.
As a result, I've tried TransferSpreadsheet - which works fine, but I don't

I have a "value list" value that can be null, accept or reject but I can't
get it to show up as anything more than a black box on a report... any ideas?

Using VBA how can i change a text field to a currencdy field type
Thank,

i need help with a formula please.
i have a list of user names in my table, for example
bills
henryp

I'm trying to set up a simple database in Access 2000 that allows me to
record and list bird observations.  I have two tables.  The first table is of
bird names, and has bird names and a four-digit bird name code (so I don't
have to write out yellow-bellied sapsucker everytime I ...