Can anyone please point me in the direction of a good example/tutorial on
how to use a combo box which is dependent on the value in another. i.e. I
have combo box labeled cboFocus which looks up Literacy, Numeracy etc and I
want the second combo cboTarget to lookup values ...

I have a notes subform that lists all the notes that are associated with the
main form.  I have a text box (txtAddNotes) that I would like to use to add
notes into the subform.
There is a date field and a notes fields in the sub form and I would like to

If I change the replicated backend database structure - add/delete fields or
add a new table should the db.synchronize function which is run from the
front end non replicated database capture all the changes and pass them to
the backend replicas. I seem to have some issues that ...

I've read the posts about Credit Card Procesing in Access.  I'm not planning
on storing the numbers in Access.  I just want to process credit cards using
my Access interface and a third party software.  The posts that are out
there seem older, so I was wondering if anyone has any ...

I continue to strugle with how to obtain a control name and then take some
action on it when its not the current control.  Can anyone point me in the
direction of how to obtain the control name of a field?  If the below code
makes sense, I want to test 2 fields and if they have a ...

How could I created an icon for the FE database shortcut or link
(different to the standard MS Access icon). Thanks in advance.
ST

If Me.Dirty Then
              Me.Dirty = False
Please help me understand the above snippet of code assuming a single
form.

How can I replace a query in another database.mde?
I have in C:/Test/database.mde
I want to replace a query "qSales" in database.mde from another mdb or mde.
I am thinking along this line

On a search form, a user can enter a last name in a (unbound) text box
(txtLastName) and see a list of matches in another (unbound) text box.
It does this with an OnChange event which generates a SQL statement.
Basically …

Hi All,
I wrote a query and am using that to populate a report. The user is prompt
to enter three different criteria. One of the criteria is asking the user to
enter in the Revision code for the part number. The revision code should

I am trying to set-up a command button on a form to take data in two unbound
textboxes and store them into a table. The following is my code from the
click event. I must have a syntax error or ?
Dim strSQL As String

Thank you in advance for any help or advice. I'm trying to do something which
shouldn't be too hard, but has me stumped. I suspect it has something to do
with where the code is placed. In case it matters, I'm using 2007 to design a
2000 file format.

I am able to use following code to access my shortcut menu to set
enabled to false.
CommandBars("Meeting Activity").Controls("&Update").Enabled = False
I just add a new level "Meeting Case", because popup menu is too long.

I used database to split in to front end and backend application and
just realized that the backend does not carry table relationship.
Is it true that I need re do all the table relationship using database
splitter?

I am trying to write code, but having trouble with one part.  When my form
opens, I want to run some code to see if there are any missing/mandatory
fields and if so I am going ot highlight them and advise the user to complete
them.  I am using  select case which will list the ...