Search results

Unfortunately your screenshots prove you wrong. Access 64bit cannot see/use any 32bit DSN or driver. Your screenshots show that these DSNs are 32bit only. It is impossible that you previously had 64bit Access and were using these DSNs.

They are not the same thing! Particularly not in this context. An exposed VB6 class is COM compliant. An exposed VBA class is a bastardized, neutered thing that behaves (with limitations!) like a COM class (rather interface) only within the scope of the distinct VBA project it is loaded into. I...

I think, I used this with Access 97 already. I'm very sure, I used it with Access 2000. The oldest project in my source code control repository using this approach is from May 2005. (When I started using SCC.)

The VBA development environment has a higher level view on all the opened projects, including referenced ones. You can even open and view(*) the code in the modules of the referenced file, including form class modules. So, the context of the Immediate Window is not the same as in a module in...

Other than .accda not being available as an explicit file extension, there are all common Access file types listed in the Add Reference file dialog.

The library was certainly not written in VBA. Not all data types valid in COM are supported by VBA. - It's a weird idea though to create a COM library explicitly meant for Excel and then using a data type not supported by VBA. I guess, the actual signature of the method is: Function...

Thank you Colin for the examples. I actually looked on your website first before posting here. The first one is just a temporary selection(?) and thus unsuitable for my requirements. The second one is visually close to what I want to achieve. But for now, I design just a first prototype and do...

Alternate row colors are visual guardrails to help the human eye to visually follow one row in a list of rows. Whether this is updatable data or read-only and whether it is on screen or on paper is irrelevant. In my case, the leftmost 5 read-only columns allow the user to identify a record and...

I had the idea of using an artificial row number to detect the alternating rows but discarded that idea because correctly computing row numbers for arbitrary sort orders is somewhat complex. However, your simple RowNumber function from the linked download does not really produce a reliable row...

I posted a screenshot of it. So, yes, I opened it. Highlighting the current row is nice and it would be stopgap solution if everything else fails. However, as stated before, my question is about alternate row colors for all rows.

Thank you for the example. I do understand how to implement your suggestion but I do not understand how it can help to solve my problem. I do not ask about highlighting the current record but about how to apply alternating row colors. Your example produces this result: I want to achieve...

I don't understand. HasFocus only applies to a single control in the datasheet grid. I ask about alternate row colors for all rows in the grid.

Is it possible to change the back color for some columns in a datasheet form but still keep alternate row colors? I’ve got a datasheet (sub) form. The first (leftmost) columns are read-only (Enabled=False,Locked=True) and the user is not supposed to edit data there. The last (rightmost) columns...

Yes: Access LTSC 2024 Support Dates

You mention a "simple report" but your screenshots appear to show a form. For forms the CanGrow/-Shrink properties only have an effect if the form is printed.

2027 is surely nonsense. Office 2024 is about to be released and it will have support until 2029, including for VBA.

The act of taking something implies that you know it exists. It's impossible to take something you do not know it exists. Your original interpretation of plagiarism is correct. If you by chance write the exact same text as somebody else without knowing that text, it is not plagiarism. - The...

That explains the error message you got earlier. Strange though, I thought David and Zira would always be available by default even if en-US is not your configured Windows language.

You could at least read the references you link to. Your link proves your own statement wrong.

I fully agree with what you wrote in that post before. One comment on this line though: A copyright clause that gives you permission to use a piece of work is much safer than no copyright clause at all! As mentioned before, in German copyright law the copyright is inherent to the original...