Form “frm_A” has a sub-form “sfrm_A”.  Both are bound to tables with the
usual one:many relationship.  Form frm_A lists customers.  Sub-form sfrm_A
lists their transactions.  Both frm_A and sfrm_A have navigation bars
allowing customers and their transactions to be viewed and ...

I have form that is open by clicking a button, would like to have the form
maximized.
Following is the code:
Private Sub f0_ich_Click()

Could anyone tell me if its possible to delete an object such as a table,
form, query etc in another database, and if so how is it done?
Thanks for any help.

I discovered that if i set format condition to control in form it will also
apear if i am on datasheet view.
The problem is that i have many contros that are checkbox which cannot have
format condition property (as far as i know). and when i present the data as

I have a suborm control that I sometimes switch it's source object between a
form and a report.
Is there a way to test the subform control using an IF or CASE statement and
determine whether the subform is containing a form or report type?

I am trying to set the backcolor of a textbox in Continuous Forms view
uniquely for each record displayed on the form.  When I set the color in
OnCurrent Event Handler, the color changes for that field for all records on
the display.  How can I change each record individually?

Hello all... im trying to get to my RecordSetClone of a form, so if someone
is looking for a certain record it can show up on this form without having to
do tons of Dlookups and stuff. I did a little research on RecordSetClone but
still can't get it to work... here is my current ...

I'm trying to use an "Instr" test with a case statement. Is this possible?
In my code below, I'm trying to test the first 2 characters in a string and
determine if the string begins with "f_" or "r_". Can someone take a stab at
my code? It returns "unknown" instead of "f_"?

Is there a way to have a subform collapse programatically in the afterupdate
event of one of its fields?  Also, how do I set the focus to a subform field
when the form is expanded?  
Thanks.

I want to write some VBA code for an Access 2000 database app that checks the
value of the 5th character in a 6 character string. I used to know how to do
this, but my brain has turned to mush and I've failed to find anything useful
in the online help.

I wish to add a command into my access database which will scan an image,
create a  path location for the in a form, and store or recall that image at
a later date. Is there a way to do this?
Sincerely,

    I have a form class module that uses the doCmd.RunSQL statement.
The first two work, but immediatly following in a call to another
subroutine I have a disconnected recordset that is updated with new
records and finally a rsSummary.UpdateBatch statement.  The new

I have Access 2007 on XP in addition to Access 2003. I created a small new
database but non of the events seem to fire up. I tried before or after
events as well onfocus etc. Any suggestions?

In the RowSource of a combo box that uses fixed
text strings per line, how does one specify a quoted
word?
Example:

Can anyone tell me, if using Access 2003, you can change the picture on a
command bar button to a bitmap .jpg etc. other than those provided
internally?  I have searched long and hard to no avail.  I am open to
alternate suggestions on how to accomplish this task by other means.  ...