Re: dynamic check boxes

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Tina...
working hard, even though I minimized variable name changes. Was careful to
change names in SQL & VB Code. Unfortunately this problem exists on closing the
main form:

Private Sub cmdClose_Click()
DoCmd.Close , , acSaveNo
CurrentDb.Execute "DELETE * FROM tblAttendees WHERE aPresent = False", _
dbFailOnError
End Sub

Displays a compile error "variable not defined" (dbFailOnError). Suspect this
close event is what filters the report for only attendee volunteers, as when I
preview a sample report, ALL volunteers print out, even tho only 3 checked.
On your demo...the close event runs fine. So what's up?


--
All the Best
Richard Harison
"tina" <nospam@xxxxxxxxxxx> wrote in message
news:ew5of.156304$qk4.19564@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> you're welcome. :)
> the "key" to how the setup works is in the tables' primary and foreign key
> fields and the table relationships. if you study the demo forms to
> understand how those fields/relationships are utilized, you should be able
> to "translate" the setup for your db, using your own table/field names.
>
> hth
>
>
> "Richard Harison" <noway@xxxxxxxxxxx> wrote in message
> news:u6jE$pOAGHA.532@xxxxxxxxxxxxxxxxxxxxxxx
>> WOW!
>> Thanks so much Tina. I had a hunch that a many-to-many relationship was
> in the
>> works somehow! My final problem now is to replace the sample volunteer
> table
>> with the real one, which of course has its own field names, which I cannot
>> change without disrupting the entire database. (the query, SQL etc.)
>> So thanks again for your valuable help!!!
>>
>> --
>> All the Best
>> Richard Harison
>>
>>
>
>


.

Relevant Pages

  • Re: Full text search not giving any results
    ... You're welcome, Sirisha, ... Full Text Search Adobe PDF files stored in SQL Server... ... SQL Server 2000 Full-Text Search Resources and Links ... > FOREIGN KEY ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Hypersonic SQL and foreign keys
    ... I've heard that Hypersonic SQL doesn't support foreign keys? ... > is a bit confusing. ... I can't tell you about Hypersonic's foreign key support, but your SQL is a problem. ... > username. ...
    (comp.lang.java.databases)
  • Re: Timeout or other timing-type problem???
    ... In your place I would trace the sql statements issued to sql server, either log them from code or even better, log them using sql tools. ... The INSERT statement conflicted with the FOREIGN KEY constraint ... How do I ensure it is exact? ... Here is how I'm establishing my connection and setting up my ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: FK to a view?
    ... To derive practical benefits, in a relational ... Since a view in SQL is not fully ... implemented in accordance with a view in relational model, ... create a foreign key on a view cannot be provided in SQL. ...
    (microsoft.public.sqlserver.programming)
  • create new records from udate query
    ... I have a database with several peripheral tables that ... relate back to a main 'Volunteers' table. ... the 'design view' rather than 'SQL'. ... VolTraining.Description = "Volunteer Reception", ...
    (microsoft.public.access.queries)