With help from thread 682356 to run the LISP, Hooray, a few challenges are solved. Plus I learned how to explode MText, which is logical (so much so you'd think AutoCAD 2002 Help would mention it).
Many thanks, Carl!
_______________________________
Never confuse movement with action -- E...
That's beautiful. All I need is the complete snippet! Oh, and I just discovered that this CAD fraud used only MTEXT. Which was really not the thing to do here. Okay, thanks. Carl.
_______________________________
Never confuse movement with action -- E. Hemingway
Yes, I wasn't clear. It's all single-line text entries that are the issue. Sure looks like a simple VBA routine don't it?
_______________________________
Never confuse movement with action -- E. Hemingway
I have a large diagram built by a CAD felon. He didn't use Snap. I'd like to select everything and have each item moved to the nearest snap point. Is there such a command?
_______________________________
Never confuse movement with action -- E. Hemingway
Search in forums
Microsoft: Access Other Topics
or
Microsoft: Access Forms.
_______________________________
Never confuse movement with action -- E. Hemingway
Thanks Matthew for your informative post.
I will frame up some more specific questions based from what you wrote.
Is the Net ripe for a true jobs clearinghouse? More on that later too ... my library quci-login is about to expire!
_______________________________
Never confuse movement...
This is titled similarly to my post of a week ago, but is specific on the point. How do I locate an effective career counselor?
Right now my idea for finding a career counselor in Austin TX is (a) use the yellow pages and (b) demand live references I can call on the phone.
Are there any...
I'm sorry I neglected the post (I thought I would get the little email notification!).
THANKS FOR THE INPUT. LN Bruno: Actually, I relocate in the end if I take the GIS option. Because our area is saturated in this field, which follows from the university having an excellant program. (And...
43 yrs. old, wife and kids, no savings, can't fool around with bad career options. No college degree worth writing down. Wouldn't mind living in a different US region.
Currently make an unimpressive wage of $39k for an enjoyable, local mid-size business, working as an expert Access/VBA...
Oh my. All this time and I didn't know. Thanks and Five Pink Points for you.
_______________________________
Never confuse movement with action -- E. Hemingway
Thanks Alan. 'Break on all errors' was already set.
Finally concluded it was one of those weirder corruptions. I made a fresh .mdb and imported all objects. This has seems to have solved the problem.
Post of inscrutable value?
If so, Red Flag it!
_______________________________
Never...
Private Sub btnMyButton_Click()
Stop
If MsgBox("Please, please", vbOKCancel) = vbOK Then
Stop
End If
Call ProcedureOfMine
End Sub
When I invoke this from the form, the MsgBox appears but the vbOK path does not cause the code to stop.
Stop will not stop...
I want to loop through all objects in my Access 2003 database. Application.CurrentData offers collections based on object type. Is there any way to loop through them all regardless of type?
The goal is to use the IsDependentUpon method. It requires that the object type be identified, so as I...
Sorry about two weeks going by. My computer went south. I assume you probably have made progress but post a new reply if issues are still there.
The way I handle this in a similar situation is the LoanApp table has a field, SalesRep, that is text. The code starts a new LoanApp record with...
Access 2003. Stumbled on a DependencyInfo object in VBA Help. Actual documentation however is worse than sparse. Google, Micrisoft online don't want to add anything.
Of course what I thought I might have is a cheap easy way to inventory my database and start deleting the flotsam objects...
Okay I got this resolved. On the main form I had a field for the Master Link. It was bound to [FID_Proj], instead of [PID_Proj]. Fixing this seems to have solved it. [FID_Proj] wasn't a valid source field anyway, but I had this field under another and didn't notice Access was flagging it as...
No difference, aside from extra twitching and groaning on-screen.
Right now my code bloat includes
.SourceObject = ""
.SourceObject = "SubForm"
.LinkMasterFields = "PID_Proj"
.LinkChildFields = "FID_Proj"
.Requery
Maybe I'm handling this in the wrong form module. I have...
<somevalue> is a logon ID, which you can obtain with Environ("UserName") in VBA.
I would think you would use that to identify the person. You might need a table to look up the user's human name from their logon.
_______________________________
Never confuse movement with action -- E...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.