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...

Pat, I tried your suggestion but my counts of the option group values aren't accurate. For example For Option Value 1 on May 01/01 displays 2 for CountOfItems yet there is only one record for Option Value 1 on May 01/01.

I will try to clarify things for you. I recently discovered the link between my table and my form. It is called Client.It is a text field on my table and an option group on my form. Now, what I would like to do is create a expression in a query or report that counts one of the values in the...

Pat, I have over 500 records on this form not attached to the table. Can I create new fields on a table to accomodate results of this option group from this non-table linked form? Or can I get a sum of the various values of the option group on the form?

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 looked at the Tools/Reference list in the Switchboard Form Module and couldn't find any Microsoft DAO Library. I found that I did not have any problem with opening other databases on the same PC but, not that particular database. Any suggestions?

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 tried that Marc and now I get a Compile Error message.

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?

uncheck a check box within an option group?

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...