I tried to put some text into the controltip text of the properties of
a command button. I tested it out and nothing happened. I have the
status bar text, but I want the text tip that hovers when I mouse over.
I looked all over and found stuff on putting it in code. Not what I

I get an "Compile error: Can't find project or library"
[DATE]= #" & Format(Me![Combo67], "MM/DD/YY") & "#;"
The word format is highlighted as the problem.  I think the code worked OK
on Access97, but no longer works now I have upgraded to Access 2003.

2 things:
1) there any simple (and I mean REALLY simple cookie cutter) way to
export a TEXT format or HTML format document or report out of a single
ACCESS record?

I'm wondering how to press a button on a form in MS ACCESS and have all
values in  a yes/no field in a table be UNCHECKED?
Thanks
Mia

I wonder if you can help me.
I am creating a loans system for a make-believe CD rental company, in Microsoft
Access.
I have 3 tables: CD details, Member Details, and Loan Details.

I want to "maximise", then fit a report into the available window.
ATM I maximise on the OnOpen event, then use send keys ......
%{v}, %{z}
...to zoom and fit to the window.

Here's one that's going to leave me bald before long -
I have a report (no headers or footers, small detail section) that runs
normally when I open it from the database window.  When I run it from code:
      DoCmd.OpenReport "rpt_Name", acViewPreview

I have a major problem. I use Windows 2000 highest SP and ACCESS 2000 inside
Office 2000 SP-3.
I want to use the following simple command inside ACCESS in VBA
UPDATE tbl_SATURN_Benutzer SET bool_IstDatensatzAktuell = False,

Thinking I know the answer to this before I ask...
Has anyone ever figured out if there's a way (including 3rd party
solutions such as Active-X) to embed a report (or an HTML formatted
doc) as a subform in a form. What I'm after is being able to achieve

I've got a filter form to select customers, products, etc
 and these are used in parameter queries, ie    WHERE t_cuno Like
[Forms]![fmnuMain]![txtCust]
the parameter queries, roll up to a crosstab query, that is used to

I have a code that checks a directory to see if it exists, and then if
it does not, the code creates the directory and allows the user to
add/view files in the directory.  Weekly I print a report containing a
copy of each record entered during that week (we are still no paperless

I use some old fashion program whit DBF files and now i step by step moving thth to acces. Problem occurs when i try to link DBF tables whit MEMO FILED wich  requvest file whit ''name''.ftp extension whic reprezent that memo filed. That kind of DBF file i cant link or import. ...

Ok.  Here's what my table looks like:
                         Field1  Field2  Field3  Field4...
Record1                1          3          2          9
Record2                9          1          9          4

how can i sort events in mdb database in order to display the most
frequently events in database ? (count the occurences of a field)
for example :
28/12/2004 08:18:14    U_D671/FC667

Hi, I need to be pointed in the right direction.  I'm looking for a way
to dynamically change a table in a query.  I have a table called
students and each fiscal year the student table will get rolled to a
new table student2004.  Currently all the reports are based on queries