I am converting data and trying to split up a field that stores
multiple values separated by a comma into separate fields
Example: Field 1 will have the following data "A, B, C" or "A, B"
I need to update Field 2 with "A", Field 3 with "B" and Field 4 with

Here is what I hope is a simple question. I can count the total number of
boxes that are checked, but was wondering if there is a way to count the
boxes that are not checked? Any help would be most appreciated.

I have a 255 character text field with data of varying actual length in it.  
The first part of the data is all structured the same and I need to parse it
out effectively into 3 separate fields.  Data is like:  XXX, YYY,
thenbunchofothernonsenseupto255chars.

I'm wondering if anyone can recommend a site where I can search for or
post a request for a qualified VBA tutor that I can ask questions of.
I realize this might involve money, but I guess if I want to get
better, I have to fork out a bit of money for some education.

I currently have a Yes/No field for each contact titled "newsletter"
that determines whether a contact receives our newsletter or not (we
also have two other periodically sent out items that have check marks
as well that this applies to). However, I want to be able to send a

I am working with Access 2003.  Sudenly, all of my table, query, form and
other icons are underlined.  This is true for whatever databse I open.  How
did this happen and how can I turn it off?
Thank you for any input you may have

I am converting data. I have a field called Partners that stores
multiple values example: A, B, C
I need to identify each valye separately
Example

I have multiple large files I import into Access every Monday morning.
I currently do it manually, bringing them in as delimited files using
a tilde, "~", as the delimiter due to our data having commas in it. It
takes about 30 minutes for me to do all of them.  I want to expand our

In my short exposure to Access databases I noticed something that is somewhat
troubling.
In my opinion you can look at an Access database in two frames of referrence:
1) As an application

This is a tough one.  I have over 1000 names of children involving about 25
fields: Address, city, emergency contacts....   Some of the info is
duplicated.  Foster kids with same guardian, ....  But my question is:  How
can we enter new kids without duplicating a record that may ...

Hi,
I have the following code in the 'on click' event of a command button on a
form. Also on the form are text boxes.  I want to type a 'post code' into my
relevant text box, click my 'find' button, and the associated info (which is

I have a form I have created that is supposed to be filling in information on
3 separate tables. However, whenever I try to change any information that
would be filling in on any of the 3 forms, it says "recordset not
updateable". I'm obviously doing something wrong but I can't ...

I have this data sample in my NatID field
NatID
701011234567
700709112567

Hi,
I am currently developing a small program for a customer, which uses
MSAccess. When I use OleDbDataAdapter to update the database, and it returns
the correct value (1 for 1 update/insert row), but when I reload the data,

Can I find a specific last name in an access database with last name, first
name, address, city, etc? Is that possible? (I hope this is not a stupid
question)  Thanks.