Search results

Sorry.. Have a simple relationship/database design question, I sure someone can help. I have a table that is essentially Read Only and cannot be changed. I need to add another table that has some check box options for the items in the first table. I want to display all the items in the first...

Thank you both for your replies... works perfectly!! Just didn't think of enable/visable option. cheers for your help

Hi, I am developing a form that will have 10+ checkboxes to track completion of some tasks. The tasks should be completed in order (1-10). I am trying to find an easy way to check that the tasks/check boxes are completed in the correct order (1,2,3,4,5 etc) and then produce a message if...

Have a small problem (and probably very simple!) with a database im putting together, hopefully someone can help. I have a main form and "tabbed" form. When I change the record on the main form the data (6 yes/no fields from the same table) on tabbed form does not change to reflect the...

Hopefully someone can help me with what is probably a simple problem. I have a form where the user looks up products with a Combo Box, the data is derived from a product "look-up" table (part no. description, retail price etc). This information is then stored in another table to show sales...

Thanks for your quick reply. I tried the Nz Function but it still doesn'e seem to work. I have one particular record that has a number of Nulls which will not display when all combo boxes are left blank! If I update the record in the table to non Null values then of course all is OK. Doesn't...

I have a query that is linked to various combo boxes. The Query uses the Like statement to allow wildcards in the data entry eg - ((FiatBoo.[First Name]) Like ("*" & [Forms]![FiatBooSelect]![cboFirstName] & "*")) This works great if the record contains no Nulls. Am I correct in saying that...

Im a bit of a newbie, so please be kind... Have created a form with 2 Combo boxes (Member & Surname) which are linked to my table. Have also created an OK button to call up a Query with the values selected. The Combo boxes seem to work OK (correct info) I have made sure that the criteria...