All of the examples that I have seen on hoe to use ADO/or ADOX seem to be
using an external ODBC driver (provider) or external MDB file.
Can anyone direct me to an example of how to use ADO or ADOX to access a
local table contained in the current project (MDB)?

fm_Main
 txtFind
 fs_SubForm (Datasheet - not linked to main form)
   Displays a list of Australian Postal Codes, States & Localities (Suburbs)

I have a field field 'Daily Acitvity' in which the data is like this,
"Completion of punch list.Radiography of the modified joints.Review of valve
data sheet.Construction coordinattion is ongoing."....
I am making report in which i am trying to display each sentence in seperate

I've got a calender (calender control 8.0) on my form.   But the date on it
doesn't change.  It stays at the date when i putted it on my form.
How can i make it so that everytime i open this form, the calender begins at
the current day.

I was wondering if there is a way to send a certain page of a form instead of
the whole thing.
Donbenz

When am surfing the internet or even when I am reading my messages, and tries
to open a link, the other window apears to be opening but it never does.
What can I do to resolve that problem?

I'd like to know how I can send the value of the content (control Source?) of
a
form's text box control to the Printer (w/o using .Net functions).
Assume:

I have entered my e-mail addresses (About 1600)  into my DB, using the
"Hyperlink" datatype. Now all the e-mails come up as web page hyperlinks
rather than e-mail. I tried changing the datatype to text, this didn't work.
I can edit each hyperlink individually changing it from a ...

I am looking to have a user click a button on a form which then adds an
autonumbering field with name ID and type "AutoNumber." I know how to add a
row (that is, a new record) to  table using visual basic, but I would
appreciate any knowlege about how to add an entirely new ...

Hi all ... I have an A2K question / issue regarding requerying the data
behind a BOUND combo box.
User "A" enters something into the input area of the combo box control, but
this change is not yet saved (remember this control is bound).  Then Users

Does anyone know how to hide access in the system tray

I am sending a report to an RTF file and then using the "mailenvelope.item"
in WORD to place the formatted report in the message body of an email so it
can be easily read on a Blackberry.
I use the following line:

Do you know when you access the Properties pages of a table, query, form, etc... , you can enter a description.
Can I read/write this description programmatically?
I want to use this description as a test to decide if the query gets exported to another DB but I can't figure out how ...

I have a criteria form and a main form. in the criteria form, I created  a
button to correct all criteria and build a where statement. then I use
openform with where statement to open my main form. I got " you can't go to
this specific record." I have no idea how to look into ...

In VBA, I'm exporting data from Access to Excel and then open the xls. I use
the following code:
  DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, Myqry,
test.xls