Search results

I'm about to give this approach a try: How to Print Form in MS Acccess - iAccessWorld.com I've added routines to change all background colors to white, so color isn't an issue.

AppId is a constant in the form, not important here. The actual record copy code (I copied it from elsewhere, modified it some, but it seems to work) is a few sub layers deep, but the important section of code that copies looks like this: Dim fimr As String Dim rs1 As Recordset, rs2 As...

Gets a runtime error:

I gave it a try, it goes to the wrong record. Should go to the record id in green, but went to the one in pink (hey, I didn't choose these colors that the snip tool uses).

This one's been bugging me for a few weeks now, and I haven't gotten an answer on two other forums. I'm in a form on a record. I programmatically copy that record to a new record. After doing that I know the ID of the new record. How can I "move" to that new record in the same open form with VBA ?

Why?, well you see those two little buttons up on the QATB (at least on my version of Access) for undo and redo? They work different than ctrl-z and ctrl-y and escape. And pressing them doesn't lose focus of where you are on the form, does it? The other reason, when I release a secured...

I've done a bit of testing and trying. The problem is, undo and redo either by code or with ctrl-z/y don't do the same things as the controls on the Quick Access Toolbar, which I plan to disable in production. For example, enter someting in a textbox, then undo it. Ctrl-y doesn't work but the...

Yes, but as you can see in the table sample, combo box headings and selection data as well as definitions for what could be ten tables (GEOgraphy) are somewhat cross-referencing ("cross" used as in cross-training--mixed).

In the interest of civility, I'll abstain from extended comment.

Then there's the Tom Peters approach of ready, fire, aim. 6 Right Times to Be a Ready-Fire-Aim Entrepreneur (forbes.com)

The message on my screen for the programmers said, "If you don't have time to do it right, then when will you find time to fix it?" It's truly a fine line. There's a learning curve for all, and even then, most development platforms add new features that need to be retrofitted into existing apps...

I'm blessed that I don't now have thirty programmers, like before, all coming up with new ideas on a daily basis, and then backing out half of those "great ideas" that didn't work. Design by chaos. I'm trying to be disciplined in design, I just don't have 5 years to get up to speed on Access as...

That sounds familiar to what we did, in theory, on a large mainframe that was a service bureau. Except we had dozens of DPs and a CD and DD for each programmer. I've got a video on that if anyone is interested. The big problem was when changes are made to the structure of the DP. Fields have to...

The characters weren't "chinese" but they were letters with weird didactics. So far, everything has been in one accdb file on one laptop. When I split, I want to start some basic testing with multi-user (two laptops to one BE), and the home has WIFI. The WIFI bogs down as other download apps...

I've done the repair twice now (remember the Access "touching" Outlook thread)? Problem continues.

Thanks for the tips. I'll give the split a try tomorrow. @ Doc, I did all the steps you outlined, three times. I wasn't too mindful of missing data as it's all just demo stuff, but text in fields had funny characters even after being imported. Still the crashes persist. I've been given a lot of...

I'm still in development and adding and modifying tables (and table names when needed) every day. The test data for geography is starting to get big. I've heard several people say that I need to split the database. I get it. My question is, is this advisable while still in heavy development...

I'm sorry, I don't see a question in your #7. It would appear that I hit a glitch in Access, as just copying and pasting the code into a new procedure in the same module fixed the problem. All the other considerations are irrelevant, as it started working with just that (even though I did make...

The code as I have it now, with the exception of the first and last lines is an exact cut&paste. It works and compiles fine with or without the Option Explicit. The immediate window has no problem with or without the "?" as the first character (I often forget it). Something strange happened the...

Okay, I did a little test of the above scenario. If FormA is open and dirty, and then I call FormB, I can't make changes to B. Good enough. What's the best way to know when FormB opens that it's data is locked, and to maybe just print a message and shutdown?