I have correct permissions and have successfully updated my data using
another method. However, the other method requires the field to be a
part of the recordset bound to my form (i.e. loads all records on
open). And the field is way to big to keep doing it this way.

I don't get an error but it also does not update my table!!
This code should create a new record in table: tblQualityProvider then copy
ICNNo into the new record.
(The GetNewID comes from a public function - I pasted it below this code).

I know that the best way to track who is in the db is to enforce security.
However, I am in a situation where the client does not want the security to
be enforced at least right now. since we will have to keep another file
(.mdw) on the network. Is there a way to track few users ...

Experts,
I'm trying to get a record count based on the value in the combox.
For example if 2 records are marked "completed" out of 5, I want 2 as
my record count.

I have a form with a couple combo boxes on them that I am using as criteria
for a query's parameters... I have the path and name of the combo boxes as my
query's criteria... all that is working fine... now what I am wanting to do
is to have an option to 'select or unselect all' from ...

Is it possible to use an option button as a query sort option?
I have a form with two option buttons... when one option button is clicked I
want my query to be sorted according to that... any ideas?
Thanks

Amazing Creativity on Ceiling
http://amanspace.blogspot.com/2007/10/amazing-creativity-on-ceiling.html

importing an excel workbook from one of our clients. the field in question
should be text but was described as numeric by client. so when i import the
info, any alpha numeric info in that field rejects the record because of type
conversion

I'm trying to use the not in list event to open a form, add information in
it, close the form, and then finish the rest of the not in list code, but I
don't know how to stop it after I open the form.
Thanks for your help.

I have used Access for some time but am new to listboxes always having used
a combo box before. I now have a need for multi-selections though hence the
listbox.
What I would like to achieve is

I have encountered an interesting issue that I have no idea how to fix.  I
have a form that has a button to launch a report based on the current record
that is being pointed to.  The report runs from a query that is filtered to
that specific record number - the code declares a ...

I''d like to lookup a record in a subform based on a combo box in the main
form.
In the afterupdate event of the combo box I like to lookup and display the
record in the subform.

I have built a tabular form and trying to populate the data from a
table which is not in its .mbd file. So i have set the rst object to
that mdb file from where i want to fetch the data but when i am
saying

TIA...
Not sure where to post...
I found info from Access Query group that I could define function and then
use it as variable for query object criteria, so...

I have built a tabular form and trying to populate the data from a
table which is not in its .mbd file. So i have set the rst object to
that mdb file from where i want to fetch the data but when i am
saying