Search results

My research and personal testing overcomes the error. Add a slight pause to your cause. The 'Sleep' function (or 'Sleep1000') that is now publicly available on the internet before the DoCmd.RunCommand acCmdCopy and/or DoCmd.RunCommand acCmdPaste. I "sleep" for 2 milliseconds, ie., Sleep1000 2...

In my experience, after 27 years of using macros, Microsoft fails to support them and errors in the database become unresolvable by either Compact and Repair or Vba Debug. The macros-related errors reveal themselves in a Vba-type catastrophic error 'return without gosub'. The errors also take...

I'm proud of myself. I tried your code, saw the error, fixed it, and didn't say anything. I'm not and low skilled as I thought.

Good suggestion. I'll add it to the bag of tricks.

how do I do that orange bar for pasting code?

What a great homework assignment. I'm not great yet, but am studying privately. I should have known I could write my own. I've got a few little public functions that help me process information. Michael Wolfe wrote a function for cascading combo boxes which inspires me. Thanks.

Thank you. I'm grateful.

Excellent! The back story is ... I've decided to change my Datebook TimeFrom control to string format instead of a DateTime format so that partial time entries are accepted, and the computer deduces what was intended. The new control accepts the following partial time entries: 9 08 14 7:3 1122...

Creative. Square pegs do fit in round holes after all.

Thanks for the research. Forcing the use of 'Between' in the VBA context, when it is meant to dwell only in Query-SQL-land, is a bad idea.

Yes, the post of, Minty, AWF VIP, worked well: "Case 7 to 11, 24". It's an honor to have your guidance. I have the ambition of being like all of you.

I've attempted to use > x and < y in a select statement and it isn't working? Suggestions? The code follows: Select Case IsNumeric(CCValue) Case Is = True Select Case CCValue Case Is = 7, 8, 9, 10, 11, 24...

Well, it's not the same error that Runtime is throwing when using Access, but it's similar and the principle still applies, early-bind when developing, late-bind when distributing. I do both when developing but just comment out the 'late-bind' script.

It's a pain to learn late binding but worth it. It's just one of those skills you may use once but comes in handy years later for solving problems like 'missing reference'.