Search results

Normally I go to advance search type * as keyword and select a date. It gives me all the post from the date I'm searching.

How many of this count was from watercolor, politic and other not technical sub forums?

I use the following to find out the last inserted PK: CurrentDb.Execute sql SN = CurrentDb.OpenRecordset("select @@identity")(0) Edit: Sorry I didn't notice @Pat Hartman had already suggested the same way.

Why? Is there any article for studying about it? I had no luck with google. Thanks.

Welcome to AWF

And no JP.... :(

You can open a form in Access with rounded corners if you like. https://www.utteraccess.com/forum/index.php?s=&showtopic=1956294&view=findpost&p=2063723 Or a more improved version here: http://access.mvps.org/access/forms/frm0053.htm

Maybe it's better to delete my posts to prevent confusing other members.

Now that I think more carefully, it may be my side problem. My Locale in control panel is set to Japanese. And I had at least another problem with a download here. Everybody was insisting the file is OK, but it didn't work for me. So this may be another instance of the problem caused by Windows...

this is the label and its Format property sheet. Edit: The property sheet belonged to the form. I updated the image.

I've already shown it in #18 post. I'll upload another one in design view in a minute.

Changed the font to Courier New. Still the same. Changed the font to Consolas . Still the same. Note: It seems it's because of the space you've used between letters. If I delete the space between letters, it works.

I didn't use any font. I simply opened your form in sample file attached in #17 Edit : to be sure, I opened the form in design view and changed the font to Courier New. Still the same.

If you start clicking from A, your sample file works until letter H The letter I doesn't filter the listbox. From J it filters the previous letter. J filters I, K shows J etc. Once this happens, nothing filters correctly anymore. This is what I receive after clicking Y.

Welcome to AWF!

@cheekybuddha Million thanks

Unfortunately Office 365 says it can not open this file :(

You may want to go through this post: https://www.access-programmers.co.uk/forums/threads/android-or-iphone-which-one-do-you-choose.311601/

I’m not sure if this satisfies OP or not, but for me a technical/non-technical filter would help. Apparently watercooler, politic etc goes into the nontechnical one.

It seems that my phone was waiting for a restart after a security update. After the restart, now I have the floating button I was looking for. I sincerely thanks for all inputs and sorry for not testing my phone before help request.