I have several complicated queries that I want to export to Excel.  My
business never tends to do the things straightforward, and asks for all kinds
of crazy requests like the following (assume that a "portfolio" is a subset
of a "business"):

I need a code that will activate a form or report i have already created
when the database is opened. Any help please?

I'm trying to use the Copies property to print multiple copies of a report.  
I've tried the following:
In a dialog box for opening the report:
Application.Printer.Copies = 2

hi, everyone
id like to return the name and such of all fields in a query.
ive researched the adox.command properties and have not found any help
can anybody help me with this one?

From within Access environment, I want to search and replace in Excel. I have
a database exported to excel, and want after exporting to replace some
characters.
This gives error message...what to use?

I have a program that simply does checks on records in a table and the
reports its findings.  Unfortunatly I can't get started because I get runtime
error 3078 saying the jet engine can't find the table.  I have tried several
tables just to check but I get the same error no ...

Hi, I have a question.
I want to use ACCESS vba to get the ip address of a PC, how can this be done ?
thanks a lot !!!

hi eveyone
i have a RTF2 control on a form and one on a report
if i fill the reports' control with this syntax in the bottom sections'
format event:

Dear gurus, need your help for a crucial case…
I have developed a database about vehicles in a friends’ computer.  After
completing the database I try it on my PC (I need to modify it – a lot of
modifications) and I get the following message (when I click on a command

With my command DoCmd.ShowToolbar "Toolbar1", acToolbarYes i make my
           toolbar Toolbar1 visible.I want at the same time make all other
           toolbars on the screen invisible,regardless how they are
           called.Sometimes i have

I am using the following code(partof) to select date from the forms:
SQLStr = "Select * from tbllog where [tbllog].[Adate]=#" &
Format([Forms]!frmSamplingSchedule!SelectADate, "dd/mm/yyyy") & " # "
   rst.Open SQLStr

I've inherited an access database and it automatically imports excel
spreadsheets and convert them it to access tables.  I can't figure out how
this
is done, is there VB code that accomplishes this?  I've tried to identify the

I have a feild of data that I need to parse. It is formated as follows: (This
comes from an external data souce this is how I get the data).
SHIP DATE B 6/5/06
I want to seperate it into 3 seperate feilds.

Hi, I have saved a bunch of Query Table sql files. I want to use VBA to open
these files to retreive the command text.
Any ideas or suggestions appreciated :-)

I have a function that finds a customer.When the customer does not exist, i
get the error not a valid bookmark.
Can you help me with my function ? Is there something wrong with it ? Can i
improve it and make it more stable ?