Recent content by Banana

Hi - No, that is a limitation of the method of binding the ADO recordset to a form. There are also few other limitations. Here's a partial list. If you want to keep using ADO recordset, you have to manually re-implement the filters in code and use Filter method/Sort. I also want to point out...

@Galaxiom, yes, it was introduced in 2010. @OP, In all versions of Access, though, you can always right-click a cell in QBE and select "Build..." to open the expression builder. Within it, you can navigate Forms -> Loaded Forms -> <name of your form>. The listing you can then see in the...

This is basically why I shun SendKeys/AppActivate; you're at mercy at everything else and have to contend with timing your requests and ensure that there's no interrupts that may disrupt your requests. I'd really look at whether there's APIs or command parameters that you can use instead of...

I've always thought that trying automate via SendKeys & setting focus using AppActivate were kind of dicey because you're relying on certain UI behavior and that there's no unexpected errors (e.g. a messagebox displaying when there should be a Save dialog). My first question is to find out...

Rain, IME, "Print" has not worked for me before. I always had to say "Debug.Print" inside procedures. I assume you copied "?256& * 256&" and pasted it into a procedure instead of into Immediate windows. VBA editor changes it to the code that you displayed which then breaks it until you manually...

In case of literals, VBA will assume the smallest data type appropriate for the literal. Thus a literal '256' would be an integer. An integer 256 multiplied by integer 256 will overflow. ?TypeName(256) Integer To coerce a literal or a constant value into a desired size, you need to provide a...

Just to clarify, because the title was "odbc and database security" and this appears to be for an Access backend, it's not really ODBC that's responsible for security. All it does is pass forward the authenication information and let the endpoint handle it. Furthermore, ODBC is only one way to...

That's what happen when I try to answer from top of my head. :) Here's the post that I was thinking about WRT Brent's assessment.

FWIW, it's not 'every other objects' --- for instance, Recordsets suffer from the same malady that TableDefs does with respects to holding onto its parent reference. Brent had posted sometime in past where he suspect the differences could be attributed to what I forgot the specific terms but...

"On Error GoTo ...", "Exit <procedure>" and "Resume ..." statements automatically clears the error so Err.Clear in this case would be redundant since I do a Error GoTo 0 to narrow the scope of On Error Resume Next.

Some code to play with and ponder upon. Option Compare Database Option Explicit Public Sub TestIt() Dim db As DAO.Database Dim tdf As DAO.TableDef Dim qdf As DAO.QueryDef Debug.Print vbNewLine & "How many database references are there when we implicitly reference Currentdb?" & vbNewLine...

Isn't Mousehook a workaround for older Access versions where there were no Mouse scroll events? This also involves APIs and if you didn't update the API declarations properly, it may not work correctly. You should not need Mousehook since Mouse Scroll is now an available event since 2007.

My condolences to you, Brian. Remember also to count your blessings.

Maybe it's actually OK but there's other issues going on. I already linked the similar issue where a hosted MySQL has too short a timeout set that breaks the connection and the workaround. Maybe if you gave more details as to why you think the option will resolve problem, we can help.

Just to be clear here; there's two different factors here: 1) can we store a fixed length string? 2) can we output a fixed length string? Both questions are actually different because as gemma implied, you can export a text file that's a fixed-width and base it off data that are variable...