Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Record
Hi All,
I have created UserForm in Excel and added button which will search all the records in Access database and get the results in a Excel userform listbox. I dont have any problem in searching and updating the data into Access Database. The main problem is - Assume I have two textbox in userform 1. Name 2. Dept Using search option i will get the results in a listbox. Suppose user wants to change his dept then user selects particular name in a listbox and will change the name. if user updates the changes in my database I can see old data and the new data. I want only the new data. Is this possible, Please help me ! Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Record
use a combobox instead of list box. It works the same except the combobox
allows a manual entry. " wrote: Hi All, I have created UserForm in Excel and added button which will search all the records in Access database and get the results in a Excel userform listbox. I dont have any problem in searching and updating the data into Access Database. The main problem is - Assume I have two textbox in userform 1. Name 2. Dept Using search option i will get the results in a listbox. Suppose user wants to change his dept then user selects particular name in a listbox and will change the name. if user updates the changes in my database I can see old data and the new data. I want only the new data. Is this possible, Please help me ! Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Record
hoe is the database refreshed with changed data? seems to me that one way
would be to re-populate the list boxes wrote in message ... Hi All, I have created UserForm in Excel and added button which will search all the records in Access database and get the results in a Excel userform listbox. I dont have any problem in searching and updating the data into Access Database. The main problem is - Assume I have two textbox in userform 1. Name 2. Dept Using search option i will get the results in a listbox. Suppose user wants to change his dept then user selects particular name in a listbox and will change the name. if user updates the changes in my database I can see old data and the new data. I want only the new data. Is this possible, Please help me ! Thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Record
Yes I agree, but old record in my database remain, I dont want that
old data once it is updated. On May 17, 2:59*pm, joel wrote: use a combobox instead of list box. *It works *the same except the combobox allows a manual entry. " wrote: Hi All, I have created UserForm in Excel and added button which will search all the records in Access database and get the results in a Excel userform listbox. I dont have any problem in searching and updating the data into Access Database. The main problem is - Assume I have two textbox in userform 1. Name 2. Dept Using search option i will get the results in a listbox. Suppose user wants to change his dept then user selects particular name in a listbox and will change the name. if user updates the changes in my database I can see old data and the new data. I want only the new data. Is this possible, Please help me ! Thanks in advance |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Record
You need to use a combobox, but you can also have a routine that after a new
entry is entered that would remove the old entry(s) that you want to remove. Use a combobox ONChange function to remove older entries. Kepp a copy of the old values hidden so you can figure out the new entry. One trick is to have a hidden box on the userform that keeps the old values. Then compare the hidden box to the visible box to figure out the new value that is added. so you would have Combobox1.visible = true and combobox2.visible = false. " wrote: Yes I agree, but old record in my database remain, I dont want that old data once it is updated. On May 17, 2:59 pm, joel wrote: use a combobox instead of list box. It works the same except the combobox allows a manual entry. " wrote: Hi All, I have created UserForm in Excel and added button which will search all the records in Access database and get the results in a Excel userform listbox. I dont have any problem in searching and updating the data into Access Database. The main problem is - Assume I have two textbox in userform 1. Name 2. Dept Using search option i will get the results in a listbox. Suppose user wants to change his dept then user selects particular name in a listbox and will change the name. if user updates the changes in my database I can see old data and the new data. I want only the new data. Is this possible, Please help me ! Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
record update VBA form | Excel Discussion (Misc queries) | |||
On Duplicate, update record | Excel Discussion (Misc queries) | |||
Update a record in the recordset | Excel Programming | |||
update record in mdb.. | Excel Programming | |||
Code to Update a Record | Excel Programming |