My web page with the hyperlink
http://sbtp00220New/mysampleapp/mymail_Hadeed_02.aspx
fires notifications to users.
How can I use MS Access macros to open the page? The idea

If I create a primary key for a table, in vba I could use the seek command
and it speeds up record search. This I am aware of.
But what is the purpose of creating an index that is not "primary-key"? If I
am not mistaken, I couldn't use the seek command.

Hi. I am wondering if I can automatically put in a SQL
Server Username and Password for my DSN connection? Here
is my senerio.
I have already made a DSN connection to the SQL Server and

i cannt able to send my mail to another person mail ox  ,so i want the wizard
to help me to sending mail  and received mail to  my box
                                                 thanks
                                                   prince

I have created a schema.ini file which accurately describes several text
files and I am looking for a utility someone has already written to simply
import those text files into Microsoft Access tables. Please point to a
utility or write one for me and I will pay you for it. The ...

I have a delimited text file with survey data from multiple courses. I'd like
to set up a macro or create code to import the data easily. I know i can
create a specification file, but the fields in the data file change from time
to time (old fields always remain, but ...

I would like the user to create a custom query, adding some of the tables
available.  I have over 50 tables so I do not want to create a query on all
tables.
Is there any way I can do this using VBA?  I have a little knowledge of VBA

How does one return the literal/name of an intrinsic constant instead of its
byte value?
For example, CurrentProject.AllForms(1).Type returns "2", which means
nothing to me.

Hi, I want to switch to another database. That is, close the current database
and then open another database. The following code doesn't seem to do it...
   Set dbsCheck = DBEngine.Workspaces(0).Databases(0)
   Set dbsOpen = DBEngine.Workspaces(0).OpenDatabase(strOpen)

I created a query in an Access 2000 database to add a new record.  I want to
return the newly added Primary Key (Autonumber) so I can use it as a foriegn
key in another table.  
I've done the following in SQL 2000:

I was wondering if any one might know a quick solution to my problem:
I am trying to set a small system up that users can select any day(s) (i.e.
Mon, Tue, Wed etc) that they want a particular function to occur.  Thier
choice can be 1 or all 7 days for selection.

Good Morning,
Is there a way in VBA to check if a record is currently locked, and if so
display a message to the user with the user name of  who has it locked?
Any help or examples would be appreciated.

Hi - I'm taking over an Access 2000 app.
In any loop where the code adds/edits data to a recordset, it has this:
while...
   .AddNew

I have coded some OWC.Spreadsheet interaction in Office 2002 that is not
compatible with Office 2000.  Does anyone know of a reference where I can see
the different methods or properties to know what I need to change or for what
methods I need to have alternative code?

I would like for a command button on a form to print 2 copies of a report.  I
have figured out a way but it seems like "sloppy" programming.  I have
repeated the command twice:
Dim stDocName As String