Search results

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...

You need to pass in the Opt argument in the connection string. It's listed here. Notice at the bottom they've also given you the recommended value to pass in when using Access as well. Also, if the timeout is due to the MySQL being hosted and they're making timeout much shorter, then consider...

You'd use filesystem permission for this. Put your Access database file (both BE/FE) in a certain folder and grant full permission only to that domain group. Your users can then enter the folder,copy the FE to their desktop and link to your BE. Any users not member of the domain group can't...

Unfortunately, there isn't any special upsert syntaxes for Jet SQL. You'd have to do it the ANSI way - update with an inner join then insert using a frustrated join in two separate queries.

If you're using Access 2010 (maybe 2007, too?) then you can just give your users rich text with ability to select fonts, colors and few other options. An article on rich text capability

Well, yes. One way to do this is to make use of Replace() function to scan the text within string variable for something like {FirstName} and replace it with appropriate value. You'd probably give your users a dropdown that lists valid tokens for users to select while building the complete text...