isladogs

• 

  Solo712

• Sep 26, 2022

Hi, Colin. Just to let you know that I posted a new thread in Sample Databases, Basic User Security. There is one attachment. Please, check it out.
Thanks, Jiri.

C

• C

  ChrisBez

• Dec 29, 2021

Hello Colin
How do I email you, please?
Regards Chris

F

• F

  freuzo

• Dec 13, 2021

Hi isladogs,

Just wanted to thank you for this post.
It is absolutely amazing.

Thank you VERY VERY much !!!!

I

• I

  Ihk

• Oct 24, 2021

Hi,
Want number format into 1st 2nd 3rd etc. I have hidden control on form bound with table, which keeps increasing by DMAX, while the data is entered by user.
I found a post on the link below. My question is where and how to use this code. You were also there. thanks.

number to ordinal list (1st, 2nd, 3rd...)

Hi All, Here's a quick and nasty function to convert a number to it's ordinal representation. e.g. 1 = 1st 2 = 2nd 3 = 3rd etc. Public Function IntToOrdinalString(MyNumber As Integer) As String Dim sOutput As String Dim iUnit As Integer iUnit = MyNumber Mod 10...

www.access-programmers.co.uk

G

• G

  Galaxiom

• Feb 2, 2021

Colin:
I know how you like to test different ways of doing things. I suspect you would like to compare the techniques offered in this thread.

Solved - Access - Counting Letters and Numbers In A String

Good afternoon. I have some data like this: AB12 ABC1 ABC12 ABCD123EF I would like to count letters, numbers, and then letters again if applicable. This would give me: AB12 = 22 ABC1 = 31 ABC12 = 32 ABCD123EF = 432 I am not sure if this something I can do in a query using LEN along with...

www.access-programmers.co.uk

Greg

S

• S

  SalmanZeiad

• Nov 12, 2020

How to make a continuous flash for a record that meets a specific condition in the continuous records form

N

• N

  nishan_gunarathne

• Oct 19, 2020

Hi,

I just need code which hides the Access DB window and only have the open form. I have two more options in the form to which shows a report and one which saves the report as a excel file.

my form name: frmMyTime
my report name: rptMyTime

I use both MS Access 16 64bit / 32bit.

N

• N

  nav786te

• Sep 11, 2020

Hi
Can u please add/share practical example of sending messages to users in access. I have seen 'CheckUser...' database with missing feature.

G

• G

  Gismo

• Sep 2, 2020

Hi,

thank you very much for the solution on the resizeform
this it absolutely amassing

thank you so much for all the replies you assist me with

• 

  NauticalGent

• Jan 28, 2020

Norwegian Blue?!?