Search results

Hi, I have a form that is filtered using a query & applyfilter. I want to use the same filter for report (to match the same to print) DoCmd.ApplyFilter "EmailPasteSearch" The form is filtered perfectly as expected. in the EmailPasteSearch Query the criteria is Like "*" &...

Hi, thanks for the advise, might try the Listbox solution but on a bit of mission at moment, just trying to understand why I can't get this to work, slightly different approach from my first attempt. but bit of a mess below but perhaps someone might be able to get the gist. I have a combo which...

Hi, I have a combo box with ID (Hidden); surname/code ; firstname Smith/A Abbie Smith/B Bobby Smith/B Bernie Smith/B Biff Smith/C Charlie I type Smith/B, enter (without selecting with mouse or cursor down) I would like it to NOT save the selection until I cursor down or Mouse click...

Hi, perhaps an odd way round but this is how I have done this for years but trying to tidy a few things so no fundamental changes combobox : ID hidden 0; id surname name 1 Jones/B bill 2 Jones/B baxter 3 Jones/B bonnie 4 Jones/C cleo 5 Jones/C charles I type jones/b. It auto...

It is actually a query that I am applying as a filter, quite complex so a query was easiest. What I have found is that if I put the apply filter in On_Exit as opposed to after update it does work, I would prefer update but that is fine. Causing a slightly different issue I am sure I can easily...

Hi, Did not explain myself very well, the filtering is fine, work exactly as I want, It is actually just entering the new search text into the text box that is annoying. I want it to highlight what I have just typed, so I can quickly retype something else. Should be such a simple easy thing...

Tricky to explain but spent ages on this & should be simple but can't work out. Have a text box I use for searching. but after pressing enter to search I want it to highlight the existing text ready to type over the top of it without using delete button. Basically type e.g. JONES if result are...

Office 365. Window 10. Not aware of any windows or office updates. start my database MyDatabase.accde /runtime BE on networked computer. Hi, Over a week ago my database just would not start. I can't remember the error but something about using a different version &/or not having permission...

I started this post & generally happy with using the code (in fact prefer) however what I have noticed on a few of my PC's I use a marble trackball. This does not seem to be picked up in the code so tries to scroll the windos as before but as we now know with its bugs it does not work, just...

What I have just noticed is the the scroll bar on the side does not work anymore. Click on box with mouse (not using wheel at all) and drag down. The little box moves & stays there, saying record 500 of 1000 etc. but the main window does not move. The second I scroll with the mouse or using <<...

Many thanks for that, I had wondered if there would be a way to code but my initial feeling was it would error if trying to jump more than 1 record past eof or bof but of course would simply be caught via error handling. I also did not realise the Count picked up the mouse wheel count so well...

Yes, this code is actually from MS https://support.microsoft.com/en-gb/help/2458709/you-cannot-use-the-mouse-wheel-to-scroll-through-records-in-an-access

Really Odd it should just do it now without any warning. My win 10 system restore took me back to ...2103 and all working now. Office update says I am up to date so don't know when/if it will take me back to 8326.2073 but I guess at some point. It did work exactly as described in MS advise...

Hi, Thanks for the info. Mine was Build 8326.2073 but think must have been updated at that time & I know I had done a restart yesterday evening around the time I noticed it had gone strange. I have just restored back to a few days ago (why is there only 1 restore point in W10?, I have plenty...

Hi, Office 365, access 2016. Been using scroll wheel for years to move through records in numerous continuous forms. Just this evening at some point this stopped working. Fine in other office programs, excel, word etc & browsers & everything so mouse OK. Had above office for over a year...

Many thanks to you both, I managed to get all I wanted from Ridders, but Ashleedawg code looks really clean & nice Got it working really well. Many Thanks again.

Hi, Many thanks for that, clever & looks interesting. In all my years never used a union query so going to have to learn. My only initial unskilled thoughts are the fields have to be the same, my 3 tables are very different apart from the ID, they are like lookup (they are not lookup tables)...

HI, Sorry title not very informative. I should be able to solve the following but just can't get my head round. Would be fine if just 1 linked table but as I have 3 below struggling. I have booking reservation system. I am trying to get a list of clients that have NOT contacted me by one of...

Hi, Follow up to my previous, it seems I have missed a very fundamental point that I was not aware of in all my years (Idiot) I thought that Me.Recordsource was changed perminantly. I realise now it gets reset when the form closes or I guess when is loads. That does make life a lot easier, I...

Hi, Thanks for your reply No, I am now trying not to change the record source, I did like the way it works & had everywhere but whenever I make fundamental changes in design view I then have to be extra careful that when resetting back to default/original afterwards. I might re-think back to...