Search results

That has been my experience as well. For the few clients that are on Access BE, we run a PowerShell script every 15 min during business hours to make a backup, and to trim back the files to the last 2 weeks. Even if there is a bad one, I have another one from 15 min earlier. Sorry I cannot share...

> I have been studying the Northwind 2 database and trying to get my head around how it works. Good for you. That's exactly why we made them: to discover what Access can do, and learn a few new things in the process. Use the yellow information buttons in the upper right corner of most forms...

I use the length as a constraint. E.g. in the US the StateAbbrev field would have a length of 2 (see also: Northwind 2 template databases). The principle used is to "always" use the smallest data type that fits the expected data. "always" in quotes because for the Number field I don't often...

I think you need two tables, one to be the parent with one record for a debit/credit transaction. Then another child table with the two records in it: one for debit, and one for credit. The relationship is one-to-many from parent to child table. The 3 total records would be created in a SQL...

dim s1 as string dim s2 as string s1 = "Montgomery" s2 = String$(Len(s1), "_") debug.print s1, s2 This prints: Montgomery __________

Ah, a transparent button. I had not thought of that yet. Great technique!

I understand so far that each INSERT INTO inserts 1 record. Are you calling that code in a loop? If so, how many iterations?

I've been working your sample for a few hours now, trying to make the editor pop up on GotFocus, so user does not have to click. I got a few steps in the right direction (or so I think) but not finished yet.

How many records?

I'm going to explore this idea of a popup form a bit more. Not sure yet how much it will interfere with high-speed data entry.

The advantages I saw were the date picker, automatic date completion (e.g. only typing mm/dd), basic data type validation, and the Format property (I still have to format Percent fields). But you're right: once the Sign field is introduced, I may have over-complicated it.

In a Continuous form, if we want to change the RowSource of a combobox for each row, we can overlay that combobox with a textbox. An example is implemented in NW2-Dev, Order form, Order Line Items subform, the Product section. The textbox shows the value for the non-current rows, and the...

> what am I looking for in the decompiled code? Nothing. Decompiling throws away previous compiled state of each form and module (the P-Code that is run by the VBA runtime). Next time the code is run, Access will automatically compile it again, rather than re-using the possibly bad previous...

I am 99% sure the issue is NOT with the code change you showed. Did you try decompiling the application? When you copy an ACCDB from Uni to Home or vice versa, the versions may be different enough that fresh compiled code is needed. Search online for "Access decompile" to learn how to do it.

One thing you can try is Edit > Replace and replace strSQl with strSQL throughout.

Isn't that what they are doing? Set objFSO = CreateObject("Scripting.FileSystemObject")

My experience was that the Private Enum LongPtr definition appeared in Red. I did not even try to compile it, but I just did and to my surprise it did work. I don't have #VBA6 available here (it's now 20 years later; such dinosaurs will likely not be using your code :-)) so I cannot test in that...

I don't think so Colin. You are free to ignore a stack frame in YOUR code, but the Example is not wrong. It loops from 0 to Ubound, which comprises of all array elements / stack frames. Maybe you were thinking of: For i = 0 To FrameCount() - 1

I misspoke. Once at the breakpoint, I *did* use the Immediate window to call my testDumpStack procedure . Sorry for the confusion.

I did not use the Immediate window.