I have a database and have set it up so that I have 6 tab pages.  The first
contains general information and always needs to be visible.  I have radio
buttons set which have the same headings as the tab pages and I want to click
the radio button and make the tab page visible.

I have a multi-part issue and am not sure this is the correct forum, so feel
free to move this post, as necessary.  With that being said, allow me to
briefly (will go into more detail, if needed) describe my problem(s):
Recently, I was given a database to dissect and try to make ...

I have a form called "clients" that has a combo box field for an e-mail
subscription. The choices are unsubscribed (underlying value=0), subscribed
(underlying value=1) & not subscribed (underlying value=2). This info also
shows on a subform on a form called "companies". I would ...

How can I have a control "Yes/No" on a form that once the checkbox is checked
that do not show the line record on my report
Thanking you in advance for your answer
Fredderic

I am trying to require that users make a selection from an option frame by
using the following code in the On Exit event of the option frame.  If an
option is selected it put either a 1 or 2 inthe LOC_IndIDN field:
Private Sub Frame_IndorIDN_Exit(Cancel As Integer)

I am using the following code to open a report.  There are 2 where
conditions.  Both work fine if I just use 1.  When I put them together with
AND I get a type mismatch runtime error 13.
DoCmd.OpenReport "rptBoxPrintout", acViewPreview, , "TestID=" & Me.TestID

I'd like to use the Get Login name function as detailed here:
http://www.mvps.org/access/api/api0008.htm
On the form, there is a ComboBox (Combo1) and Command Button.  The user
selects a text value from Combo1 and then clicks the command button.  

I have a query that extracts the top 5 processing times of a process. It is
a basic query that substracts the finish time to the starting time:
ProcessingTime: finish_time - start_time
and I constraint the Top Values function to 5. Nothing wrong until that point.

Is there a easy way to totally lock fields up so that it cannot even be
clicked into?
For instance a continuous form but I need most of the fields not even
clickable.

I have the following dlookup
=DLookUp("CountOfAPP_ID","qrylookupattend","PAT_ID=" & [PAT_ID])
if there is nothing to look up then the text box is blank, as i would
expect.  What i need to happen is that if there is nothing to lookup then the

to brighten the essence of my current problem I woud like to describe the
situation from scratch.
I use Acess 2007.
I have two tables 'tblOrders' and 'tblOrderDetails' linked as ODBC tables

Hello.  I have a database and form (for work orders) in which I'd like to
create an auto-generated alphanumeric text box that will contain unique work
order numbers - ideally (2007-S001) and will increment by one automatically
when a new work order is entered into the form (ie: ...

Using A2003 with A2k format & ADP (not mdb).
I'm converting an mdb to adp. In the mdb we had been using the following to
export text
DoCmd.TransferText acExportDelim, "ZqryTempForAttyNoticeList Export

Using A2003 with A2k format.
I'm trying to create an export spec. I've done this before but it's been
quite  a while (and probably under straight A2k).
I remember going to the export option and in the screen where you specify

I have tbl Production w/ fields Production ID (PK & autonumber), Date,
Shift , and Department.
I have tblProductionOperation linked to tblProduction on ProductionID.
For any record in Production I can have many records in