Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Prattdakota

    #Name? error on report control

    I have a report which has enough controls on it to make the report go to a second page. In the "Page Header" section of the report I have a control which displays one of the columns of a combo box from the selection form I created. This page header prints on both pages. When I bring up the...
  2. Prattdakota

    vba filter expression syntax

    Hello - I'm having an issue with a filter to a recordset in my code. When I try to ensure the correct precedence by adding parenthesis I get an error. For example: The following line works fine: .Filter = "TransPostFiscalYear = " & intFiscalYear & " AND (TransactionCode = 'ASST SURGEON') OR...
  3. Prattdakota

    Subscript out of range

    I'm writing VBA code within Access that will open two Excel workbooks and then move a sheet from one book to the other book. Then it will close both workbooks and close the Excel object. The first time I run the code it works fine. Then if I try to run the code a second time I get a...
  4. Prattdakota

    Object required error on For Each c In Selection

    I'm having an issue while trying to edit an Excel workbook from Access using VBA. The odd thing is, when I open the database and run the routine the first time it works. When I try to run it a second time I get a "run time error 424 Object required" message. When I go to debug, the program...
  5. Prattdakota

    Need to get date from server instead of client

    I have a number of users accessing a database which resides on a network server. The problem is that their system dates are not always reliable and I need to be able to pull the system date from the server on which the database resides. This is not an SQL server so the GetDate() function...
  6. Prattdakota

    Month function works in module not in object class

    I have a form which has a command button on it. The On Click event of the button invokes the class object form code which uses the Month function as follows: Dim x As Integer x = Month(#10/5/2004#) When run, the code produces a type mismatch error. If I run this same code in a module it...
  7. Prattdakota

    Require a subform entry before update of Main form

    I have a form which has a subform. The subform displays reasons relating to the main form record. I have a combo box on the subform (cboReasonCode) which allows the user to pick the reasons. All I would like to do is require that at least one reason be entered before moving to the next record...
  8. Prattdakota

    Assigning value to text field in a subform based on combo box

    I have 2 fields in a subform; one is a combo box (cboReasonCode) and the other is a text field (txtReasonCategory). I use the AfterUpdate event of the combo box to retrieve the category for the text field. When I do so ALL of the rows of my subform have the category field changed to the one...
  9. Prattdakota

    Maintaining Security.mdw file with Packaging Wizard/b

    I am in the process of implementing a new system to my client. I have setup the security using a new .mdw file on the master database. I am deploying the runtime version of Access with the application. The database is split and I am only deploying the front end with the package. After...
  10. Prattdakota

    Problem comparing date in form to date in table

    I'm using the BeforeUpdate event from a form to call a subroutine which will pull up a related record in a table. I use the code that follows to attempt to find the correct record in the table. Ignore the fact that the date field is called txtScheduleDate, I've checked and both fields I'm...

Part and Inventory Search

Back
Top