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 Rhinorhino 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: *

  • Users: farcanal
  • Content: Threads
  • Order by date
  1. farcanal

    Have problem with ".OldValue" and Form_BeforeUpdate...Still

    Hi I am trying to get the user to exit my form (or move to th next record using the nav bar) without saving his changes So far... Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Exit without Saving?", vbYesNo) = vbYes Then (This part I copied from MSA Help on 'OldValue') Dim...
  2. farcanal

    Exit a form without saving

    Hi I want to ask the user if they want to exit without saving a form (after making changes to a record). I can get the code to work if I use 'Form_Unload' and close the form using DoCmd.Close. But when I step thru the records using the nav. bar this doesn't work. I have also tried ... Private...
  3. farcanal

    Specifying different criteria for Subreports

    Hi I have a report containing two subreports (all unbound). I would like to open the report and specify different criteria for each of the subreports. For example the 1st subreport contains data pertaining to an "Event Date" that the user selects off a drop down on a form - the second subreport...
  4. farcanal

    Access "Help on DAO" Error

    Hi When I search for Help (in MSA or VB) for DAO, several options are displayed for example 'Database Property', 'Recordset Collection' , 'Parameters Collection' etc) - but when I click on any of them an error appears saying "MSAccess can't display help. An error occured and this feature is no...
  5. farcanal

    Export report with different filename per record

    I am trying to: 1. email a different report to a list of recipients (contained in a table) so that each gets their relevant data/page only - similar to 'Dawnd3' - have got some ideas from the forum so will test. 2. Export the report (RTF) but save each page seperately with a different filename...

Part and Inventory Search

Back
Top