Search results

What is the criteria for matching

I have attached a sample which have some table constraints to give you an idea what you can do with them

By the method told by Mr B you can add just one validation for table Access tables support check constraints by which you can add more than one constraints for every column in table in which you can validate data from current table or any other table But this can be done only by using vba (as...

are you storing dates as text

You can alse creat a vba variable and get the value of variable through a function alternatevily you can store criteria in a table and use inner join to show only records for that criteria

You have to use a sub form for pictures

You can use a detail table with one to many relationship for images In this way you have more than one images for any record

you can creat a loop statement for opening same report with ranged records or you can use a select statement to divide records in category of 3000 each and then force new page at end of each group

Use data in a sub report and set column in that sub report

You have to set detail width to show 3 column

can you upload some sample data

Where you are having problem tell some detail

Attached file contains a function to convert the text as you required I have used this in select query you use same function to update your data

you have to validate each field

You can use vba to validate filelds first then if all fields are filled run the macro else display message that all fields need to be filled

It is because the code to open reminders for is on your swithch board transfer that code to the reminders form and then open switch board

Uploaded again

Here is the alternate option without using vba

Where is the combo to which all is addedd

I have attached a sample for you