Data Entry Form

[gavinj.1999@lineone.net]

I have a database that I use to monitor the quantities of parcels that our company delivers on a daily basis. I would like to be able to enter this data directly onto Acces rather than cutting and pasting.

To achieve this I need a datagrid where tha lft column is automatically populated with the contents of my delivery point table and that enables me to enter each parcel count next to each delivery point. The point of this is that we have 60 suppliers delivering goods into our depot and we then sort these out according to delivery point and time is very much of the essence in terms of speed of data input.

Any ideas, all appreciated

 

[Anne Troy]

Sure would help if we knew where the data you're *pasting* was coming from. I suspect that's why you haven't received an answer yet.

 

[gavinj.1999@lineone.net]

Thanks Anne.

I currently paste the information in from a text file which is supplied via some of the companies we carry for.

I have posted examples on our company site at http://www.deeset.co.uk/datapage.htm

Regards

Jonah

 

[Anne Troy]

Okay, in the first place, I don't consider your Excel file a database. Database data is normalized.

The problem with people using Excel for this stuff is that they have "viewing" as their first priority, rather than organized data. So, in order to organize your data to provide what you want, we've gotta take it and turn it all around. No small job--at least to do it right it's not.

As soon as you see yourself using the same data over and over (like you do columns A and B for each day of the week), that should be a hint that it's time to move to Access. In Access, we VIEW that data in many ways, but we store it only once. In Excel you gotta store it or links to it all over the place.

If this were my project, and knowing what I know:
--I'd quit messing around with Excel
--I'd get it into an Access database, hiring someone to do that for you if you don't know how

I don't think you need someone on-site or anything, but I guarantee that the time you save using an Access solution will long pay for any price you pay to develop it.

Oh, and you may very well find someone with an Excel solution, but you'll likely have the same problem every time you want to add *just one more feature*.

_________________
Anne@TheOfficeExperts.com
TheOfficeExperts
This message was edited by Dreamboat on 2002-12-11 01:55