My company's backend is located at a location with a long address,
something like -
//our_servers/server_number_one/our_department/our_devision/
our_results/our_databases/backend.be

i'm new to VBA and i need to Build a Dailog form that will enble me to
import .csv or .xls
files to access. anybody directs me where can i find already built
form on line  OR what functions or method to use

I have a form with several comboboxes whose contents I'm trying to
initialize from a table. The table, ComboSelections, has 3 fields,
an autonumber ID and two text fields, ListCode and ListEntry. ListCode
contains the actual names of the comboboxes, each of which has several

we have 2 Access Applications.  One is in Access 97, the other in
2000.
With Access 97 I was able to replace a module that contains an old web
address using docmd.TransferDatabase.

I am relatively new to Microsoft Access and databases in general, and
have a problem - one which I think may necessitate some VBA code (or
maybe just modification of the criteria section of the query.
I have a table with several columns being imported into a query which

We have a tool built for determing which Access version an mdb is that
works nicely.  Problem is, hundreds of PC's here are getting reimaged
without it(!)
Since I've been unable to solve that problem, am quite interested in

I am trying to create a form that shows quote info, but also has a
subform that lists all keywords and allows you to select multiple
keywords to associate with that quote. I have never done a subform
before and am struggling a little with it as there is an element of

I have this query that when run on Access 2007 works, when run in
2002
it fails with the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect Syntax near

I can see why this doen't work in a simple query, but I don't know how
to fix it...
I have a table of client transactions, (ACCOUNT_NUMBER, DATE, VALUE)
eg:

I work for a company where I do quality assurance. We get a
spreadsheet every week of the curent employees where I work. What I
need to do is import this spreadsheet every week and update my
tables.

I received an installation program to load an application on my home
computer (WinXP w/ OfficeProXP).
The app was originally built in AccessXP, however is now run on A2003, since
the company upgraded to Office2003 a few months ago.  When I clicked on the

Afternoon
Is it possible to display test alongside the Navigation Buttons in an
MS Access form?
I have a complex form containing a number of subforms where the

I have a form with a sub form, on the continues sub for I want to
display some data along with a picture, on the On Current event I have
the code:
[ImageFrame].Picture = Nz([ImagePath])

Where and how do I declare a variable that I want to use throughout
the entire Access database?
Thanks

Dear reader,
In case a report is a sub report the Report Header of the sub report is
printed in the report but the Page Header of the sub report will not be
printed. This is the same for Page Footer of the sub report.