Recent content by MSAccessRookie

In case you were wondering why the change worked, and if you should always use "&", I would imagine that each has their own place, but in this case, the difference probably was in the Instance where part of the equation was NULL. "Hello " + NULL = NULL "Hello " & NULL = "Hello " -- Rookie

Is there any particular reason for using the Select/Case Statement Here? I offer my apologies in advance if I misunderstood your intent, but I believe that the following could be a simpler approach: IF ((KeyDown between 65 and 90) or (KeyDown between 97 and 122)THEN MsgBox ("you pressed...

Since the general purpose of a Filter is to Exclude items that do not fit the desired criteria, and the first entry represents all items, It is difficult to see why a filter would be needed. Try using no Filter and see if it does what you want. Beaten by two! and I even looked before I started...

Once again, Uncle Gizmo is asking a legitimate question. A Stock Ticker is used like a Database Primary Key to obtain information (price, volume, etc.) pertaining to a stock from another application or database. Not knowing why you want to know, or what you want to do with the information, it is...

I believe that what Uncle Gizmo meant was that how you do it with a computer is directly related to how you would do it on paper. You will need a multiple Case Operation, so use google to look up IIf, Switch, and Select Case and determine on your own if either of those options is able to...

There a Function named Mid() in MS Access which allows you to extract characters from within a target string. There is also a Function named Instr() that will allow you to find specific characters within a target string. Combining these two should get you what you are searching for. Use Google...

The company I am working for has issued an executive order not to upgrade any workstation or laptop that is to be used in the Corporate environment due to "incompatibilities to be named later". As for my personal devices, I choose to wait and see what experiences others are having first --...

Or possibly you know what :banghead:

And we have another satisfied customer! Please feel free to let us know the details of your solution if you have time to do so. It is helpful to know the final solutions of issues presented in the Forum, since other individuals with similar issues can often benefit from your experiences. -- Rookie

about craters in

Knowing absolutely NOTHING about your Database, it is hart to be specific, but when you break down your question into smaller pieces, it seems to answer itself. As you can see, the answer should be Yes. -- Rookie Can I create a macro that will (under most normal circumstances): Use the...

left nothing behind

If by "Email" you are referring to Microsoft Outlook, then perhaps you can remove the middleman entirely. Microsoft Access has the ability to open Outlook style emails and read the contents. I believe information such as the Sender, Subject Line, and Text Body are available. Try doing a...

Other Functions worthy of consideration are Right(YourString, 1) will get the last character Left(Len(YourString) - 1) will get all but the last character -- Rookie

Unless there is a typing error, I think you might be missing a pair of parentheses (see above). Let us know if that makes any difference. -- Rookie