Search results

  1. D

    Unable to call a sub from form

    Sure, thanks for that. My intention is that user is asked before saving/closing so code will remain mostly same with replaced DoCmd.Save. Anyhow, thank you all for advice, at the end I think I'll just stick w/codes at each form and button.
  2. D

    Unable to call a sub from form

    Uff.. seems a bit complicated for rookie like me. Is there other way to use module for codes above? If not I think I'll just have to duplicate them in form.
  3. D

    Unable to call a sub from form

    What are Transactional Bound Forms and to use them? Net provides a few information about them.
  4. D

    Unable to call a sub from form

    Considering that I want to use modules to avoid duplicating codes, what would be better choice, class or standard module? I am pretty new with VBA so working with modules is step further in my access knowledge.. and seeking for solution online didn't simplify it.. Edit: I just tried with class...
  5. D

    Unable to call a sub from form

    First of all thanks for quick response. Changing name of Save and Close did made a change but I also needed to erase Me. in Me.Dirty. Code partially works but not in the way it should. As you said there is a problem with acCmdUndo: it doesn't undo changes. Buttons Save and Close are in bound...
  6. D

    Unable to call a sub from form

    Hi all! I have several buttons in database that runs exactly same procedure (Save and Close). In order to avoid duplicating codes I'm trying to create subroutine and call it with buttons event.. I hope it could be done.. The problem is that when subs containing codes are called they won't work...
  7. D

    Annoying ‘Enter Parameter Value’ pop up

    Thank you VERY much Michael! On the road again..
  8. D

    Annoying ‘Enter Parameter Value’ pop up

    Hi, I have a form and a subform which are linked via master and child fields. Somehow, when I run form it keeps asking for Parameter value. I checked it several times but I can't get it working without pop up. In short, database have 2 related tables (subject and document), SearchSubject form...
  9. D

    Open report in preview, save file as PDF on hard drive with custom name

    Given method works great, but what if we want to just open the report (in pdf) rather than save it on disk? Is there a way to accomplish this?
  10. D

    Navigation form: limit access to tabs

    I finally get some time for this.. Setfocus method on open event: forms![Navigation Form].form.[SubFormName].setfocus just (as it is written) set focus on subform tab, it does not open the subform. Got it working with: Private Sub Form_Open(Cancel As Integer) DoCmd.BrowseTo...
  11. D

    Navigation form: limit access to tabs

    Sorry about code look, I am pretty newbie with coding.. but I'll keep that in mind next time. Your suggestion works great, thank you very much! Also, is there a way to set default tab to be opened when navigation form is open? e.g. we have 3 tabs on navigation form, they are displayed in this...
  12. D

    Navigation form: limit access to tabs

    I have navigation form with 2 tabs I'd like to limit access to users with certain type of account. There are 2 tables in database that contains user names and types of accounts (tblSecurityLevel and tblUser), and they are used to set user name, login and security level. It works this way: when...
  13. D

    Problems with auto-populated text boxes

    Thanks for detailed explanation. On change Event is the tip I found on net but obv. not working. I'll use After Update in future. What about crashing Access.. I'm afraid to build db and then loose it cause of system error..
  14. D

    Problems with auto-populated text boxes

    Hi! I have strange issue when creating auto populated text boxes which displays rows from combo boxes. In one database auto populates works with simple text box Control Source edit "=[ComboName].[Column](NumberOfColumn)". Somehow same method doesn't wotk in different database: here one time I...
  15. D

    Cascading combo select issue

    Unfortunately it didn't help. I'll move to Access2013 and hope that version is what caused problem. Thanks anyway.
  16. D

    Cascading combo select issue

    Thanks, I'll try it.
  17. D

    Cascading combo select issue

    Hi all! I searched for this issue but can't find anything that could help. I am creating simple db for document control.. or honestly I'd like to create it. DB consist of 3 Tables: tblCountry tblState tblCity and a Form (frmCity) with cascading combo boxes that allows us to enter new City...
Back
Top Bottom