Dumping Data into an Access Form using Datasheet view

[cazzi]

Hi-
I created an Access form w/ certain fields that have dropdown picklists &
selected "Limit to List" option to Yes for these fields. When i perform
basic data entry & i try to add something not in the list, it doesnt allow me
to add it (which is what i want). But when i go to datasheet view or the
table related w/ this form & copy & paste data from an excel spreadsheet, it
accepts everything i paste & i want the paste errors to appear for the fields
where it should only be Limit to List.

 

[pietlinden]

That's because the table cannot "see" the form. They're totally
independent of one another. If you want to force users to use the
form, then hide all the tables.

 

[DrEvil]

First of, I'm not sure why would you switch from form view to datasheet view
while in database, it's one or the other in most cases.
Changes like that to forms will not reflect back to table, never does.
Also I would suggest that you never allow users to adjust/enter data
directly in table, they should be using forms, which limit users to what you
want them to do and how you want them to do, my rule is that user never sees
table structure no matter what .


Amir

 

[cazzi]

Hi- Thanks for the reply. It would actually only be me who is importing the
large amts of data. It will be disabled from other users to access. The
form was created first & other individuals are cleaning up the spreadsheets
to match the fields on the form, but was hoping it woud reject the data that
didn't match the form fields that were Limit to List. I'd prefer not to
manually enter 100s of records. This is the initial data dump for the form,
but going forward it will always be data entry. Is there an option to import
data to a form?

Thanks again,

 

[cazzi]

Thanks for the response.

 

[DrEvil]

I would normally create some type of command button on form and on click run
something like this;
DoCmd.TransferText acImportFixed, "PPimportspecs", "tblTempData",
"\\server\ftp\public\CORCOMP.TXT", False

This would import whole file to tblTempData, then I would run query which
will filter out the data from tblTempData that's needed and then run perhaps
append query and use filtered query as your source to append filtered data to
your real table.
Hope that helps

Amir