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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry about not giving you code to see but I am on my home computer and my
database is on my work computer.
You have answered my questions to my satisfaction, so thank you again, and
goodnight.

--
Pat

"If you can find a path with no obstacles, it probably doesn't lead
anywhere"
"John W. Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:s2d9739fj1qsb1lnl2h4lg3mho659f7nhr@xxxxxxxxxx
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: Sync Calendar with Two (2) PCs
    ... Mine syncs with my home computer and work computer and the calendar items ... tell, this was possible in ActiveSync 3.8, but it is no longer possible ...
    (microsoft.public.pocketpc.activesync)
  • Re: 2 different networks at the same time?
    ... When I left clicked on My Network Places on the work computer, ... eventually the home computer appears in the shared ... and I could view the files in the shared folders on the home ...
    (microsoft.public.windowsxp.network_web)
  • Re: 2 different networks at the same time?
    ... I've created an administrator account ... on the home computer with the same name and password ... as the account on the work computer. ... beyond running the Network Setup Wizard. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Date picker scrollbar month and year only
    ... when I click on the calendar control for Period Covered (want month ... not in the userform module): ... Private Sub CommandButton1_Click ...
    (microsoft.public.excel.misc)
  • Re: NoMachine setup
    ... The Work Computer, configure the login windowwith host IP (your ... Check every couple of days to see if your home computer ... custom port number I have SSH running on. ... And finally there are no setting in Nomachine that have to be change on ...
    (Fedora)