Some Access Database programming, Access 2000

[Guest]

I need some help with several problems --
1. When i'm importing records through a query, using an append table, its
telling me its found several errors in all the records, because of a
validation rule. Tehre are no validation rules set, and ther are no
formatting issues. At any rate, if i override it and allow it to import the
data, it works fine. Id like to remove this problem, as the people who wil
be using this database are not technical at all.

2. I've tried several different code snippets on the web and from MS's
different affiliates, with no luck. I'm trying to make a very simple filter
so that by selecting one of the (NON duplicates) on the list box, all of the
records are filtered to show only those with the same value as the list box.

3. Exporting data onto a web form.. . this one needs lots of help. I have
not yet built the form, but I intend to have it served from a secure server
from my workplace. My options are, what is currently done, whihc is
exporting the results to a spreadsheet and emailing it to everyone, and what
i want to do, whihc is create a webpage they can look at online, with no user
permissions except to read the records, using the same sorting method as
above.

I imagine someone will want a copy of some part of my database. I can
provide that, but as the records are secure, i wil have to clear them out.

 

[J_Goddard via AccessMonster.com]

Hi -

The first part of the your questions sounds as if some of the fields in the
table being appended to do not allow nulls, or do not allow zero-length
strings. The latter in particular can cause problems with blanks in incoming
data.

For the second part, use the after update event of the list box to change the
form's filter:

me.filter = "FilterFileld = " & ListBoxValue
me.filteron=true

for numeric list box data. For text data in the list box, use:

me.filter = "FilterFileld = '" & ListBoxValue & "'"
me.filteron=true

using single-quotes to delimit the text value.

I have to leave the third part to the experts out there, but this should help
a bit.

John