Search results

I am trying to create a pivot table form with in MS Access 97 but, I get the following error message: "An error occurred while trying to use the Microsoft Excel Pivot Wizard. Microsoft Excel returned the following error 'Problems obtaining data'" As a result the pivot table form is not...

I have created a database that has an option group with five check boxes in a form that is not linked to a table. I would like to do a count on 1 of those check boxes(eg. Check 1)in a query or report. I am having trouble creating an expression for the count since my option group and check...

I am receiving a Run Time Error '429' when I acitvate a newly created database. It is a multiuser database that only displays this Run Time error for one user. I checked the coding design screen and under Tools/References, I noticed a missing Microsoft DAO 3.51 Object Library missing...

I have created a multi-user database and one of the users is getting, upon activation, a Run Time Error'429' message stating "Active X component can't create object." When I press debug, Set dbs = Current Db() is highlighted in the Private Sub Fill Options() Procedure. I checked the...

I have created a multi-user database and one of the users is getting, upon activation, a Run Time Error'429' message stating "Active X component can't create object." When I press debug, Set dbs = Current Db() is highlighted in the Private Sub Fill Options() Procedure. I checked the...

I have created a multi-user database and one of the users is getting, upon activation, a Run Time Error'429' message stating "Active X component can't create object." When I press debug, Set dbs = Current Db() is highlighted in the Private Sub Fill Options() Procedure. Can anyone help?

How do I uncheck a Yes/No check box?

I can't get the auto expand component to work in a combo box on a form that I have created. Yet, the auto expand component works for the other combo boxes on my form. Can anyone help?

I am trying to develop a 2D bar graph in a query based report based on a field(program) in the group header and 3 calculated fields in the details section of the report(Expr1, Expr2 and Expr3). The graph is placed in the report footer. There is a report parameter created from the query that...