Replies

Braddy
What do you see at the moment when you first open the DB. It seems to me the simplest way to do what you want is to open on a little unbound form which says “Do you want to see today’s clients?” . Have 2 buttons, one of which filters your client list by date and the other either exits or goes into some other part of the DB. I ( or lots of other loungers) can show you the code if this sounds right.
Peter

Lucas
I think you’ll find the code should be applied to the event procedure of [FirstName] not [Nickname]. Nickname never gets updated if it remains null.
Peter

Lucas
I think you’ll find the code should be applied to the event procedure of [FirstName] not [Nickname]. Nickname never gets updated if it remains null.
Peter

Ed
Try this one CDex I’ve played with it but not fully tested it yet. It seems OK though.
Peter

Ed
Try this one CDex I’ve played with it but not fully tested it yet. It seems OK though.
Peter

I decided to try it. It turns out to be a new format. You have the choice of Pro trial or free in the same package. You can choose the trial and go back to free after the 15 days. Seems a good idea to me

Peter

I decided to try it. It turns out to be a new format. You have the choice of Pro trial or free in the same package. You can choose the trial and go back to free after the 15 days. Seems a good idea to me

Peter

Thanks.
I’ve managed to get it (for now?).

Peter

Thanks.
I’ve managed to get it (for now?).

Peter

When you open the PUB file you will see page tabs along the bottom of the screen. It seems to me that in your file you should only see three. Publisher can not truncate 4 pages into 3 unless you make it.
If you do see only 3 then click Insert|Page from the menu from page 3, resize the text box on p3 so the text disappears out the bottom. If you then create a text box on p4 you can ‘flow’ the text into it with the link button.
Peter

When you open the PUB file you will see page tabs along the bottom of the screen. It seems to me that in your file you should only see three. Publisher can not truncate 4 pages into 3 unless you make it.
If you do see only 3 then click Insert|Page from the menu from page 3, resize the text box on p3 so the text disappears out the bottom. If you then create a text box on p4 you can ‘flow’ the text into it with the link button.
Peter

I got this function from Helen Feddema’s site. Her function stripped out non alpha numeric but I added 1 to 0 to strip out numbers too.
Within the VBA see strStripChars for the characters it removes. You can amend this for the characters you chose.
I recommend Helen’s site. It has some great code which you can play with to suit your needs.
The code I amended is as follows:
Function StripNonAlpha(strText As String) As String
Dim strTestChar As String, _
lngFound As Long, _
i As Integer, _
strStripChars As String, _
strTestString As String

strStripChars = ” `~!@#$%^&*()-_=+[{]};:’,/?1234567890″ & Chr$(34) & Chr$(13) & Chr$(10)
strTestString = strText
i = 1
Do While i 0 Then
strTestString = Left(strTestString, i – 1) & Mid(strTestString, i + 1)
Else
i = i + 1
End If
Loop
StripNonAlpha = strTestString
End Function

Hope this works for you.
Peter

I got this function from Helen Feddema’s site. Her function stripped out non alpha numeric but I added 1 to 0 to strip out numbers too.
Within the VBA see strStripChars for the characters it removes. You can amend this for the characters you chose.
I recommend Helen’s site. It has some great code which you can play with to suit your needs.
The code I amended is as follows:
Function StripNonAlpha(strText As String) As String
Dim strTestChar As String, _
lngFound As Long, _
i As Integer, _
strStripChars As String, _
strTestString As String

strStripChars = ” `~!@#$%^&*()-_=+[{]};:’,/?1234567890″ & Chr$(34) & Chr$(13) & Chr$(10)
strTestString = strText
i = 1
Do While i 0 Then
strTestString = Left(strTestString, i – 1) & Mid(strTestString, i + 1)
Else
i = i + 1
End If
Loop
StripNonAlpha = strTestString
End Function

Hope this works for you.
Peter

AutoIt and one of its add-ons (Atool or AutXtra) will do this if you can do a little easy coding. You can get AutoIt here along with, I think, a link to the two extras.
Peter

AutoIt and one of its add-ons (Atool or AutXtra) will do this if you can do a little easy coding. You can get AutoIt here along with, I think, a link to the two extras.
Peter