UserForm to Emulate a DataForm

[caniwi]

I have no idea if this can be done, or how to do it, but I would like to create a userform that does the same functions (i.e. search, add, edit) as a dataform for a database in Excel.

Using the DataForm works, but I want to customize the look & some minor button functions.

If you can point me in the right direction I would appreciate it.

 

[PBAPaul]

Yes it can be done.

I have written various database programs (one with 146 fields - don't ask!) and they all have a userform which acts as the dataform.

Let me know a little more about what you want to do and I could then send you an Excel file with some code to get you started.

 

[caniwi]

I have five fields, one numerical and four text. I want to be able to search, add and edit the database records from the userform.

Thanks

 

[PBAPaul]

caniwi

If you would let me have your email address then I will send you a small Excel file that I hope might be of help to you.

 

[caniwi]

Thanks

jsb5293@hotmail.com