I have  grouped 8 radio buttons, and given them the same Tag name of
"mdcode".
how to I make this group visible when a checkbox "checkbox76" has a
value of 0 and hide the group when the checkbox value is -1?

When using functions to calculate values based on field values in a query is
it neccessary to declare each query field in each function, or can they be
declared as public variables?
For example, must I do the following?

Why do I get "argument not optional error" in
Case MF
       If DD <= 365 Then
           LowMFrate

I have a set of titles of movies, with "The" or "A" in the front of the
title.  I would like to ignore these definite/indefinite articles when I sort
the titles alphabetically.
I had thought about entering data using the "FileTitle, The" method, but

Surely this is a common situation, but I haven't been able to find a
discussion of it.
I'm processing in the click event procedure of a command control. I'm
going to open another form based on user inputs from the form. But if

I would like to have Access 2003 send me an email notice when a specific date
in a table is approaching. For instance, when the expiration of a lease
agreement is approaching. Is this possible and how would I do it?

This is my first data base design And I have problem with DoCmd.OpenForm
command
I have a table Car order Table (OrderID -- primary key.)  I created form
“Order ID by Customer” where I can look at all orders based on a customer. On

Public Const strcJetDate = "\#mm\/dd\/yyyy\#"
Hello,
I don't understand the backslashes \ in the above line.
I know it works in this way, but i also want to understand it.

Hello,
I have a switch board with a list of Clients, but each client has a
different query or report, because the client logic and or calulations aren't
the some. What I would like to do, is from the switch board select a client

I have a main form with a subform in DS view. I want a Delete Button on the
main form that deletes selected records on the subform. I got that far with
the code below and works fine for now.
Private Sub btnDeletePlantingDetails_Click()

Hi, I've been going at this for hours, apologies for my cluelessness.
I'm trying to extract records from a table in MSA 2003, alter them and
append them as new records, which is the point where it's breaking. I pasted
my latest attempt below, (>> where it breaks). I'm also quite ...

I'm trying to learn the use of SQL in lieu of using queries all the time in
Access 2002.
When I enter any SQL statement in the VB section, I get a "Compile Error.
Expected end of statement."

I have code that is supposed to import a spreadsheet from Excel.  When I look
at the Excel Spreadsheet there are 3775 lines.  When I import it it only
imports 2847 lines.  Here is the code that does the import
DoCmd.OpenQuery "qry:WalStoreDel", acViewNormal, acEdit

I have been trying to build a search of text in pdf files but the return
value is true even when no text is found. Does anyone see a problem with this
code?
Thanks in advance.

I'd like to create a trackable way of keeping history on what and who changed
the record.  I am envisioning a process that would open the record and copy
the data into a new form.  Once the user changes the data, it would then
commit the new record into the database with the user ...