Activity Stream

I would use the Split() function with the "." as the parameter. However if you have missed a full stop in any of them, that would not work? If...

I would sort by the dates. Use functions like Year(), Month(), Day() and Hour() to get the relevant parts for your summing.?

Add the code below into the module of the main form and test the behavior: Option Compare Database Option Explicit ...

Hi Isladogs, I imported all your objects in my db and when starts using FrmLogin, displyed error msg on below line ByteArray(x) =...

O well thats possible indeed because the code from @kd2017 won't work either. And this would explain why. But is it possible to sort the dates...

Hi Isladogs, I have tested it all the way. It is working well. After using it I came to the conclusion that no doubt your user rights database is...

a textbox bound to a date field will give INVALID DATE error naturally , with no programming involved.

Thanks. That should save some time

Really not enough information about your dB to give a valid answer. It would help if you would post your dB. My question to you is why do you...

@jharding08, In the code you wrote, you have this line Dim strMain, strEnd As String In this line, you have declared "strMain" as a Variant and...

You might want to consider researching db normalization as I think you have repeating attribute fields. Member details are likely repeating fields...

Late to the party, but what else am I going to do with it? Function RemAsterisk(strIn As String) As String Dim intEnd As Integer, i As Integer ...

I have set up a small function. Function removeTrailingChars(sTerm As String) As String Dim i As Integer 'counter Dim...

This is what I came up with: Public Function StripString(strString As String, delimiter As String) As String Dim strMain, strEnd As String...

You should be aware that you should post code within code tags. This helps keep the code formatting, enhances readability and eliminates the spaces...

:confused: And some numbers changed? SV1*HC:90686*33*UN*1****************~ It should look like SV1*HC:90236:::::*33*UN*1~ Hmmmmm.........

It might be more efficient to get this resolved if you post a copy of your database. Compact and Repair,then zip, then post.

My thought is to loop from right to left, starting with position 2, removing anything that is * and stopping when it hits a character that is not *....

Instrrev https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/instrrev-function

Problem is that if there are no values and its just ****, then there is a value, like "SV1*HC:90686*33*UN*1****P*******", then I need to strip after...

Again, are you not having to alter the value from 01011999 to something else (in your case, 01-01-1999)? I'm only commenting according to what was...

Is this 12 page spread because there are only a few records (or even just one) on a page, or some pages only have a few fields on them, or nothing, -...

1) What is the field type for Portafoglio.TrattativaID? Is it Text, Number/Long Integer, ???? 2) Try this qry = "SELECT P.TrattativaID,...

We still do not know if that date is ddmmyyyy or mmddyyyy ?

Hi Micron This works in a query where Field1 contains the value 01011999 :- NewDate: CDate(Format(,"00-00-0000"))

Thank you kd2017... 'much appreciated!