I was wondering if there is a way to enter the full path and file name of a
document (.pdf, .doc, or whatever) into a text box, and have a button that
will open that document when you click it (the button's command is linked to
the content of the text box). I thought I saw ...

Hello to all, just having an issue with a report.  Basically I have created a
form that has a command button that calls for a make table query first then
pulls the data from the new table into the report.  One field within the
report is coming up incorrect.  This is what the card ...

The size of my dbase is getting very large, there use to be a way to compress
access, I can't find it in Access 2007.

I have a form, a sub form, and a sub sub form. After choosing combo box
fields, the sub form gets filled with certain records from my table, after
choosing more combo box fields on my subform, my sub sub form gets filled
with certain records from my table.

I posted this 2 days ago in the m.p.v.database group and checking this
morning realized I was the last one to post there. So... if I hope to
get a response I think I need to post here as well.
I have a user of a very simple Access database that has been running

I use Access DB, I created a template database for my employees to use.-which
is perfectly fine. But when I try to copy it to a CD (Sales Manaul) it
becomes a read only file.
How do I avoid this and end up with a fully usable DB as a template copy?

How do I create a query in access to determine if a table is used in other
queries?

I need to fill an array with 1, 2, or 3 search values, depending on whether
the 3 search fields in the form have a value. So if searchfields 2 and 3
have a value I should have an array of 2 values. If only search field 1 has
a value, the array should only have 1 value, etc. I ...

When I open an existing database and open a file, it says" the changes you
requested to the table were not successfully because they would create
duplicate value in the index, primary key...." Could you please tell me
what's wrong? and how to fix it?

Hey everyone...
I have queries set up to get the data that I need.  They are Parameter
queries and I have a form set up to collect the Parameters (in this
case StartDate and EndDate).

I need to have result be "Yes" "No" or "PIF"
Cell BE2 = Due Date
Cell BJ1 = Today's Date
Cell BG2 = "." (or can contain a date when paid)

My system is XP SP2
Internet Explorer 6, and in OutLook Express i have this error message"
impossible extract message N° 38. Compte: "pop.mail.yahoo.fr ERR problem
retreiving message Port 110 error N°0x800420CD, browser error N° 0x800CC90"

Is there a way to get the password of the currently logged in user?
Thanks
Regards

I am geeting a -- Syntax error in query expression '850_Gain_dBi' -- error on
this line of code:
Me.txt_HBW_A_EC = DLookup("850_Horiz_BW", "qry_AntennaTable", "Ant_Model ='"
& Me.cmbAnt_A_EC & "'" & "And" & MyPos > 0)

I have the following line of code that will not work and I can't for the
life of me work out why.
Forms!searchform!List12.RowSource = "SELECT MemberData.Surname,
MemberData.FirstName, MemberData.Code FROM MemberData WHERE