Recently when I open Access97, I get this message
"Active x control can't create object"
can any body help?
Thanks

how do i ensure that the filter i used in a subform remains the same when
next i open the subform without having to reapply the filter

after i have applied a filter in datasheet view why is it that the drop down
includes values that do not relate to the selection made by the filter what
can i do to restrict the drop down values to only the filter selection

I have a DB I use for tracking records for training employees.  Our training
document numbers have changed, so I added a field in the table with the new
document numbers.  The fields consist of Old number, new number, title &
date.  There is another table with employee names and ...

I want to create a task list with check boxes indicating if a task was done
on a form which displays client information.  I can't seem to get the check
box tied to an individual record so as to indicated if the task was completed
for that particular client.  The check box remains ...

Is there a way to shorten a Control Source's text to something more
manageable if the Source is currently
=iif(iserror([really long formula]),0,[really long formula])
Thanks

I want a query to show only those records based on today's date.  I tried
using =Now() as the criteria, but I get no records even though there is a
record with todays date in the underlying table.  I am stymied!  Is there
other criteria I should be using?

I have a table called computers and in there is a field called location. Any
location can have many computers. So when I created a form to add new
computers the location field listed every location in table(as it should with
the way I set it up), but since many of them are ...

I'm under the impression that this cannot be done, but I'll ask anyway.
When viewing a form in continuous form view, is it possible to change the
backcolor/highlight the detail section of only the record which currently has
the focus?

I have written a conditional expression in a form based on an IIf statement.
How do I now transfer the result of this back into the main data table, so
that I can then run queries on the result of this IIf statement ?

I have two tables one stores computer informaiton, type of computer, etc.
The other one stores different software that can be used on any computer. Any
given computer will have many different software programs on it, and vice
versa. Can I create a form to allow me to select ...

I have designed a form using a JPEG as background which provides an image of
my objects being on a computer console panel.  However, having set it up in
design view with everything in place, looking good...I went to form view to
find that the picture resizes to fit the screen and ...

User wants to view all the records at once in grid mode but be able to edit
if he sees the incorrect data.  The problem is that he doesn't want to enter
the data accidently.  Is there a way to edit the field/record in grid mode
where you have a button to lock or unlock?  I know ...

New Problem: Is there a way to have the expression in the Query Criteria box
search for values in a pull down list in a Combo Box on the query Form?
I.E. say there are four values in the combo box pull down list ( Cat, Dog,
Fish, Bird). If one of those values is selected (Dog) via ...

I would like to be able to select a category from a drop down combo and then
the results for that categolry are shown.
Its not working, I'm pretty new to this.
The category combo box looks up the categories in a query, that shows