Recent content by JPR

  1. J

    Subform on TabControl

    Great. Thank you
  2. J

    Subform on TabControl

    hello, I have noticed your have changed the code in the macro and added to autonumber but there is still something confusing me. If I open the form just as form (not from the frmMenu....meaning on the TAB) the combo, works fine although it should show no data (it shows test). If, I open the...
  3. J

    Subform on TabControl

    Appreciate your help. Thank you
  4. J

    Subform on TabControl

    Hello, I am designing a simple db and have created a main form (frmMenu) with a tab control with three pages. On each page, I have placed a different subform. On page1, I have Subform1. This form gets its records from Table1 and has an unbound combo box that allows to move directly to the...
  5. J

    Combo and Sub Form

    Thank you. I think I have been able to sort the problem simply creating again the form and adding the combo. A nice macro in the after update event makes the record set change based on the selection in the combo. Thank you for your assistance and time.
  6. J

    Combo and Sub Form

    Hello, I have created a form on which I have placed a tab control with two pages. On page1, I have a combo with its record source from a table (tblState) and a subform (SubState) with its record source from a query (based on the same tblSate). On the same page1 I have placed a textbox that...
  7. J

    Error Message when closing form: Cannot contain zero length string

    Thank you. Considering that these field can even be left blank (not update), should I also indicate REQUIRED YES?
  8. J

    Error Message when closing form: Cannot contain zero length string

    Hello, I am getting the following error message when closing a form: Run Time Error 3315 – Field XXX cannot contain zero length string. My db is update every month with data that I import from a text file. Data is imported in a table (table1) and displayed in form1 using a query as records...
  9. J

    Copy and overwrite objects

    The big problem I have faced in the years with the split db is having someone on the other hand running the refresh link table manager and other simple routing maintenance tasks.
  10. J

    Copy and overwrite objects

    Hello, I would appreciate any help with some code or advice on how to provide future assistance with my db. Since I have completed the database, periodically it may happen that some office may require an update or change to a query, form, etc. I was thinking of a way (copy object method?) that...
  11. J

    Hide Form

    Finally works!!! Thank for your help.
  12. J

    Hide Form

    Sorry, my type. I did change the code to false but still getting the same problem. I cannot view any form. By the way, I created a similar macro and converted it to VB. It's the only way works (although not the correct way) DoCmd.Echo False, "" DoCmd.OpenForm "LogIn", acNormal, "", ""...
  13. J

    Hide Form

    Hi, the code is in the AfterUpdate Event. The code does run without the Forms!Login.visible = True line. It works also if I put it in the OnChange event (without the hide line). Private Sub cboLogIn_AfterUpdate() DoCmd.Echo False, "" DoCmd.OpenForm "FrmMenu", acNormal, "", "", , acNormal...
  14. J

    Hide Form

    Yes, made all the changes as suggest but the login does not hide and the frmMenu does not show up. Strange
Top Bottom