Recent content by JPR

Great. Thank you

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...

Appreciate your help. Thank you

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...

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.

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...

Thank you.

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

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...

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.

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...

Finally works!!! Thank for your help.

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, "", ""...

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...

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