Search results for query: *

I'm having trouble figuring this one out...i have to conform to a pre written document that has the following structure: Category 1 Category1text subcat 1 subcat1text #products go here in this col# subcat 2 subcat2text #products go here in this col# The problem is the form...

Wow thats awesome.I had some trouble with the dlookup statement (type mismatch) so i tried this(i changed some field names/tables in a redesign :) ) If IsNull(DLookup("courseid", "tblmatchedoutcomes", "courseid=" & Me!lstcourses.ItemData(varItem) & " And compmodoutcomeid=" & Me!cbocompetencies...

ok remou..thats seems to work for the most part.i have some small annoyances.Here is the code i have entered;(apologies in advance for my lack of vba)I have collected this from a variety of sources hoping to make it work.I put the fields and command button on an unbound form. Private Sub...

I am trying to add records to a table that has two primary keys. There are several tables in the db, but the ones of interest are: tblCompetencies with compid and comptext as fields tblCourses with courseid and coursename as fields tblmatched with compid and courseid as key fields I'm new to...

Thanks for the replies. I will check out your code snayjay. Sorry, i'm a bit new to access. And yesdhookom you are right. It is an un-normalized database i have had thrown at me to get some data out. Basically, the database consists of three main tables: tblComptencies, tblCourses and...

Is there any way to suppress checkboxes that are null (or zero) on a report along with their associated labels...and do it so the dead space is removed (i.e. canshrink)