Search results for query: *

I have a report which has several groupings. Header 1A - I want to print only on the first page of the group. Header 1B - I want to print on the first page of the group AND on the remainder pages of the group. Header 2 - print once on each change. I have been attempting formulas in the...

I want to know if anyone knows how to automatically update the subject line on Meeting Requests. We are using Outlook XP and Exchange 2000. I am setting up Mailboxes for my conference rooms. I know how to have the conference rooms automatically accept or decline meetings. However, we want to...

I am wondering whether anyone else has found a problem with Comparing two documents? I can compare the exact same two documents in either Word 2000 or WordPerfect 9 and get appropriate results. However, when performing the Compare and Merge function in Word XP the results are not usable. What...

I have a database where I have been attempting to relate cases with Attorneys and Insurance Information. Right now I have four tables: tblCaseInfo -txtCaseName - primary key -txtClientAndFileInfo -other text and memo fields tblAttorneyInfo -txtAssignedAttorneyName - primary key...

I have several databases that I would like to use out of the templates folders similarly to what you can do in Word and Excel. I want to open an empty / formatted database when the user clicks on File, New - General Templates and immediately force the user to name it with a unique name. Does...

I am using Word XP and need to get rid of the listing of reviewers. In Word 97 or 2000 all that was necessary was to accept all the changes to a document to "clean" the document of those types of items. Then just to be sure, we would copy the text into a blank document. Now in Word...

I have been exploring Access 2002 and have found something, that I have not been able to get an answer about. Perhaps someone here can point me where there is more information. I have created a macro that opens a form. I can attach the macro to the onClick event and have the form open...

I have had to modify someone else's form (they are no longer employed by our firm) for a logo change. Now, when the end user executes the Format, Envelope feature in WordPerfect 9, WP finds the address in the tabled letterhead area of the document. Previously the letterhead was also in a...

I have created an AutoText entry. Due to formatting requirements (columns) I want to end the AutoText entry with a Continuous Section Break. When I save the New Entry, and then attempt to use that entry; my Continuous Section Break converts into a Next Page Section Break. Any suggestions?

I am attempting to create a Function for Access 2000 to compare quite a few date fields to decide whether a job is late or not. I have created the following function and am attempting to run from a Query using the fields in the Query to populate the variables. When I run the code, I get the...

I have created the following formula to filter my data out. What I am attempting to do is to show the job only if there is a current problem. I have setup the formula to reverse the workflow. ie. The last task to be completed is tested first. if {FactSched} < currentdate or {FactSched} <...

I have created the following formula to filter my data out. What I am attempting to do is to show the job only if there is a current problem. I have setup the formula to reverse the workflow. ie. The last task to be completed is tested first. if {FactSched} < currentdate or {FactSched} <...

I have been having problems connecting to an Access 2000 query utilizing the ODBC drivers. Therefore, I ran SQLCON to see what it could tell me. Now I am more confused!!! The information that came back is: SQLDriverConnect Successful [Microsoft][ODBC Driver Manager] Invalid connection...

I have been having problems connecting to an Access 2000 query utilizing the ODBC drivers. Therefore, I ran SQLCON to see what it could tell me. Now I am more confused!!! The information that came back is: SQLDriverConnect Successful [Microsoft][ODBC Driver Manager] Invalid connection...

I am wondering if I am hitting a security issue to the database OR if there is a problem with my ODBC drivers. I can get to the tables and use them to create the report. I get the following error when I attempt to use one of the queries that I have created in the Access 2000 database: ODBC...

My End User wants a report that will show him the Work Centers that are late. No problem. I created a query to extract the information and indicate whether the Work Center was late or not. My Data is as follows: Job # Work_Center Act. Start Sched Start 10302 PURCHAS 6/3/01...

How can I get a bottom border to show up on the report when the data field is empty? I want to see a blank line for blank data fields on the report. Any helpful suggestions? I chose not to draw lines so that I could avoid the hassle of lining them up across the report since I could not get...

I have created a simple database (5 fields and 38 records) in which I have then used the Pivot Table Wizard to create a Pivot Table and Pivot Chart. I have published the PivotTable to the Web, and can successfully interact with it. The problem occurs when I attempt to import the pivot.htm...

How do I easily split a field into two seperate fields? For example Smith, Jane parsed into two separate fields: First Name = Jane Last Name = Smith And then how would I do it if the data is NOT separated by commas? What is the syntex. Someone told me I should use the TRIM function...

I have created a report that does not use the Access 2000 default of 1&quot;. When I call the report from a command button in the form via VBA - for some reason the VBA resets to the 1&quot; margins. What is the syntex that I should use to get the report to maintain the .5&quot; margins...