Search results for query: *

My goal is to eliminate the question on opening a workbook concerning updating linkage. I want to unlink a workbook but could not find a way. I suspect that is surpose to be for my own good. How do I find what cells are linked since my next idea was to find the cells that were linked and cut...

Has anyone tried passing a Muitiple Parameter to an SQL Stored Procedure? If I create a stored procedure that requests a parameter, Crystal 8 doesn't seem to allow you have a multiple pick list. Is this the case. Much appreciated.

This seem as if it should be an easy task. Daily exteral data will be imported into a table in the database. When importing, I would like the date to appear in a field [date]. Can this be done at the table level? I would appreciate any ideas. Thanks.

I have a query that includes Fname, Lname, Address. I need to export these fields without commas or any punctuation. So RD. 2, BOX 72 should be exported as RD BOX 72. I am not a programmer so if code is needed, please be specific. I thank you for considering my problem.

Does anyone know if Access has a db template for shift scheduling...I am looking for a employee scheduler and thought perhaps Access may have something in place. thanks for your help.

I have a destroy field set up as type :date/time. I can set up a query to get the destroy dates that are < now and also query the 12/3000 &quot;Never destroy&quot; and the 12/2999 &quot;Don't know&quot; date. How do I get the &quot;Never destroy&quot; and the &quot;Don't know&quot; to show up as...

Keyword search is down so I don't know if this was covered before. In a subform, in datasheet view, can the header column names be changed or are they the field names? Thanks for any insight.

I would like to send multi-files by e-mail. Rather than using Outlook directly, I tried to select the multi-files in &quot;Windows Explorer&quot;, right clicked to bring up menu, and then selected the send to: mail recipient. So far so good. It opens the Outlook Message box with the files...

I do technical support for Microsoft Office---and came accross a question I need an answer to...please. A user in Word creates many similar reports. She starts with the old report and updates the text. The charts created in Word also need updating but sometimes the even though the new chart...

I am converting an Access2 databassse to Access '97. A query is setup with the field-- total: Format(nulltozero([payrate])+nulltozero([tapes]*[payrate])+nulltozero([postage])+nulltozero([attamt])+nulltozero([otheramt]),&quot;$#.00&quot;) I can not open the query in Access'97. The error message...

I need to export field a phone field from a query as fixed field text file. How do I make it a 12 character phone field that will export with the format 999 999-9999. Even though it shows up fine in the query, even if I put a mask on it and say to store with space and dash, it reverts in the...

I need to export field a phone field from a query as fixed field text file. How do I make it a 12 character phone field that will export with the format 999 999-9999. Even though it shows up fine in the query, even if I put a mask on it and say to store with space and dash, it reverts in the...

I have 4 Fields from a query in a report. [Name][#Contacts][#NonProductiveContacts] [ContactRate] All the fields come from a query. Contact Rate is a Query calculation. In Name footer =Sum[#Contacts]and =Sum[#NonProductiveContacts] for totals. I need an average of all the rates in this...

Projects and hours are entered into a database for up to 200 employee for any given day--I would like to periodically archive these records just in case we had to go back. What is the easiest way to set up for the end user to archive. Thanks for all suggestions.

I have created a dynamic crosstab report by using the sample in North Wind and made the relevent changes. I have the calander form for the date parameters, the query and the report. I have my column heading as dates and the row headings projects. The values are hours from this query expression...

On a Powerpoint presentation slide that has a bar chart and drawing shapes such as circles with text. The chart,circle and text show up in in slide view but the circle with text is not visible in On-screen show mode. Any ideas what the problem may be. Thanks.

I have a query of 6 fields and in access 97 select Tools/Link it with MS Word 2000. I select Link it to a document all ready created. I get the overflow message when it tries to open the selected document. There are only 120 records in the test data...and my machine is...

It seems that 2 (of Many) personal folders are missing. If I go back to the backup tape, the old pst file will overide the new information (of Many). Any suggestions of how to proceed????Can I backup to another folder and get Outlook to look at the folder just to print out the info needed? Thanks.

I have a query based on 2 tables.&nbsp;&nbsp;Emptbl, Availtbl. They are related by EmpNo field. When the empno is typed the name field fills in.&nbsp;&nbsp;<br><br>I need to get all the records for certain fields to export to a text file. Join type 2 gives me the records but does not populate...

I have a criteria in a query to bring up employees hired 30 or more days ago.&nbsp;&nbsp;&lt;=Date()-30 in the hire date field.&nbsp;&nbsp;It works on my machine at home but not the one at work. I get the error &quot;Expression is typed incorrectly, or it is too complicated to be...