I use docmd.transfertext to allow users to archive (and optionally
restore) rows from several related tables - e.g., ticket hdrs/line
items/detailnotes/ etc. They click a button, select an archive text file
to re-import from, and the code implements it with docmd.transfertext -

I have a MS-Access 97 and IIS installed on my Win 2000 server. I have an
Analysis Software which analysis the composition of the clinker and other raw
material that are used in our company. I wanted some reports out of the data
that the analysis software database so i made a new ...

I have made one .mdb file, later converted to .mde. Now I
want to give to a user who have no Microsoft Access
installed on his computer.
After reading on books and web page I came to know, that

Friends,
I need to do some Access package and deployments.  However, I'm not sure
what tool I need to do that and if I already have it (or access to it via my
various Microsoft subscriptions).

I have2a tables:
table 1 with some client operations, with the following information:
start_date; maturity_date; rate; amount;Client_number.
table 2: historical market rates (since 2003) for the 1M, 3M, 6M upt to

I am a student,but i don't konw what's this.are you can introduce this .

HI Quick Question. I have a runtime app that has a form with some columns
that users want to right click and sort a-Z etc.  
It works in the mdb version but not in the mde version.
Any reason why?  How do I get this functionality back in for my users?

Am suddenly unable to see a query in design view.  The query will run without
any visable errors.  Have tried re-boot, DB repair, importing fresh copy of
query from another system.  Same failure.  Nothing in XP Admin. logs.  Other
queries display without problems.

Is there any way to automaticaly set the height of listbox to it listcount.
Like at combo box I can do like this
cmb.listrows = cmb.listcount,  but how to do it with listbox?
Any help would be really appreciated

I am attempting to convert the color code that Access stores for form
controls to a hexadecimal value for a web page.  I can do it with the RGB
colors but not with the single color code saved by access. I assume that I
can convert this color code somehow, but I have been unable to ...

Hi, I am in the process of taking my
European Computer Driving Licence exam and I need the
programmes ACCESS,POWERPOINT and Word,but confused about
were to go firstly,then which one do i download becos all

I've written an Access  database using XP, but converting it to 2000 so my
collegues can use it on older MS versions, and while i want users to add data
to it I don't want them accessing Forms, Queries and reports in Design View.
I've secured the main switchboard by creating a ...

I would like to return the string value of the location (directory) for the
current *.mdb file within a file.  Is there a constant that is this value?
Leonard_Rookie_Coder

Ok, so I have my database ready to package up - almost.  I have gone through
the steps in article ID 289885 on how to protect my Acces DB.
I finally get to a point where I think it is ready but the instant I attmept
to run a macro that opens a word document, I get the following ...

I am attempting to package an application that exports data to a new word doc
based on a custom template.  
The application works appropriately on my machine as an access db running in
tandem with Word.  When I install the setup package of this DB, I am gettin