Easy data entry in Access for legacy Excel users...

[bj6671]

You know how when you are in a Table, you can click in between all the different rows (records) and if need be change one field on many different records quickly? A lot like a spreadsheet.

Pretty much, I'm having to intergrate an Excel spreadsheet into my database so that people can change data in just two columns the way they used to in Excel.

I tried using the ActiveX Spreadsheet control, but after fiddling around with it, looking for a help file of any kind, and surfing on the web, I couldn't find how to even link the control to my table or a SQL statement. It would appear DataSource was what I was looking for, but while it would seem to say it could pull from most anywhere, I couldn't get it to pull from a simple Table (or better yet, a Query).

The details:
I need to have a control that will function like an open Table set in a form, driven by SQL statements that draw from two existing tables, and having the option of allowing or not allowing change access to specific columns. When someone updates one of the two columns they can access, it will update yet another Table, which can later be exported and fed into another system to do something else.

If the Spreadsheet control cannot do this, it would have to be some kind of freeware ActiveX control as I have no purchasing power here.

Please, I'm on a deadline and your assistance would be greatly appriciated.

 

[VicRauch]

I would suggest using a subform in Datasheet view. I would also suggest that you create a separate Work table to hold the data you want to allow your users to change easily. When the user is finished with the updating, you then use the data in the Work table to update the data in whatever table, in whatever database that needs updating.
HTH,

 

[bj6671]

Thank you, I will try that out today and let you know how it goes.

I had done that thing with the Work table in another DB and was thinking about how to implement that in this one. If I get the first part working like I want, then I'll start playing with that part.

Again, thank you!