Forms in Excel (to add records and edit them)

[klmorgan]

I would like to write forms to both enter data and retrieve it for other people to use but it seems that you can only do this if you also have Access.

I have access but the other users don't so is this not possible.

The Form that comes with Excel (data\Form) would be Ideal itself if I could modify it to increase field sizes etc but I can't seem to get at it to modify it.

What I am trying to achieve is to allow one set of people to add records to the datababase and for another set of people to add their information to fields in those records

Advice appreciated

Keith

 

[LeKirk]

Have you tried using the Template Wizard to create yourself an entry form? Check out the help. You may need an add-in before it will work.