Hello Forums!, can anyone help me with my search and update form?
I just want when in input a data in Textbox4, it will search it sheet1 and populate the Textboxes else a messagebox will prompt "No Records Found!".
Also, in Commandbutton1, when searching is successful, when i amend something in the textboxes and click the "Amend" button, that data will amend in sheet.
Thank you in advance.
Just one question: why you are using Textbox4 in which you have to enter the employee name manually and why not ComboBox1?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Something like this?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Hi Sir Sixthsense, actually this is part of my multipage form (Add New and Update Tab), the form attached is only the Update Tab, the combobox1 will use only on Add New Tab and will not be amended in Update Tab (hope u get what i mean despite my bad english).
Hi Sir JapanDave,
I've run the amended file but it add new a line when i click amend button, i just want when the user search, it will update in the same line.
Also, is it possible to run the code eventhough the combobox1 enabled set to false in userform intialize event? I just want textbox4 will only enabled when userform initialize.
Last edited by siobeh; 04-24-2013 at 12:18 AM.
Try this file and amend Jason's data.
looks closely JapanDave
1. When the user click Amend button, i just want to clear the textboxes and combobox so that
user can search another data and not exit the form. I will make a button for exiting.
2. When user enter a data in textbox4 that is not in sheet1, messagebox will prompt "No Records Found!".
Also, is it possible to run the code eventhough the combobox1 enabled set to false in userform intialize event? I just want textbox4 will only enabled when userform initialize.
Also, is it possible to run the code eventhough the combobox1 enabled set to false in userform intialize event? I just want textbox4 will only enabled when userform initialize.
Last edited by siobeh; 04-24-2013 at 02:01 AM.
OK, I think I know what you are looking for.
looks perfect JapanDave!, how about number 2? prompting messagebox if user input a data in textbox4 but not in sheet1?
Also, when userform Initialize, i just want Textbox4 only be Enabled, is it possible run the code like that? initially, textbox4 and combobox1 is enabled, i just want textbox4 only.
If you leave the amend button active, you can do that.
See below.
Perfect JapanDave!, last one, when i tried to search the name and amend the name at the sametime, msgbox is still prompting. I also want the textbox4 can be amended. For example, the user save a incorrect name, he/she can amend it.
Ex: User search name "Jason" then user wants to change "Jason" to "John".
can anyone help me please
Hold on a bit, I have to get some sleep. I will sort this out shortly.
No worries
Ok, try this,
Last edited by JapanDave; 04-25-2013 at 05:49 AM.
Awesome JapanDave!
Last edited by siobeh; 04-25-2013 at 02:23 PM.
hi i have some ask.. how to make a search and update/edit using textbox and listbox? or textbox... the file attached its only one button .. i want to separate button..but i want data to display in listbox all with Show that data in the multicolumn Listbox if i click it automatic to other form that compose some textbox :D i hope all you help me..
thanks in advance more power... ^_^
Last edited by sunguhan2013; 04-28-2013 at 03:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks