Recent content by monbois

An Access database that runs automatically daily imports Oracle (LIMs) data into local tables. Macros execute the sub-routines and open queries via a batch file. The database closes after each major update in order to compact it. Somehow the data tables are missing when the database opens back...

Found an exceedingly simple solution on the UK website DatabaseDev: ' place cursor at end of text in Text Box ' ---------------------------------------------------------------- Me!TextBox.SelStart = Me!TextBox.SelLength I put this code in the Key Up event; after each keystroke I want a...

I tried this code, but Access 2010 doesn't know what to make of this name: pfPositionCursor Doesn't work for me at all. :(

Hi, I'm having the same problem. As clear as your answer seems, I'm not seeing the part: Select Group on "the field to group by" ??? I've attached 2 images of the only report elements. It would be great if you could respond with screen shots like this or more detail to get where you're...

I use only global variables so I can call them whenever and whenever I want. I rarely need a single variable for a single use in a single form or report. And what about queries? You can't filter a query with a variable value unless it's declared globally and then transferred to a function...

Re: Clearing memory - Declaring Global Variables You need to declare your variables globally instead of locally. Instead of declaring: Dim strText as String in a form. You want to declare: Global strText as String in a module. That way you can use the variable in any form or report...

In the solution formula: =IIf(X IN(1,2,3,4),Y+Z,A+B) What comes between X and IN ?!? Thanks.