Does someone have some sample code on how to launch a new instance of IE and
write text to it directly from code in a form using something like OLE.
I can write the text to a file and then launch a new instance of IE and have
IE open that file without an issue but I would like ...

I have adapted code found elsewhere,, to search through a collection of files
and return the complete line of text where the search string is found. The
files I am searching through are html files and the line returned contains
all the control characters as the file is opened as ...

I have a form on which is a subform, during adding a record to the subform a
number of data checks are made, in one extreme scenario I wish to warn the
user they can't continue (easy with a Message Box) and then delete the
record they are trying to add.

I remember using some code to send SMTP mail using VBA. I don't want to send
it thru Outlook or Lotus Notes. Can you refresh my memory on the code I use
to send SMTP mail?

There is a text box in a form that user can enter the value.
How can I check if the value entered by user is already existed in the linked
table or not?
If the value (or record) do not exist, that new value/record will be added to

How would I go about setting a list box rowsource to equal that of the
rowsource, including a filtered rowsource?

I am trying to link two combo boxes (Divisions) and (Objectives).  Can
someone please give me step-by-steps instructions.  
I tried to follow the instruction at the datapigtechnologies.com website, but
I was confused.

I have a form that pull in data from one table that i want to put into
another table when a submit button is pressed.
IE: i run a qry that pulls in customer name, i then fill out the rest of the
form and click submit. all the data should then be written to another table

My database has a date field; 'Birthdate.'
I have added another field to the table; 'Birthmonth.'
I want a user to be able to order the table view for browsing by month.
How do I get the Month from the 'Birthdate' field to automatically enter the

Used LIST BOX to search a table of surnames to find a record. Works as
expected until you have a surname which includes an apostrophe, eg O'Dwyer
when you get runtime error 3077 syntex error (missing operator) in
expression. Code was generated by the Wizard.

My application has a form to enter various information about drafting files,
including a field to enter hyperlinks to .pdf files.
My problem is that my end users have no idea at all how to enter a proper
path.

I have a booking form with date fields in it.  Typing in the month and day
triggers auto-complete for the current year, which is fine if the date really
is for the current year.  I'd like to customize this so that if the month/day
is less than the current date, it will ...

I'm experiencing a database close-down whenever I execute a preview and print
button. Upon execution a dialog box pops up: "MS Access has encountered a
problem and must be closed."
I've reviewed the preview button code and don't see any problems. Does

I have an Access frontend linked to a SQL tables.  
We are running a Windows NT 4.0 Server.
Recently updated from SQL 7 sp 3 to SQL 2000 sp3.  
I'm having problems with one form/table.  The form takes Order ond Lot

I'm in the design phase of a DB project, and want to create auto-numbered
keyfields, but I want each "primary" table to have its own "prefix" to the
auto-numbered field.  E.g. Vendor would be VN as the "prefix" and then an
auto-numbered numeric field as the "auto-number" field.  ...