Recent content by sarohap

Hi Experts, Please help me that how to add recoreds in table thru form. There are 10 fields. first two are txt boxes and rest of are combo boxes. combo box are with drop down list. But they are unbound. two txtbox are auto filled by the username and empid. Now need to write the code to update...

Hi All Experts, Need your help. I am creating the chart with data source (range(w6:x50)). But every week data changes some times it goes more then 50 or less then 50. now i want that there should no need to do any thing to change the data when i replace the data from current data with previous...

Please could you explain that how to use this condition...? Please send me your mail id so i can send you the sample database...

Hi all, Please help me to get the data from two tables on the basis of criteria... I want to select the whole table1 which has 6 fields including Emp_id... I want to select the single field from table2. field name is "Username" from second table2. will select the username on the basis of...

Hi All Experts.. My new query is..i have user table to login in the database.. this is user login table userid = autonumber emp_id = number empname = text username = text password = memo role = text. this is admin userlogin table adminID = autonumber adminname = text adminpassword = memo...

Hi Paul, its not working which i have tired.. This is only one form with has only one button. so which code would close the form after getting the report.

How to close the form after generate the report. Form has button to generate the report. when i click on the button then report pulls. but form do not close, So how it will be close after generate the report.

Oh thank you...so could you let me know that what is the title of that?

Thank you so much linq.. My new query is..i have user table to login in the database.. this is user login table userid = autonumber emp_id = number empname = text username = text password = memo role = text. this is admin userlogin table adminID = autonumber adminname = text...

Thank you Linq.... now its working fine.. one more query that how to set the focus on first textbox after update the new record in table...

Hi Dale, first i have bounded the fields. But when we user open the form then last record shows them which is do not want. fields should be blank when user login and get the entry form. thanks paul to move this thread in appropriate forum...

Hi all experts, Please help out me in this case. I have 6 text box on the form which are unbound. Now we enter the entry in these boxes then I have update button on the form to update the record in table. all fields should be clear after update the records in table so I can enter the new entry...

Hi, I have form with 11 fields. there are some fields are text, some are date format and some are memo and some of numbers. Now there is submit button to submit the all fields in table thru single click. I am new in access and in coding of such kind macros. So could you please help me to submit...

Hi All, I am new in this forum and new in access. I have form for the daily transactions. When a user will open the form and will fill the all fields with transaction details then their user id should show in a specific textbox... Or when i will click on the submit form then it should update...