I have a form with student details of the course they are studying. The
form has an ObjectSource of a querry based on two tables. One of the
tables' information will change each semester.
The problem is that every semester, some of the data changes (course

I have a form and subform.
The form shown in the subform varies depending on which button (in the
mainform) is pressed. Each button changes the form shown in the Subform
space.

I have a form displaying data from a customer table. It includes a subform
for phone numbers (stored in a related table). I've figured how to get hold
of the data in text fields, but I'm having a real hard time finding out how
to access data from the subform. My code looks ...

I'm building a where clause with this syntax:
"CNME LIKE '" & Forms![frmLookup]![cboCustName] & "*' "
The Customer name has an apostrophe in it and that's messing up the syntax.
Customer name might be like Sam's Club.

I'd like to run a make-table query from the front_end and make the table on
the back_end.
Is there a syntax to do this?
Thanks.

I am need assistance with this. I have a textbox that contains drive
information between ["G:\\server\share\"] I only care about whats between [].
How can I parse only this info from string?
Thanks,

This code works except if I move to the next record and the grade field
changes in the record to a different level. The text goal field remains the
same as the first record grade level. The txtGoal.text should change
according to the respective case for each record.

I have been trying to bing disconnected ado recordsets to forms with no
success.
I have also found several tricks that address that issue, however they also
did not work.

Is it possible to create a control and plot it on a form entirely through
VBA?
If so, how would you go about doing it?  I'm just trying stuff out since I'm
between projects - but I figure it would be a nice trick to learn.

I'd like to filter a subform from a main form using VBA. I've set up a combo
box control and written code to store the value selected in the combo box. I
am having trouble writing the code such that it will filter the subform. Can
anyone help?

How would I convert this to SQL.  How do you assign it to the textbox?
Forms!ButtonSales!Text40 = Nz(DSum("[Expr4]", "DollDetailsQ",
"Taxed=True And SalesID=Forms!ButtonSales!SalesID"), 0)
Thanks

I have occasional, but disastrous problems with subforms no longer tracking
their parent forms. If you look at the master/child relationship in design
view or through the debugger, it looks fine, but continues to misbehave. I
actually had to edit the already correct values to ...

I have two cascading Listboxes that return a numeric value from a field in a
table.  The code is as follows:
strSQL = "SELECT numOccSecKeyPK, strSecondaryKey " _
            & "FROM tblOccSecKeys " _

In any function where I am using a recordset, I always set the recordset =
nothing when I am finshed. SHould I also be issuing a .close?? or does the
setting to nothing essentially do the same thing?
Thanks,

I am trying to use the API found at
http://www.mvps.org/access/api/api0001.htm to allow a user to browse for a
file when they click the button.
I have created a form and created an event procedure. used code builder and