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!

Register Log in
  • 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: migv1
  • Order by date
  1. migv1

    Populate a Word table from an InfoPath form using VBScript

    Thanks a million to tsuji and PHV - I knew I could count on the resident experts here! One last question (so I can code better in the future): any suggestions for a good VBScript reference for MS Office automation?
  2. migv1

    Populate a Word table from an InfoPath form using VBScript

    Hi, tsuji: Forgive my ignorance, but what would be the VBScript equivalent of the With Selection... code? That code was taken from Word VBA, and when I use the same syntax in Script Editor I get an "object required" error. When I try substituting objRange for Selection, I get "MoveRight" not...
  3. migv1

    Populate a Word table from an InfoPath form using VBScript

    I posted this last week in Google Groups microsoft.public.infopath last week and got no takers. Maybe someone here can help? Does anyone know how to populate a Word table with data from an InfoPath form using VBScript? I've already figured out how to open the Word template and transfer data...
  4. migv1

    Active Directory Sync in Access

    I'm trying to create an Active Directory Synchronization function in Access, similar to that found in Project Server 2007. I can enumerate all the members of my AD group with the following code: Sub ADMembers() Dim strSql As String Dim LoginName As Object, tblEmployees As Table Dim...
  5. migv1

    Help using VBA in MS Project Pro 2007

    I have written "gatekeeper" code that checks a user's credentials and applies the appropriate filter (and disables command bars) so that users are restricted to viewing and editing only tasks owned by their departments. The code works fine when Project Pro is already running, but I can't seem...
  6. migv1

    New to MS Project 2007 Server/Workstation Pro

    As you might have guessed, this isn't the best place for MS Project (and specially Server) information. Here's a link to a good blog: http://www.pptspaces.com/msprojectreporterblog/Lists/Posts/AllPosts.aspx (The info on creating a VPC image is particularly impressive.) We have a test server...
  7. migv1

    How to VBA Analysis Toolpak ANOVA?

    Hi, Skip: Yes, I had it on the whole time, starting from selecting the data range, through opening Tools, selecting Data Analysis, etc. At the end, I park the selection at cell A1 out of habit, and that was the only thing that was captured by the macro recorder.
  8. migv1

    How to VBA Analysis Toolpak ANOVA?

    Thanks, Skip! After a little modification to account for the data and target cells, arrangement of data in columns, and existence of a header row, it works like a charm. I wonder why my macro recorder didn't record anything...
  9. migv1

    How to VBA Analysis Toolpak ANOVA?

    Greetings; I searched the forums and didn't find anything, so I hope this hasn't been asked before: How do you write code to automate a single factor ANOVA using the Tools > Data Analysis function? I have enabled both the Analysis ToolPak and Analysis ToolPak - VBA add-ins, but when I try to...
  10. migv1

    Convert detail record values to text

    Thanks, PH! That's exactly what I needed. Quite a bit of customization went into the final solution, but the FAQ you provided definitely pointed me in the right direction. I also learned that it's not good to use the "%" character in a field name (e.g., "%OfTotal") - it's OK in Access tables...
  11. migv1

    Convert detail record values to text

    Perhaps my question was unclear. In the example above, I need to extract data from all three records (or however many there may be for a particular contract) and build a compound text string with multiple lines separated by line feeds. I probably need to loop through the collection of records...
  12. migv1

    Convert detail record values to text

    I need to extract multiple detail record values in a subform and concatenate them into a single text value for transfer to another field. This is intended to make it easier for users to enter prospective payment schedules in a contract creation and tracking database. Currently, users are...
  13. migv1

    Enter Parameter Value Appears at form open

    I have a main form that is based on a query, which in turn gets a parameter (year) from a form (Select Year) that appears in response to the On Open event for the main form. When the main form is called, an Enter Parameter Value dialog appears. This doesn't do anything for the query, since you...
  14. migv1

    Insering actual documents into a table

    Thanks to everyone for the tips and code - I was able to accomplish my original goal, and now that I have, I can show my boss that keeping the actual documents in the database was not such a good idea. The Access (2002, BTW) file grows in size at an exponential rate, and I even get 'not enough...
  15. migv1

    Insering actual documents into a table

    Thanks, Remou! I think I'm at least going in the right direction. Actually, what I need is a routine for saving an existing document into an Access table, no need to open any other programs. I'm a little confused as to how to use DoCmd.RunCommand acCmdInsertObject to insert the file into the...
  16. migv1

    Insering actual documents into a table

    Greetings: I'm working on a form that would let users insert an actual document into an OLE Object field of a table. I can get the path and filename of the document using the FileDialog object, but how do you insert the actual object into the table programmatically? I need users to insert one...
  17. migv1

    How to detect autonumbering in Word

    Thanks for the code, Gerry! It works great as is, but is there a way to distinguish between numbered vs. bulleted lists? Carrying this to its logical conclusion, is there a way to automatically replace the generated autonumbers with plain text and spaces? BTW, is it just me or does it always...
  18. migv1

    How do I execute my VBA program in Excel?

    In addition to running it from the macro menu or a command button, depending on your needs/situation you can: 1. Assign the macro to a toolbar button 2. Make the code run in reponse to an event, such as worksheet inactivation, on update of a certain cell, etc. 3. Assign a shortcut key...
  19. migv1

    How to detect autonumbering in Word

    Greetings to all: I am trying to write code to detect autonumbering in Word documents submitted to our report writing group. When detected, I would like to highlight the autonumbered paragraphs so that the feature can be turned off. I have determined that the ListGalleries property is somehow...
  20. migv1

    Row Numbers

    Thanks for the info, PDQBach. Basically, I'm trying to re-establish links between tasks in embedded subprojects in a consolidated master file by using the LinkTasksEdit method (from Project VBA Help): LinkTasksEdit(From, To, Delete, Type, Lag, PredecessorProjectName, SuccessorProjectName) My...

Part and Inventory Search

Back
Top