Search results

  1. M

    Order by problems

    I have a subform linked to a form. I have set the Order By property of the sub form to dteDate but when I load them up together the form refuses to order by dteDate. I have also tried setting the Order By property of the form with no success. I have an autonumber field in the sub form. Could...
  2. M

    Print Report of ALL items in a combo box

    In my reports menu I need to print a report of all items in a combo box - The combo box reads: SELECT tblName.szName FROM tblName UNION SELECT "(All)" FROM tblName; This brings up "All" at the top of the combo box but the report has no data. Is my query the problem or do I need more code to...
  3. M

    Two Delete Message boxes

    When I delete a record I get one message box (The one I have programed in) and once I click ok another one pops up telling me that I am "about to delete a record, am I sure?" How do I get rid of the second one. Any help would be much appreciated.
  4. M

    Is IsObjectLoaded a vb method?

    In the form close event I need to determine if a form is loaded and it it is I need to update the combo box using requery. I have an Access database in front of me that has used the IsObjectLoaded method in the form close event but when I run it in my database Access gives me an error message...
  5. M

    Changing combo box search field by using option buttons

    Can somebody please tell me if they know how to change the search field of a combo box by using optoin buttons. For example: To enable a search combo box to search by project number and by project name
  6. M

    Linking Back end to Front end once Database is split

    The back end of the databse resides on a server while the front ends are on the client pc`s. What code do I use to ensure the Front end sees the back end and where do I put the code
Top Bottom