Search results for query: *

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

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

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

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

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

How do you return the row number (or ID number) of a task based on the value of a text string in a particular column (e.g., Text9)? I need to refer to particular tasks based on the indicator field values for use in a LinkTasksEdit command. Thanks in advance for any help.

Is it possible to set the global.mpt to be used by Project 2003 Standard for members of a workgroup who will use a template to set up projects in a consolidated master project file? I have a global. mpt with VBA code called from toolbar buttons that automates several functions for users...

Greetings: I've been tasked with creating an Access front end for Project 2003, and I was wondering what file format would be best for database purposes. I have tried saving a master consolidated project file (created by choosing the third option to create a master project file from all sharer...

I have a field in an Excel template where users must type in the current working directory (this almost never remains constant). Unfortunately, the path names are rather long, since we work out of shared network drives. Is there a control I can place on the worksheet that will let users select...

Greetings! I have to record the times when data entry starts and when it ends. I tried using the Now() function to set the ObsStart value - works OK. However, when the ObsEnd value is set to Now() by the click event of the save button, the ObsStart value is reset to the same date/time value...

Greetings, Gurus! I have a user data entry form with 83 separate fields. I noticed that pressing the Escape key (usually several times, but sometimes this happens with only one press) during data entry blanks all the previously entered data. Is there a way to prevent the Escape key from...

I have forms for users to enter dates of projected events, payments, etc. For our purposes, we only need the month and year for these entries. I have formatted the date fields as mm/yy and have tried several different input masks, finally settling on 00/"1"/00;0;_ (since every month would have a...

I've done quite a bit of VBA coding in Excel, and now I have to do the same in Access. Unfortunately, the syntax is very different, and I'm lost at this point. I have created a database of companies with which we maintain service contracts, and users can select from a list of companies to...

Is it possible to have a combo (or list) box appear listing possible choices from a table instead of a blank text box in a [Select] dialog of a select query? This would make it easier for users to enter a valid value to run the query.

Greetings: I've been assigned to set up a database that tracks budget data for multiple projects. What is the best way to automatically update a 'remaining funds' field for specific projects as new items are added to the database? Thanks in advance for any and all suggestions!