•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 374,198 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,614 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser:
Views: 2864 | Replies: 1
![]() |
•
•
Join Date: Apr 2005
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Hi Everyone,
I want the user to select via a checkbox for which employees to print a report.
I understand that on a continuous form checkboxes need to be bound to an underlying field.
I want the boolean field bound to the checkbox to reside in a WORK table, that is on the front end mdb.
I'm having trouble with the SELECT/JOIN:
a) Have 2 tables: LOG and WORK
b) The LOG table has as its last column: an autonum field,
that would relate to the WORK table's primary key.
The WORK table's fields are:
ForeignAutoNum Number Indexed-No duplicates
RowCheckBox Yes/no
c) I linked the tables using Tools/Relationships
The LOG table has rows. The WORK table is empty.
Hoped for sub-goal when viewing the SQL JOIN query results set:
===============
When clicking on checkbox in the query results set:
the checkbox would be populated -and-
the associated automnum from the LOG table would be
populated in the query results set
so that if I would open the WORK table, I would see a
record with both fields populated.
Problem:
=======
The sql query below displays the correct rows, EXCEPT:
Getting the following error, when trying to click into a
checkbox, that is included in the results set of a query.....
" cannot enter value into blank field on 'one' side of outer join"
Any ideas or guidance or URLS would be so appreciated....
thank you so much in advance, Sandra
I want the user to select via a checkbox for which employees to print a report.
I understand that on a continuous form checkboxes need to be bound to an underlying field.
I want the boolean field bound to the checkbox to reside in a WORK table, that is on the front end mdb.
I'm having trouble with the SELECT/JOIN:
a) Have 2 tables: LOG and WORK
b) The LOG table has as its last column: an autonum field,
that would relate to the WORK table's primary key.
The WORK table's fields are:
ForeignAutoNum Number Indexed-No duplicates
RowCheckBox Yes/no
c) I linked the tables using Tools/Relationships
The LOG table has rows. The WORK table is empty.
Hoped for sub-goal when viewing the SQL JOIN query results set:
===============
When clicking on checkbox in the query results set:
the checkbox would be populated -and-
the associated automnum from the LOG table would be
populated in the query results set
so that if I would open the WORK table, I would see a
record with both fields populated.
Problem:
=======
The sql query below displays the correct rows, EXCEPT:
Getting the following error, when trying to click into a
checkbox, that is included in the results set of a query.....
" cannot enter value into blank field on 'one' side of outer join"
Any ideas or guidance or URLS would be so appreciated....
thank you so much in advance, Sandra
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Similar Threads
- Forms in Random access files (Visual Basic 4 / 5 / 6)
- html checkboxes... (PHP)
- Forms authorization, only want a few links (ASP.NET)
- Identification of Web Forms (ASP.NET)
- Hotmail and Submitting Forms (Web Browsers)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: tables please help
- Next Thread: Add a name in the TO: address with code



Linear Mode