Search results

you can also create a Public function in a Module and called it as Criteria on your Query. In a Module paste this: Public Function fnCriteria(ByVal fieldValue As Variant, ByVal txtBoxValue As Variant) As Boolean txtBoxValue = txtBoxValue & "" fieldValue = fieldValue & "" If Trim$(txtBoxValue) =...

you do this same Criteria with Field02 and Field03: Field01 Criteria: Like "*" & Nz([Forms]![IOListNavForm]![NavigationSubform].[Form]![txtCriteria1], [Field01]) & "*" Field02 Criteria: Like "*" & Nz([Forms]![IOListNavForm]![NavigationSubform].[Form]![txtCriteria2], [Field02]) & "*" Field03...

cross posted here: https://www.accessforums.net/showthread.php?t=90659

cross posted here: https://www.accessforums.net/showthread.php?t=90657

you can also try (for Field01): Like "*" & Nz([Forms]![IOListNavForm]![NavigationSubform].[Form]![txtCriteria1], [Field01]) & "*" put the same on the other 2 fields.

do you think there is a missing line on your excel sheet. here is what i get:

fo include all months, do not add filter to the month field.

can you show us what are the codes in your "delete" button. are there any code you are executing when the db closes?

here is another demo. the original code from LPurvis and extended to use separate form for Adding/Editing record. main form is called Products.

there is a sample Appointment calendar here: https://www.access-programmers.co.uk/forums/threads/another-simple-appointment-calendar.330020/ which can be modified for sick leave monitoring.

what i mean is when you distribute the db, the images are prone for deletion on the client side.

not portable and prone for deletion of the images.

i think it is propriety, company won't allow.

standard icons are small (see again his image on the Tabs), you can't (maybe i am wrong) make them any bigger.

sorry, but cross-posted here: https://www.accessforums.net/showthread.php?t=90649

plus the Type field, will be the easiest to construct. just cross joins your table.

unfortunately, that is not correct. the Imported images are stored in MsysResources. If you already made same buttons before, so what is the point raising your questions? Just to show-off?

the button you showed has images not in MS Access so you will import the Images anyway.

you can create an Image in photoshop and save it as bmp (png, jpg, etc). and use it as a button. or use the image and Overlay it with transparent button.

don't be surprised if they drive you away for ransom:(