Search results

Hi Missinglinq, I just want to share with you that I deleted the code part Mod TabMainPages.Pages.Count from the whole codes, and both Next and Previous buttons still work correctly now. So I wonder what is the purpose of the code line Mod TabMainPages.Pages.Count My final successfully...

Hi Arnelgp, Thank you for your new testing code. I tried it but did not work. Nothing happens when I press the command button. I am not sure if I am missing something. By the way, I got a Debug error message in the beginning, and after checking I realized that the code missing (End If) which...

Perfect! Thank you so much Missinglinq. Your code solved the issue and fixed the error. However, I made a light change in the first line of your code, I replaced 1 with 0 because I cannot move back to the first page in this Tab control. My final code for both command buttons are: Next Page...

Thank you Arnelgp for your reply. The Next Page code you gave me works to move only to the second page and then completely stops. In other words, I guess your code works like: tabmainpages.value=1 Again, my issue is not with the (Next Page) button but to slightly change and fix the (Previous...

Hello everyone, I have a subform which includes a Tab Control with 8 pages. I want to hide the pages tabs to force users navigating from a page to another and giving required data/info. So I created 2 Command Buttons (Next Page) and (Previous Page). The Next Page code is: Private Sub...

Never mind. I found the issue and fixed it. There was something wrong with the ComboBox Lookup. Thank you and have a good day. Anwar

Hello everyone. I am building an Access 2010 Web database for the first time and I found a lot of differences with the Access desktop database. I have a specific question about query parameters and how to pass them from a Form combo box. In this web db, I have (tblClients) table, (qryClients)...

Okay thank you I will later.

Got it. That means I need to redesign the entire db. I will see how to do that. I need to start over. Again thank you for your time and feedback..

Thank you vbaInet for your reply. The steps you gave me will not work in my case because I assume that the user completely ignors or forgets to open the (Benefits) tab, and I want to warn him/her of the missing data once he/she fills the three fields and saves the record. Yes, I agree that I...

Thank you vbaInet. I put the new code in the cut down db but still did not work. I wonder did you try it yourself? Also I realized that when i move from tab to another to add info/data in each form's new record, this info/data will be saved in different rows in the main table. I thought it will...

Hi vbaInet. I added your code to the form (frm_Benefits) according to your instructions. The forms are bound to the table (MainListTable). The scinario is to open the form (frm_Clinets), then to open the tab (Job Info) and start filling the fields. In case if I filled the fields (Start Date)...

Hello vbaInet. I have uploaded the db. Here are some useful notes: - I deleted many tables, queries, forms, and reports from the original db. - In order to open the db, please first press shift and hold and then open the db. - The main form to open is (frm_Clients) which includes many tabs...

Hello vbaInet. Sorry, I did not get back to you. I was too busy today. I will upload a cut down verstion of the db soon. Thanks.

Ok. I put the code in the other form (frm_Benefits), I did not get any error message, but the problem is not resolved and I dont get any validation rule message that I need to complete the missing value of the (Benefet Status). I tried the follwoing options as you recommended in your very...

I followed your codes and instruction again. I put the follwoing code in the BeforeUpdate event of the subform (frm_JobInfo) . I got the error message (Compile error: Method or data member not found), and (.BenefitStatusComboBox) is highlighted in dark blue color. By the way the control...

Sorry for this confusion. In my first post I tried to simplify my question and gave a general example for my problem. Actually, I have a main form which includes 9 tabs and each tab has a form; I called them "subforms" to idicate that they are embeded in the main form, and did not mean to...

Thank you vbaInet for your reply and contribution. I did not reply to your post right away because I made many attempts to solve the problem, this took me a lot of time, but sitll with no luck. I followed your instruction step by step and did all required changes, but does not work. There should...

Thanks Ranman. I tried to follow your instructions and changed the code but with no success. Remember, my original problem is to handle Null values in 2 different forms. Here is my code: Public Function IsValidForm() As Boolean Dim vMsg Select Case True Case Me.BenefitStatusComboBox =...

Thank you Ranman for your reply. Sorry, I could not understand the code. Also I tried to read more to understand IsValidForm() in MS ACCESS but no success. I wonder is this Access code? Thank you again, with my appology for my poor skill in Access VBA. Anwar