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!

  • Congratulations TouchToneTommy 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: ernigles
  • Content: Threads
  • Order by date
  1. ernigles

    Filtering a form, according to the number of records in a subform

    Hi all, I come back to this forum after an absence of ..several years! Ok, let’s go to the point: I have a form called frmCustomers, and it has a subform (sfrmContacts, continuous type) that shows every contacts made with the specific current customer in the main form (in each record of the...
  2. ernigles

    Is 1’574 GB of images space (with DBPix) workable on an Access DB?

    Hi, i have an Access application that must work in Access 2000, 2002 (XP), 2003 and 2007 Access versions. The application uses DBPix for the image treatment in the DB. They are 486 records, with an average of 12 images per record of 270 KB each image: 486 · 12 · 270 = 1’574 GB of images space...
  3. ernigles

    Report margins are changed to the default ones (24,99 mm)

    Hi, some times, though In File > Page configuration the margins of the report pages are stablished, when the report is again opened in Preview or printed the margins are the default ones: 24,99 mm. ¿How can this anomalous reconfiguration of the page margins be avoided? Thanks for any help given.
  4. ernigles

    DoCmd.OutputTo fails in some pcs

    Hi, in some pcs in which i have made this comprobation, the command DoCmd.OutputTo doesn't run; when this code line enters the procedure stops running. The code line is: DoCmd.OutputTo acOutputReport, "reportName", acFormatSNP, CurrentProject.Path & "\temp1.snp", False Can it be due to the...
  5. ernigles

    Microsoft office Access has encountered a problem and needs to close

    Hi, since i have added a few lines of code to my database from the VBE, i have the window: "Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience" when i open the database. The code lines are: Private Sub Form_Open(Cancel As Integer) If...
  6. ernigles

    Access 2007: Do you want to save the changes? when unloading a form

    Hi, i have a DB with two main forms, and a button in each of them for going from one to the other. SOmetimes, when i change from one to the other Access asks me if i want to save the changes in the objects: both forms, and some subforms of the form of origin. Can anybody say if that can be...
  7. ernigles

    Access 2007: Hidding the Toggle filter button in the navigation bar

    Hi, i have implemented in a form the way of filtering and removing these filters, so i need the only way of filtering or removing filters be from the form. Can the Toggle filter button in the navigation bar (in access 2007 version) dissapear, or at least dissable perhaps handling the command...
  8. ernigles

    Closing all open reports from the OnActivate event of a form

    Hi, i want to close each report of a DB when it loose the focus, and since the forms that gain that focus can only be two, it's less hard to handle it from these two forms, on the event OnActivate of the forms. But, how can i know which report is which is open in each moment, for closing that...
  9. ernigles

    Access 2003: “Update or CancelUpdate without AddNew or Edit” error

    Hi, I have a main form about vegetable species which include information about common name, scientific name, crop group, fruit and taxonomy. The target of the database is to visually identify each specie through several corresponding images, so that main form has a continuous subform (sec1) with...
  10. ernigles

    Access 2003: anomalous behaviour with browsing dialog window

    Hi, I have a main form about vegetable species which include information about common name, scientific name, crop group, fruit and taxonomy. The target of the database is to visually identify each specie through several corresponding images, so that main form has a continuous subform (sec1) with...

Part and Inventory Search

Back
Top