Search results for query: *

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

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

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

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

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

Form, 2 subforms (Access 2002) The Form allows one to change the recordsource of the Form after opening: Forms("Form").RecordSource = "alt_query" The record subset for the Form comes out right, but the two subforms look as if they lost their link or did not load. The new recordsource's...

Access 2002, split server/client, DAO. I want the user to be able to invoke, from a form, a second instance of the database; the user can then compare records between the two. I have tried Private Sub btnLaunch_Click() Dim q As String: q = """" Shell "MSAccess.exe " & q &...

I want to add a record to a table. Table is in a back-end Access 2003 mdb, and is locked to avoid multi-user conflict. I use OpenDatabase, then open the DAO recordset: Dim HomerBE As DAO.Database Dim rsProject As DAO.Recordset Set HomerBE = OpenDatabase _ (strPath, False, False, "MS...

I'm building a project management application (Access 2003). Each project has a folder on the network which serves as a hold-all for various documents. I want the Details Form for a given project to include a button that will open the relevant folder. Application.FollowHyperlink...

Form set to show Continuous, not Single. Two totals are displayed. The first is a sum from a many-to-one table (a drill-down button takes you to the details). The other is the first total plus a user-entered amount. EXAMPLE: Orders for items being purchased. The form shows one record for...

I am building a project management application on Access 2003. A component of this tracks Contacts -- purchasers, sales reps, outside parties of all sorts. I inherited a wretched, outrageous botch of contacts data and have got it basically normalized. (I must record the stats for use on...

I open the client database (Access 2003). Navigate through a couple of VBA-enhanced forms. Get to a certain form and click on a certain button. The code breaks part way through event handling. The line it stops at, for what it is worth, says: If OpenArgs = "f_pProjectDetail--ADD" Then It...

What about a FAQ on formatting numbers for currency on forms? I've lost some hair on this one. If anyone has a good web site or even a book to pick up, your reply is valued. My project is sales/mfg. oriented. In forms, I hate the way 1 to 6 decimal digits pop into view when the control as...

I am used to using F8 and shift-F8 to step through code. I'm used to breakpoints and the Stop command, and I ignore the Watch feature but I know it's there. I want a toggle command somewhere in the VBA editor that breaks the the running code as soon as a line of VBA is called. Like having a...

Access 2003. My form starts with a list box, populated via code: Me!BOM_RollUp_sub.Form![listBOM].RowSourceType _ = "Table/Query" Me!BOM_RollUp_sub.Form![listBOM].RowSource _ = "SELECT etc ..." Selecting one of its records populates the rest of the form. I want the topmost...

I am using a List Box 1 to limit the query beneath a another List Box 2. The Form is unbound; the List Box 1 is unbound and populated by a Value List; "Enable" is True, "Locked" is False. In Design view, I can't make my selection in List Box 1. Using VBA control events to troubleshoot, I...

I want to scale a set of objects non-proportionally. The scale for X-axis will be different from Y-axis. In other words, I want to squish the image vertically. How do I do it? SCALE is always proportional. STRETCH lets you select a set of points and place them different in relation to...

I want to run a set of values through a procedure: DoProcedure("strThing1") DoProcedure("strThing2") DoProcedure("strThing3") I would love to do it with reiterating code: For Each "strThing1", "strThing2", "strThing3&quot...

My form has two buttons and I want to post which button was pressed. Using the form below, my ASP response can reflect either "1" or "2". However, instead of type="submit" I'm supposed to be using type="image". When I switch to images, I no longer can...