Search results

The loop eventually arrives at cmb_Client. You then set focus to it, and hide it. Kaboom! One idea is to create a 1x1 pixel command button, transparent, and set focus to it before entering the loop.

To silence all timers, I use this code: Sub silenceTimers() Dim frm As Form Dim ctl As Control For Each frm In Forms If frm.TimerInterval <> 0 Then Debug.Print frm.name, frm.TimerInterval frm.TimerInterval = 0...

Do you see the same behavior in another database, say one of the templates (File > New)?

I doubt many potential customers see that as a good thing. You become the single-point-of-failure. If you get hit by a bus, or (hopefully) by the winning lottery ticket, POOF, you and their investment are gone. Compare that to someone who answers: "I use mainstream coding style and tools from...

Presumably you would still need a database of some sort to store your data, no? You may want to use an ORM = object relational mapper to provide the middle layer between your object-oriented code and your relational database. Or rather than a relational database, use an object-oriented database...

Tell us more about your line of business and how these specials would work. We can speculate all day long, but you can fill us in.

Is there a lesson to be learned in your misspelling of "maintenance"? :)

The Access team is planning on changing the InputBox statement coordinate parameters so larger coordinate systems are supported. There is no timeline publicly available.

LostFocus might work, but <control>_BeforeUpdate would be more appropriate if you need instant check, again because this is a cancellable event.

Code would be in Form_BeforeUpdate, because that is a cancellable event (Cancel=True). If Me.MyFirstDate.OldValue <> Me.MyFirstDate then ... Cancel = (Msgbox("Yo! You OK with saving the new MyFirstDate?", vbQuestion or vbYesNo) = vbNo) ... I would find it highly annoying if I had to confirm...

That means Access crashed. Step up your backup regime, just in case the file becomes corrupted. Decompile it. Compact and repair If it persists, repair the Office installation from Control Panel.

I slightly modified your app to prove that clicking the button causes the parent form's record to be requeried. This is Access doing its thing, in its infinite wisdom. Nothing you can do about that unless you go to extremes like using an unbound form. BTW, both the parent and the child form use...

The business may want to hire a professional Access developer for an assessment. Access hasn't really changed in the last 6 months, although some bugs are introduced and fixed every month. That is RARELY the cause of instability and slowness. We don't know your level of competency with Access...

> The subform's record sources are all three tables That is almost certainly an error. See if you can bind the subform to a single table. Example: Northwind Starter Edition template database, frmOrderDetails has a subform sfrmOrderDetails, and it is bound to a query on a single table...

That is exactly what I do. It assumes your computer has enough memory to run a VM. You can get away with 4 GB for the VM, but more is better. Microsoft Hyper-V software is free to create a VM. You *do* need licenses for Windows and Office for that VM.

Another possibility is that the table does not have a PK. That is a really bad idea on its own, and with linked tables can lead to updates failing.

The classic example is: I have an OrderDetail record with a Price. It should reflect the price at the time of data entry. The solution is to save the Price as part of the OrderDetail record. Armed with that understanding, can you apply it to your situation?

Did you follow the link? If so, you would have seen it's about the Orders form, specifically frmOrderDetails. There is a vldeo where I discuss validation as well. -Tom.

A more elegant (if I may say so) implementation of field level validation of required fields, including optionally required fields (if status=X then the field is required) can be found in the Northwind 2 Dev edition template. Per the documentation, it takes only 3 lines of code to validate a form.

Notepad++ shows it is an ANSI file, *not* Unicode. Also, when using the Hex editor, you can see that it is one byte per character, *not* Unicode. You have several options, including going back to the source of this file and ask them for a Unicode file. Or use importing tools that can work with...