No - I havn't mistaken this for womencentral :) ..
Here's my deal. I have to create a database with multiple levels of relationships that resemble a tree structure.
Level1 - tree1 -
Branch1 Branch2...
If you use a datacombo instead of a combo box you have the opertunity to set both a datasource *and* a recordsource. You could set your datasource to be your adoprimaryrs and the boundcolumn would be staffno. This will save your staffno in memory. Then set your rowsource to be your adostaff...
Try doing a response.write on your SQL code and see what the actual query looks like. It seems like you aren't passing down something that the DB wants.
Michiko
How about using the mid function. Mid(expression, start, length). So you would put your expression, the character you want to start with, and how far over you want to go. The following assumes that you are starting at character 1, but you could start anywhere in the string.
Example:
if...
I have an Access 97 database with some null values in date/time fields. I have databound my date time picker controls to a recordset, and set the datafield to the date/time field in my table.
When I pull the record, the dtpicker has no problem with bringing in a null. The problem is when I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.