Ok so I am making an excel database for work. I know Excel isn't much of a database lol, but it is the only program I can use at work. I also think it is all I need for what I want. So basically I am in charge of employment at a prison. I am trying to create a database to keep all of my job applications in one file. I got the form setup how I want. I have some features working right, but others I don't know where to start. I have the submit part write for the most part I don't want it to clear the date field. Which I had the date field auto fill when you open the userform using the initialize but for some reason it doesn't work on my pc.(I don't have the version I have at work). The TextBox fields load into the spread sheet fine, the kitchen drop box loads fine but not the job1-job5. Clear works fine again I wish it would delete the date. Search I don't know where to begin, I search and took and modified many different peoples code but I keep breaking it lol. I want it to search by name or adc and I want it to repopulate the form. I did have some code for the UPDATE button but it wouldn't overwrite the existing data, it would add a new entry.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks