Search results

I've converted an .mdb to an .accdb and when I try to run the code listed below, I get a "Compile error method or data member not found" with this line of the code. Do rs.Edit So I went to references and tried to load the DAO 3.6 object library. I got a "Name conflicts with existing...

I have a bound object frame that is a control in a report. I have an entry form that contains the bound object frame control. The contents of the frame is 4 pages of text and images that have been copied from a Word document and pasted into the bound object frame on the form. When I print the...

I am trying to format the form header section of a form in access 2007. I select the form header section in design view, choose the auto format button from the arrange menu on the ribbon, and then click on the desired format. Seems pretty simple. However, I don't get the format that's shown in...

I’m having a problem getting the AllowEdits property to work. Here is the issue. I have a form - frmOrders . The forms Form_Current event has the following line of code: AllowEdits = False This works fine and when the user tries to edit a field on the form he is unable to. However, if the...

I have the following 3 access objects frmSignOff , rptSignOff, and qrySignOff. The form FrmSignOff has 2 unbound text boxes and 1 unbound combo box that the user enters search criteria in to populate the query qrySignOff. I want to force the user to enter a control number in the text box...

I have a text box in a report, with it's control source property set to =[BegDt]. Upon loading the report a message box pops up and asks the user for the value of [begDt]. This occurs 3 more times for 3 other parameters. Now I want to change the design of the report so I decided to put these 4...

I want to get the value from FieldA in the previous record of a table and copy it into a new record in the same table, but in a different field named FieldB. I've put this line of code in the declaration section of a module : Global gGetNumber As Double Now in the form that is linked to the...

I have a table (tblStats). The user enters his current weight in a field named Wt. There are 2 other fields in the table named WkLoss and TTDLoss. These two fields are intended to be calculated. What I am trying to do is when the user enters his current weekly weight figure into the Wt field, I...

When I try to create a form using the form wizard a window opens that shows the table/queries that exist in the file.This is fine all the tables and queries appear in this drop down list. However, under this drop down list is another box that is suppose to show the available fields that are in...

Has anyone experienced this problem ? When I add a command button to a form, picture builder brings up a list of available pictures in the system that can be applied to the button. Well the list displayed doesn't have a picture for every action that is available ( yes I have the show all...

Can someone help me with a sub procedure that doesn’t always calculate properly. I have a table named tblRecap that has daily profit and loss figures. A query named qryMonthlySums that totals these daily figures for each month. A form named frmGetReports where the user enters a year for a report...

How can I have a user enter the WHERE criteria in the Set Rs statement below. Set Rs = CurrentDb.OpenRecordset("SELECT [Net] FROM [tblRecap] WHERE [Yr] = 2000 and [Event] = 'lancaster'") I would like a message box to ask the user to define the [Yr] = and [Event] = fields since they would...

I want to place a control in a report footer that will return the highest number of consecutive weeks that a profit was earned. The database has fields named WeekNo and Net. The Net field contains positive values (profit) and negative values (losses). The WeekNo field is an integer from 1 to 52...

I have a Visual Basic problem that generates the following error in a sub-procedure: Run-time error '-2147221164 (80040154)' Class not registered Until recently the sub-procedure use to work on my Windows XP computer running Access 2000. I have a vague hunch that the problem may be related to...

I'm unable to set up a simple filter for a pivot table. Here's what I've done. Created a query that asks the user for the begin date and end date of the search. The pivot table form uses this query as the record source. When I open the pivot table all the records are retrieved. I understand how...

I'm using a form to filter data for a report. The form has 5 unbound text boxes for the user to enter the criteria. The unbound text box names are Type, StDt, EndDt, Event, and Loc.Sometimes the user doesn't need to fill in all of the 5 unbound boxes that's on the form and leaves some of them...

I'm using the DoCmd.OpenReport method. A portion of my code looks like this: Dim ReportName, DateFieldName, CatCriteria DateFieldName = "DelivDate" ReportName = "rptInvoices" CatCriteria = "meat > 0" DoCmd.OpenReport _ ReportName:=ReportName, _ view:=Me.OutputMode, _...