Is there a way to refresh only the sub form and not the main?
I tried forms![subfrmname].refresh and it says it cannot find subfrmname?

I have a 60 something row by 14 colums spreadsheet in MS Excel 2003.  When I
try to use it as a merge data source in MS Word 2003 it ignores all but the
first 49 rows in the spreadsheet.
----------------

Hi Everyone.  I have a database for tracking audits and one table has basic
information about the audit - reference, business, dates, auditors, etc - and
another table in which I hold the risks / recommendations.
In the second table, I have a field which mimics the reference ...

I need assistance in forcing the creation and entry of a new child record (2
fields: ID and Text field) upon the entry of a parent record. I'm working
with an MS Access form and subform. I have a statement that creates the child
record with record ID, but I can't get it to force ...

When the mouse stop over on the label or control text, few seconds later
shows the control tip text.
Is it possible to show the controltip text quickly? I mean, when the mouse
move over the label, shoud be show control tip text.

I am not sure what F key to use to step through code?

I'm looking for a possibility to expand a subdatasheet not by a
click on the expand indicator ('+'), but by a keystroke.
I'm also looking for an event I could react when the expand indicator is used.
Can anyone help me please.

Is it possible to use Access and MS SQL 2005 Express?
reidarT

When i try to run the following code I get this error message
Compile Error
"Can't find project or library". StrConv is highlighted.
********

I have the following code on my form to delete the current record.
Private Sub cmdDelete_Click()
On Error GoTo Err_cmdDelete_Click
DoCmd.RunCommand acCmdDeleteRecord

if record isn't found the whole form goes blank.  Is there a way I can keep
this from happening, say with a msgbox "file not found" ???
Thanks!
Troy

Hello.  I have a basic Access form in which I have a ComboListBox that
displays a persons name in "LastName, FirstName" format from a table called
Patients.
What I want to be able to do is pull 3 other attributes from the record

Hi all! And thank you in advance for your help.
I know it's probably not the accurate group to post this question but I
could not find any other.
Can anyone tell me if it's possible to have more than one conditional

Hi Experts,
A2000, multiuser, FE/BE database. I would like to design a form with the
intention:
When a backend record's (a company record) form is opened

I have a form containing 3 Comboboxes, each drawing its contents from the
same table but using different criteria and different sort order.
Is there any way to have all 3 ComboBoxes dropdowned at the same time so I
can see their entries all at the same time and then beeing able to ...