I hope someone can tell me how to “convert” field value to field name
I have a table with test results for a lot of samples
I have different field name which is named equivalent to the type of the
microbe 16, 33, 41, 67 etc.

Hi
I am setting up a database with check boxes for Services that are offered.
What i would like to do is convert the values into specific text. So for
instance, if the check box for Project Management and Quantity Surveying is

  I am try to debug a program, but I can't figure out the problem. When I
call this function, it show "Run-time error 3709 The connection cannot be
used to perform this operation." Please tell me where could be wrong. Thank
you very much.

I'm having a hard time with a connection string to my oracle database.
What I'm trying to do is run a stored procedure on the oracle side from
Access.
I have set up the code and defined ADODBConnection as NEW ADODB.Connection

I have read the posts on passing a control to a function.  As long as my
control has some data in it, the function works fine.  If my control is null
I get a message "You tried to assign a null value to a variable that is not a
variant data type".

I am using Graham Thorpes search but I can't get it to work.  I have it set
on a button but when I click it, it does nothing like a "dead" button.  Any
ideas would be greatly appreciated.
'--------------------------------------------------------------

I've got a database where I need to concatenate fields in order to export to
a flat file.  The file will be imported to a system that is parsing out
values based on character location, almost like a fixed width file, but each
field has to fill out the alloted space.  Example:

All,
I have got 14 recordsets that I export to a single Excel workbook, with 14
spreadsheets, every week. The problem I am having is, there are some
occurences where people change the recordset in the middle of the week and I

I have a form with a spreadsheet control. I use this to copy a set of cells
from a standard excel spreadsheet. I have a table that I want to put the data
in. I would like to create a macro that copies the data from the spreadsheet
control and puts it in the appropriate form ...

I'm currently using Access 2007 in Vista.  My question is how do you, if
possible, write in VBA to import a CSV file and make the import recognize the
text qualifier of quotes?  I can't have a specification done, because this is
a tool that will use the same code to import ...

I have a form that I am using to gather user information. But the info I am
trying to gather might contain characters such as the double-quotes (inches
in this instance) and the pound sign (#). Even though I used actual
double-quotes in my SQL statement (""" kind of thing) ...

I want to produce a product key based upon the Product name, a purchase date
and one or two other fields, that is provided to the user to register their
database.  I have code for encryting passwords but that produces a lot of
characters that are not keyable.  I need to find an ...

I was curious if this is possible.  I have approx 4 or 5 forms that
update different tables in the database.  Is it possible to establish
a sub form on these 4 or 5 forms, without having to rebuild from
scratch?

Is Conditional formatting available for a control in datasheet view in access
2003? The Help seems to suggest it is, but I suspect it is referring  to the
access 2007 feature as I can't find 'Conditional formatting' on either my
format menu nor format tab (ie on the control ...

We have an Access Database running through Citrix.  In that db we have
code which creates an Excel File which I then want to be able to Save
to My Desktop.  However, running through Citrix it stores the file to
the location/server where the Access Database resides.  Is there a way