Hi Steve, following on from my demonstration a couple of weeks ago, I've just put up a .accde which allows users to treat a continuous form a bit like a datasheet in that they can resize and move controls around. If you are interested, here is the link https://www.access-programmers.co.u...-and-reorder-columns-like-a-datasheet.320624/
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.
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...
Hi @mresann
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 your post on the link below. My question is where and how to use this code. thanks.
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...
Hi there are you still using access ? I have come across your code to move a record from 1 table to another and struggling to get it to work. Do i make the new table with the same fields as existing one? Also is it just the new table I change in your code? Thanks very much for any help.