Hi I hope soemone can help. I want to insert a hyperlink into a table field
using VBA Code. I also want the display name to be different form the
hyperlink address.
Cheers

I have a query that pulls up names of individuals that I would like to send
email to.  However I cant get the SendObject macro or anything else to
recognize more than one name.  Does anyone know a way in which a text box can
show more than one record and separate by a semicolon?  ...

I have a question about how to addItem in List box (Access) using VBA.
I have one combo box and one list box. The values in the list box will
change when the value in combo box changes.
I try the code below:

I am importing a spreadsheet and I need to make one of the fields indexed for
later lookup. Here is my programming to run the process which ends with me
having a new table called "tblMatchingBudgetRpt". My CREATE INDEX statement
causes an error.  

Is there a way to hide a table using VBA. I know about
Application.SetHiddenAttribute, but the table can still be made visible by
Tools Menu>Options, View tab and selecting to display hidden objects.
Or, is there a way to disable the Options item on the Tools menu?

I am trying to add comments or hidden text, is that possible?
Maged

I wrote some code to loop through a recordset and create an output file from
the data returned from a query. This works fine if I hard code the
parameters in the query, but I need a way to prompt for the input
parameters. I'm not sure how to do it. Given the following code, I'd ...

Can somebody please tell me how to handle nulls with class objects ? Here is
a brief description.
Code behind a Form (btn):
     With Customer

Dear All
I need your help to calculate an interest amount for the account payable by
customer.
I have a table containing the following fields:

I am using dir() with arguments for the directory and folder from input boxes.
Dir(directory & ":\" & filefolder & "\*.*")  I am then placing this in a
table, if this document is not in the table as yet.
I would like to use an input box for the directory, but have it search

I have a form with a command button.  When this button is clicked it runs
code that will run a query and open up a report, call up the print command so
that I can print pdfs, then closes that report out, and then cycles to the
next report for the same actions.  On 4 of the ...

Newby question: I want to load the complete results of a query into an array
using the GetRows method:
Set myArray = mySQL.GetRows(myNumrows)
In the simplest instance, mySQL = "SELECT * FROM MyTable".

Using Office 2003 and Windows XP;
I'm thinking about using either Wordpad or Notepad for long-ish text data
and then either store the documents as OLE objects inside the DB or hyperlink
to separate files. The text files will contain some formatting, but only very

I have an Access databases that contains linked SQL tables.  There are 140
linked tables.  
Is there a way to have a macro to turn all the linked tables to the local
tables (both structure and data)?

I've been given a database to manage and update....but one of the forms i
have moved to the new database, a rudimentary search form doesn't seem to
work properly. Its a simple form with first name surname and address unbound
text fields etc...that the user populates and clicks a ...