Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: smandoli9
  • Order by date
  1. smandoli9

    Move all objects to snap conformity

    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...
  2. smandoli9

    Move all objects to snap conformity

    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
  3. smandoli9

    Move all objects to snap conformity

    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
  4. smandoli9

    Move all objects to snap conformity

    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
  5. smandoli9

    Access Reports and visible toolbars

    Search in forums Microsoft: Access Other Topics or Microsoft: Access Forms. _______________________________ Never confuse movement with action -- E. Hemingway
  6. smandoli9

    Good professional career counselor -- How?

    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...
  7. smandoli9

    Good professional career counselor -- How?

    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...
  8. smandoli9

    Need Career Counsel (or a Counsellor!)

    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...
  9. smandoli9

    Need Career Counsel (or a Counsellor!)

    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...
  10. smandoli9

    List all AccessObjects regardless of object type

    Thanks ... star ... hadn't seen this interesting site. _______________________________ Never confuse movement with action -- E. Hemingway
  11. smandoli9

    List all AccessObjects regardless of object type

    Oh my. All this time and I didn't know. Thanks and Five Pink Points for you. _______________________________ Never confuse movement with action -- E. Hemingway
  12. smandoli9

    Code doesn't execute right, won't break at Stop

    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...
  13. smandoli9

    Code doesn't execute right, won't break at Stop

    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...
  14. smandoli9

    List all AccessObjects regardless of object type

    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...
  15. smandoli9

    Input value from a table that won't change when table value does

    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...
  16. smandoli9

    DependencyInfo object -- how to use?

    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...
  17. smandoli9

    hyperlink to folder

    strTargetFolder = Dir(strPathStart & strFolderName, vbDirectory) strPathComplete = strPathStart & strTargetFolder If strPathComplete <> "" And strTargetFolder <> "" Then Application.FollowHyperlink strPathComplete, , True Else MsgBox "Sorry, can't locate that folder!"...
  18. smandoli9

    subform links fail upon Recordsource change

    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...
  19. smandoli9

    subform links fail upon Recordsource change

    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...
  20. smandoli9

    Form opens to records only for specific user?

    <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...

Part and Inventory Search

Back
Top