Search results

Thanks Gasman....i've been asked to make the image open to about half the screen size so i don't really want to make it bigger. Could i create a separate form to hold the image ?....i could then control the size a bit better. Although i'm not sure how i would get the different images to load in...

Thank you i'll be looking into everything if i can't get Access to do it

Yes the black area.......i just want the image on it's own. I think the default viewer is Photos....can i tell Access to open it the way i want it ?

Hi Everyone, I have a command button which i need to open an image. Is there a way i can get the attached image to open and display just the image itself without the black border area ?. I've tried cropping it but makes no difference. The code i'm using in the OnClick event of the command...

Hi Gasman....i'm sorry i've been off work for a week with friggin covid. Thought we were done with all that. I just tried your file and i'm still getting the same error when i try to use the filter ?

Thanks Josef......i know what you're saying but i didn't edit the modules at all as i wouldn't know where to start. Maybe this is causing the issue ?

Hi All, The file i uploaded is not the exact one that MajP sent me originally. That one works fine and is not the issue. The file attached above is one where i tried to implement MajP's code myself....i need to be able to do this if i'm to use this code in future projects rather than the...

I can't understand why these references are unticking themselves ??. You can see from the screenshots in post 22 i had them ticked as you recommended

Alright here's a version that doesn't work. Maybe you might notice something

I created a brand new database and imported everything from the non working file. Did a compact and repair and even compiled it but no luck. Also tried the long shot with the priorities but still nothing. I think at this point it'd be unfair to ask anything else of you MajP so thanks again for...

References from the non working file on the left

This is my version of Access Microsoft® Access® for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20764) 64-bit The reference you mentioned wasn't actually ticked so i fixed that. I ran the compiler again and got no more errors. I also did a compact and repair for good measure but still...

Ok so the compiler stopped at the error message attached

Yes i see you changed it to a combo box....probably a better idea than leaving it for people to just type in. I've tried to use your code in the existing database but i'm getting that error again. I've imported the two modules, used your 'No criteria' query and add the =filterList() command to...

I checked that reference and it was ticked on my list also. The debug and compile showed nothing. So, i sent the file to a colleague and it worked on her computer. I decided to do the tried and trusted 'Restart the computer' solution and it works perfectly now. Just as well, i was about to fetch...

Ok i deleted and re-downloaded the file but error still happening. It's actually occurring when i use the other criteria also and not just the dates.....very odd

MajP......thanks for the updated file. When i enter a date in the first field i get the error message below ?

Thanks again MajP. I've attached a stripped down version of the database.....had to delete quite a lot of data for the usual reasons sorry. I think there's still enough there for you to see what's going on. The form with the search function is called frm_SearchMulti I need the Date Reported...

Thanks MajP....i had a look at the thread and the example. Very impressive work although a little complicated for a novice like me. I'd certainly be willing to attempt it in a future database but not sure i could swap it for my current method in this project. I'm a little confused as to why you...

Hi All, I've used the code in this thread for searching my databases quite a bit and find it excellent. https://www.access-programmers.co.uk/forums/threads/dynamically-search-multiple-fields.188663/ I was wondering if anyone is familiar with it, could you tell me is it possible to add a...