Re: Can I disable validation popups in a maketable query.....?

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Sat, 16 Jun 2007 23:02:08 -0400, "Dupatt" <Dupatt@xxxxxxxxx> wrote:

Thank you very much for your help.
I have gone the delete and append route before and it worked well but will I
still get the "scarey looking" delete warnings (some of my users are
paranoid)? I will go back to your suggestion and use it.

Follow Arvin's selection of using the querydef Execute method. Perhaps you
could post your code - we can't see it, and it's more than a bit difficult to
advise.

While I am here I have another question about using the activeX calendar
control. Can more than one date field use the same calendar? Is it
"unacceptable" to use more than one calendar?
Thanks again.

Please ask the question in a new thread - I've never actually had occasion to
use the calendar control. Don't see why you couldn't use two or more but I'm
not certain!

For your other question - please amplify. A Delete query without criteria will
delete all records in the table; the primary key makes absolutely no
difference to that. And a unique two-field index will do just that - ensure
that that particular combination of field values cannot be duplicated.

John W. Vinson [MVP]
.

Relevant Pages

  • Re: 8206 and 8230 on Exchange 2003 SP1 (new server)
    ... Event Source: EXCDO ... If other errors occur with this calendar, ... I get more of the 8230 warnings, ...
    (microsoft.public.exchange.admin)
  • Re: 2 combo boxes
    ... Select the Calendar Control. ... MyMondayDate textbox. ... I haven't considered using a calendar control. ... which would run the query for all entry dates between the monday date ...
    (microsoft.public.access.forms)
  • Re: How to add Date and Time Picker Control to Word form???
    ... Calendar control. ... click on the box next to the calendar control and it ... Private Sub CommandButton1_Click ... the TxtDate formfield, the userform with the calendar will be displayed. ...
    (microsoft.public.word.vba.beginners)
  • Re: Calendar Control
    ... > Calendar Control and then have that date appear in a text box on the form. ... Meyer's site and download a couple of his sample databases that ... MVP Allen Browne has some ready made calendar forms you ...
    (microsoft.public.access.forms)
  • Re: inputting criteria from a form
    ... and today i used your suggestion and added the form i had been thinking about ... could simply click on a date in each calendar, ... to run the query. ... i haven't used a calendar control in several years ...
    (microsoft.public.access.queries)