I am facing this trouble becouse the template on MS-Access named "Services
Call Management" has a bug.
They have not prevent the caos when a customer returns and you add the same
customer on Customers table each time he returns and the same customer gets

Hi to everybody,
Could someone please give me an example on the
LinkMasterfields/Chieldfields property, because the Access
help doesn't provide one.

This is probably pretty easy, but it has been a while since I've used Access
2000.
I have an unbound textbox on my form that is pulling data from a table.  I
want to bind that textbox to results from a sum query that uses a serial

I am trying to use late binding techniques to open Excel, load it with data
and format the data.  I am using Set xlApp =
CreateObject("Excel.Application") to create the instance of Excel, but having
problems with the excel properties.  For example:

I have a form with felds from query named select code so when form/query
opens a msgbox appears requesting code to be entered in form I have also
wriiten a on load event to sort data etc and a afterupdate on field issue to
enter date in dateentered field these all work but I need ...

One of my tables includes the following two Yes/No datatype fields:  Draft,
Final.
When I place these two fields on my form, I want to enclose them in an
option group so that only one or the other may be selected.  I tried using

This could possibly have been posted to the devtoolkits list, but I thought
I'd try here first -----
I have a form in an app that I have distributed the has some cells with
conditional formatting.  Application built under Access 2K3, using 2000

In my Form, I have a field that is based off of a field in a table called
"comments" which is set to memo. Inside the form, I cannot add information.
When I try to type, it beeps.
What am I doing wrong?

Here is a strange observation about quiting Access 2000.
If you have code to run in the Unload or Close events
of the main form (switchboard):
(a) Using the Access menu Exit or window "X":

I have this code:
   Dim mySQL As String
   Dim myCombo As Control
   Set myCombo = Forms("person2").Controls("cboNameSearch")

I been trying to see if it's possible to resize the Access window so I can
hide it behind my form.  I would like to do this through VBA.  My form is a
popup.
Is this even possible?  Thanks

I would like to create a command button that will send an
email to a group of everyone returned from a query
(i.e. "Active Students).  (The contact form includes a
field for email addresses).  I'm sure this is something I

I am trying to filter a form by a combobox, the combobox has a date format
of mmm yyyy, I am using the following with no luck
Me.Filter = "[date] = #" & Me!Combo47 & "#"
Me.FilterOn = True

Thanks for taking the time to read my question.
I have a form that I want to filter. I want an option box to control the
filter.
When the form opens I would like to build the option box and have as many

this code below almost works
Private Sub Patient_Number_BeforeUpdate(Cancel As Integer)
If Me.Dirty = True And Not IsNull(Me.Patient_Number.OldValue) Then
If vbCancel = MsgBox("You are about to change the ID Number of this Patient