Search results

You're welcome ! Although there is a small disadvantage to this, if the string happens to be c762c. The function will fail. As Val will yield the Numeric value left to a String. There is an alternative using a IsNumeric looping through literally every single character and seeing if a number...

You might need a UDF to get you this information. There is no native function that can do this. Something like, Public Function HasNumbers(InputStr As String) As Boolean Dim tmpArr() As String, lCtr As Integer tmpArr = Split(InputStr, ";") For lCtr = 0 To UBound(tmpArr)...

Filtered by? Could you please explain what you mean by that?

DMax by default gives you a Null if nothing is there. So you can use the Nz function, so. Nz(DMax("CustomerID", "Customer_Details"), 0) + 1 This will give you 1, if there is nothing in the table

This is so bizarre, I have never come across. Good luck ! :)

So many typos, you have a . instead of a , in the first SELECT. You need to use ( brackets for subqueries not [. The last line has a Square bracket and a full stop where it should be a just ')' bracket. Also close all columns with square brackets. Something like, SELECT tQ.[PIN]...

Add them to the First SELECT tQ.EventOutcome, tQ.EventSeenBy and then to the second select as, EventsTable.EventOutcome, EventsTable.EventSeenBy

It could have been a simple GROUP BY Query if not for the Event ID, so you might need a SubQuery to save your day. Something like. SELECT tQ.EpisodeID, tQ.EventID, tQ.EventDate FROM ( SELECT EventsTable.EpisodeID, EventsTable.EventID...

Of course you can. This can be used as Audit log. See here for how to start - http://allenbrowne.com/appaudit.html

Could you explain using some examples please?

Is 05_Henrichpiramid a Yes/No Type?

I feel this is because of the fact they are being treated as Strings as opposed to Numbers. Try Casting them as numbers and try again. =(CLng([TXT1]) + CLng([TXT2]) + CLng([TXT3]))

You need to concatenate things properly. Try, If DCount("*", "tbl_userinformation", "Anwendung = False AND " & _ "Username = '" & Me![Text146] "' AND " & _ "[actualdate] = " & Format(Me![Text148],"\#mm\/dd\/yyyy\#")) >...

The text needs to be wrapped in single quotes and dates inside # tags. So try. If DCount("*", "tbl_userinformation", "Username = '" & Me![Text146] & _ "' AND [actualdate] = " & Format(Me![Text148],"\#mm\/dd\/yyyy\#")) > 0 Then

Yes, you just need the settings for the mail servers. Gmail is available in the link I gave you. Hotmail should be available in MS Website somewhere. Do a Google search.

I am really sorry you cannot make it Bob, we will see if many think Bristol is too far. In that case, we will see if we can find a better suited location. :) Congratulations ! Does that mean we are invited for the wedding? :p

Allen Browne, has written a small article about this : http://allenbrowne.com/ser-63.html

Use Gmail maybe, Using CDO?

Hello Mark, Welcome to AWF :) Hope you get all the help you need. Congratulations !!

Could you please explain what you mean by Have you actually tried this? It looks OK !