I have  an unbound form with two subforms : SbFrm1 and SbFrm2.
These two subforms are bound forms, so have their own recordset, e.g. :
“select * from tblTable1”   - recordset for SbFrm1
and

This apparently is a common problem, but I can't quite grasp the
solution.  In creating a form and subform (nested relationship), I
foolishly tried (being a beginner in Access forms, though I do have
some newbie experience coding in C# for dBs and know how to write a

Hi again All,
This time I come with a question that maybe sounds strange.
I have 3 textboxes on form F1,let say TBL and TBH their data
type are numeric and also TBN with text data.Sample record.

On an access form I have a textbox which I need to countdown how many
characters are available taking the length from a 100. I have put the
code in the textbox keypress event.
It updates on the first key press but subsequent key presses do fire

My subform tracks when personnel are dispatched, arrive, etc., to different
events.  My main form tracks the first times for dispatch, enroute, arrive,
and the last clearing time.  The subform shows the complete history for a
specific incident, tracked by a unique sequence number ...

where can i find start up option in access 2007

I have this code that works very well, except I want to send the contents of
a small report in the body of an E-Mail.  Right now I'm transferring the
report to a txt file, works fine.  How can I get that to the body of the E-
Mail?

I want to monitor how much vacation time a person in the office has but we
all accrue it at different rates.  A person that has worked for the company
for less than 5 years earns 2.5 hours per pay period, 5-10 earns 3.7 and more
than 10 earns 4.7.  Can I create a “LookUp” table ...

Is it possible to change the size of the text box (or any other control) on
a form at run time, by Drag and drop or resizing borders using the mouse
events. (Just like the design mode but the user will use it at run time on
form view).

I'm writing an if statement but having trouble with brackets,
parentheses, and commas.  Anyone know of a source document that can
help me write if statements?

how can I restore deleted object in access 2007

MVP
Should find answer
I 'm working on form and pressed delete 3 times (three forms deleted) in
navigation pane (No message box appear like previous version access 2000 and

OK forget my earlier post about inserting PNGs into OLE fields.
(even just using OLE "Links" there's just too much filesize inflation.)
The usual trick of storing filenames for images and displaying them in an
unbound image control is now what I need to do.

This discussion group provided the code below that works wonderfully.
It takes a number from a text box that user has entered, searches for that
number in the first column of the listbox and then Selects it.
The problem is the Listbox has about 300 records so, if for example the

thank you
how can i hide navigation pane and ribbon by code in access 2007
=============================================
in previous version i use this code