Recent content by migv1

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?

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

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

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

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

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

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.

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

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

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

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

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

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

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

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