Search results

Thank you..

how to autopopulate other fields in my form based on the value of other fields.. 1. I have 10 combobox field in my forms.. I need to autopopulate all other fields based on the selection i made on the first field. 2. there are times that i need to change the value in other fields..in my...

Sorry, I'm really confused how would I do that.. can you please give me a sample code.. Thanks

Hi vbaInet.. I have one more favor to ask hope you could help me.. I have this code below which is working fine.. Can you please help me how to add code that will close the current open form when I select another value in my combo box.. I want to get same results as we did in my previous post...

Got it! THANK YOU SO MUCH!!!

I tried it.. it was working fine.. but I think it is not closing the Current open form, instead it is overlaping the current open forms. can you please check the code? THANK YOU for the help.. I Really appreciate it..

I tried it, but it is also closing my Form1.. I was actually creating a navigation style forms that's why I wanted my Form1 to be visible at all times since all buttons are located in Form1. Form1 houses my buttons to open Forms.. any selection from this should close the Current form EXCEPT...

I have a Form (Form1) with 5 buttons (Button A, B, C, D & E) which opens Form A, B, C, D & E Respectively... I want the current Form to close everytime I click on the other button.. TAKE NOTE: Form1 should be visible at all times only the form A,B,C,D & E should close and open on button...

Hi, I'm using Access 2010. I have a Navigation form with 2 tabs for my category, ADD and EDIT ADD(Tab) Linked forms under ADD New Employee New Leave New Salary EDIT (Tab) Linked forms under EDIT Edit Employee Edit Leave Edit Salary Everytime I select/switch to my Edit tab.. a...

Yes Im using Access 2010.. I tried that OpenForm event but my problem is linking it in my Popup form with ADD or EDIT button. I was thinking of a Macro or VBA code that will do the same. but I really don't know how to write codes.. I also tried the Macro builder that Guides me which form to...

Popup Form to open Navigation Subform in Add or Edit Mode Hi, I have a Navigation form and I have created a Popup form with "ADD" and "EDIT" button.. this will Popup after selecting the button from the Navigation Control... what I want is, when I Select the "ADD" Button I want my Subform in my...

Thanks.. But how do i linked this to my button?

Hi, I have a Navigation from.. I want to have a popup form with "Add" & "Edit" button that will do the same. Here's the Scenario. On Navigation form Click the Control to open a form (Employee)... then "PopUp" form will appear, then if I select the "Add" button.. i want my form in the...

Hi, I have this Query that are linked to my Forms, but i don't know how to write the right code if the value is Null for my second Query. the problem I encountered is when I used my "Between Date Query".. when the value of "MEPNumber" is blank or Null my report will give "ALL" the data...

There are NO Error.. but Im getting all transaction results... as if there is no criteria to filter the results .. do i have to write something in the "Criteria" portion of my Query also?? if so.. what should i write??..Thanks My report is Based on the Query... and my form "Text" box for...

Hi.. I have this code which I copied from other tutorials.... but I really don't know what's wrong with my date "From" & "End" query.. it's not giving the right results. Please help.. Thanks. Private Sub openpqrprt_click() On Error GoTo err_openpqrprt_click Dim stdocname As String...

Check this Link.. it may help you.. http://www.access-programmers.co.uk/forums/showthread.php?t=211928

To extract that data you need a Query.. then from Query.. you can generate the report as per your format. By the way.. you need to have a Foreign key in your Relationship

Thanks for your reply.. after entering data into my fields in the form the cursor will activate the Command Button...since it was the last field in my Tab arrangement....When I press the ENTER the Message box ("Please click on the button to add data") that i created appear.. but when I Press the...

Hi I have one command button in my form. i want my button to 1. SAVE the data upon click of button and CLEAR all fields for new data entry 2. I noticed that when I press the ENTER it will do same action as clicking my button... I tried the "on Enter event" and create a Message Box when Enter...