How can I get the value of the third column of a multi-select list box?
Thanks
Regards

blabla...

I have a field, called [Mark], that can be anywhere from 0 to 100.  I would
like a query field, called [vangrade], to operate the following on the number:
If [Mark] is from 0 to 64, change to 0.5
If [Mark] is from 65 to 95, apply the formula ([Mark]-55)/10

hhhhhhhhhh

I encountered a problem that required me to delete a record that appeared as
all # signs in each field of a record.  Since then, I'm not able to add new
records in any of my queries or forms (but I can add records in my tables).

I have 2 combo boxes. My aim is to fill the 2nd combo dinamically, by the
choice on the 1st combo.
With the event onchange of the 1st combo I create a table with docmd.runsql
"select...-into...mytable". The 2nd combo rowsource is a query on mytable.

I have a table with the following fields:
[ID]---[Mark]
The [Mark] field is set as text, and can have values that are numerical
(from 0-100) or text (P or F).

How do I set the seperator in an import of text file in word. The recorded
macro went thru just fine. when run it stops on the set delimiter screen.
I've tried seperator="," did not help.
Thanks to all

I have to remove rows from a table where a specific Field say "F1"
contains string value instead of Numeric value. Suppose we have a
table myTable having following values.
F1       F2         F3

Hi NG,
How can I set the equivalent to VB's screen.mousepointer in Access VBA?
Thank you,
zz7

prova messaggio

I would like to start default database when I start MSACCESS.EXE
(Runtime). Is it possible? How to set the default database?

would anyone be able to help with the following SQL:
strSQL = "SELECT [qry_(1)ServersAndSubBackups].Client,
[qry_(1)ServersAndSubBackups].ServName, tbl_Perm_ServNameSubDay.[Backup
Name], tbl_Perm_ServNameSubDay.Day" & _

I a memo feild that has a complete textfile loaded into it.
I am trying to scan through each line of the memo feild, and copy the line
scanned into a record in another table.
I am using the following code:

Probably obvious but I can't see how to change the axis titles in
pivot charts.
All I see is 'Axis Title' where I wish to write the category (x axis)
and value (y axis).