Search results for query: *

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 have the following code: Private Sub Command71_Click() On Error GoTo Err_Command71_Click Dim stDocName As String stDocName = "frmPriceUSF" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _ stDocName, "C:\Documents and...

The following line of code: qdf.Parameters(0) = sYr is producing a runtime error 3265 “Item not found in this collection” I know I can use a form for the qdf.Parameters(0) line like this: qdf.Parameters(0) = [Forms]![frm52Weeks]![cboYr] But I don’t want to use a form in this particular...

I have a form that contains an option group with 3 option buttons (radio type). For this example let’s call them op1,op2, and op3. I am trying to write an if statement in the after update event of a control on the form that will put up a message box that advises the user that they need to select...

I put this expression in the QBE grid’s criteria row of a select query. What I’m trying to accomplish is have a query use for its criteria today’s date in other words I want the date the criteria uses to be dynamic. This is the expression that produces the error...

I have a combo box named cboReports. This is the SQL in the row source property that is used to populate the combo box with the report names. SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like "*Sub*") AND ((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name; Using...

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 trying to do a lookup in a report that that uses a totals query as its record source. The report should show sales for week 12 of this year versus sales for week 12 of last year. The table that the query uses has a field named Yr whose data type is number and a field named Week whose data...

I have a form that has a combo box control that uses a value list for its row source type. My problem is the appearance of the list. The drop down list contains 2 and 3 digit numbers. I can't find a way to make the numbers in the list align to the right as you would expect to see normal number...

I’m trying to populate a table using VBA. The table has a field Called DayNum whose data property is number. There is another field in the DB called WkEnds whose data property is date/time. The DayNum field has a corresponding digit for each day of the year i.e. 1,2,3, up to 366 (this is leap...

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 a form that has unbound text box controls. The user enters numeric data in each of these text box controls. I want to be able to store the values that the user enters for future use. I am using the following code which was provided on Richard Killey’s web site. The problem is that 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'm using Access2007 and Excel2007. After I export data from an Access query into an existing Excel spreadsheet, the name definitions that were previously defined in the spreadsheet are no longer valid. Even though they appear in the Name Manager with the proper reference location the cells in...

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

Can someone please help me ? I want to build a query using VBA. I am using a form that has unbound text boxes to enter the criteria for the select query. The user fills in the text boxes as required and then executes the code. The problem is one of the fields (Type) contains text data that...

I have a bound object frame control on a report. The control’s size mode property is set to stretch. When the report prints, only the first record is printed out to the stretch size as set in the control’s property, the remaining records are printed in a scrunched smaller size. I’ve resized the...

Can some one help with the proper syntax for having a form filter a string that contains an apostrophe. Such as a field with the name O'Toole in it. Here's what I wrote but it produces an error. Private Sub Form_Load() DoCmd.ApplyFilter , "provider = 'O'Toole' or provider2 = 'O'Toole'" End...

I'm trying to get the right function to return the last 2 characters from a field that contains numbers For example the field RunDis contains numbers like: 11.41 12.55 10.06 15.30 etc In a text box control I have this formula: =Right([RunDis],2) The text box returns the last two numbers...