Hi Gurus
When I have a query in which I use a small function, e.g.:
SELECT A03_FILES.ID, A03_FILES.D, hasvt([ID]) AS hsvVT
FROM A03_FILES;

I just got paid to solve this problem for one client, so I might be impeding
future business opportunities by sharing this secret, but a rising tide floats
all boats, so...  I've seen this mysterious problem now in many Access C/S
applications.  Usually some random GUI or workflow ...

I have one table called Album
another table called Song
One Album has many songs
I created an Album form that contains a Song Subform.

Using A2K.  I've got a page footer that is displayed only on the last
page of the report.  There is a subreport, text boxes, and a line for
signature in this footer, in that order.  If the subreport has more
than 3 records, the last text box and the signature line get cut off.

When I run the following in my mdb in the afterupdate event of a combo box
it works fine. When the file is made into a mde and the combo is updated
nothing happens. Is the SQL not executing? It seems so. The sub
'subMailOrdRpts' runs properly.

    I am designing a SQL server backend, MS Access (ADP) frontend
application and I came across an interesting problem.
Lets say I have a table T with the following fields(columns)
[a] (int Not Null, Primary key, Identity auto increment)

I have a very general question for old Access hands.
I am familiar with a form's Recordset and RecordsetClone properties. In
what cases do you choose to use one over the other? Are there
situations where it is not safe to use the form's Recordset object

Access 2003, trying to count the number of records that meet a
criteria. According to Help:
"In the Database window, click Queries under Objects, and then click
New on the database window toolbar. Add the table, view, or function

What would be the function to convert date to the number of date
for example, 2/14/05 is 45, becuse this is the 45th day of the year.
What would be the function?
Where can I find info on the web about it?

I set up my code to disable the shift bypass however for certain users
I want to allow them through a button no a form to be able open up the
list of tablies and queries.
Is there a vb command to open up the user interface that lets you view

Is it possible to use windows NT user or (better) usergroup information?
I would like to use it to apply rights in an access application of mine.
If possible (i guess it will be, since it is all one big happe microsoft
family) i'm curious which reference to use and if there is a bit ...

Hi, I am trying to check if a certain form is open and then if it is close
it.  I have searched but can't find an answer.  Any suggestions?
Thanks
Will

I don't know how to begin on a query (SELECT statement) to find all the
tasks assigned to an arbitrary manager (say, staffID='JSmith') and her
organization, that is, assigned to all her underlings, and their underlings,
and ....  For that matter, I don't even know how to find ...

I've got two users needing to look at the same database, but both are
running differnent versions of access.  One is running running Win 98 /
Access 97 and the other is running Win XP / Access 2003.  I've converted the
file to 97 format so both can use it - but is there a better ...

To all:
Hi!  I am trying to use an append queries on a table where the key
field is numeric, formatted as 00-00-000.  The query collects the
information corectly, and there are no records duplicated, but I get a