I would like to have a calender pop-up in order to fill in a date field.  Is
this possible?

I am having trouble using the tab control.  When I copy the fileds from
my original form, which is not on a tab, to the tab, it appears on both
tabs.  So when I switch, the same info is on both tabs.  It seems like
the two tabs pages are actually one.  Any suggestions why this is ...

I have created a switchboard, and when I try it out there is only one button,
and I get a message box stating: "There was an error reading the Switchboard
Items table".  The heading for the button on the switchboard reads: "There
are no items for this switchboard page."  I have ...

Is there a way to add additional text to the prompt window that is created
off of a query (aside from the [Question you enter in the criteria?]).
I have a button on a form that when clicked, prompts the user for criteria
(i.e. Enter category).  For convenience, I would like to add ...

Hi I have posted this several times and got some good suggestions, however
whenever I try them Microsft access is looking for a macro. I update the
issue but they are not seen so I open another one as I am doing now.
Any suggestion would be appreciated

I have a query that asks for a tag number and then looks up and opens the
correct record. I would like to display a message if the user enters a tag
number that is not valid, but I don't know how. I think it would probably be
in an event, but I don't know which one and I'm not ...

HELP!!  I have a subform shown in DataSheet View based on query "A" where I
am trying to code among other data elements, a combination box on the subform
based on a different query (call it "B"). Query "B" uses data from Query "A"
for criteria purposes.  In another words, I only ...

I hate the syntax requirements on these stupid things...
Can anybody tell me what is wrong with the following:
=DSum("[QuantityRevision]*[UP]","Quantity Adjustments","[SCO] = -1 And
[PCOFinal] = 0 And [Group1D] Is Null " And [ContractID]=" &

I wrote and maintain an Access 2000 applicaton which uses SQL Server 2000 as
back-end through ODBC linked tables.
As I make changes to the objects and the VBA code in the client, the size of
the mdb file tends to grow, even though I compact on close.

I'm trying to create a query for my library database that will return
[Organizations]![Abbrev] when [Authors]![AuthurNum] is null and otherwise
return [Authors]![FirstName] & " " & [Authors]![LastName].  I've tried every
combination with parentheses and commas and spaces, but I ...

I am working with three tables. Dept table has two columns: DeptKy (PK)and
DeptCode. Unit table has three columns: UnintKy (PK), DeptKy (FK), UnitCode.
Product table has eight columns: Barcode (PK), Dept, UnitCode +5 other
columns.

Here is an oddity I have had happen in the last couple weeks.  I have a form
that allows an employee to select a department from a combo drop down box and
run a report to see who has trained there.  In the last couple of weeks,
sometimes the dropdown box will not show anything ...

I have a form that when I enter information into the last field, I would
like it to automatically move to the first field of the next record, BUT I
would like it to move as soon as the user enters all 6 digits without the
user having to hit enter or tab.(only 6 digits can be ...

I am wondering if there is an effective way to have a list of controls
that can be grouped into 1 name. Simply, I have lots of buttons that
affect the behavior of the same group of controls, and it would be nice
to be able to do something along the lines of:

I have a form that has a FK in it but it isn't populating. When I go into
frmApplication and click in children subform on the command button ""Answer
Child Questions". It opens another form that I try to put in a response to
the first question. It won't let you move on to the next ...