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

bj6671

New Member
Joined
Jul 25, 2007
Messages
16
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.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

VicRauch

Well-known Member
Joined
Mar 23, 2006
Messages
2,032
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

New Member
Joined
Jul 25, 2007
Messages
16
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,809
Members
416,983
Latest member
LessThanAverageUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top