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.

Thanks for the direction.

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.

Thanks so much. I'll be working on this...

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 the "Never Destroy" switching to 12/3000 and "Don't know" switching to 12/2999 but I need help with the date appearing in the field. I used the following switch function in a query: Expr1...

This worked fine...and report output was just what I needed. THANK YOU...but it made me think of a more user friendly way of approaching this field. On the form, I'd like the user to type "Never destroy" or "Don't know" or a date...then have this info changed to a date in a...

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 am exporting it as external file. Type: Text file. Fixed Width to a main frame. I am exporting it from a query. Hope this answers your questions. THANKS.

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

I am encountering this same problem. Does anyone have any insight into the cause. Thanks for readdressing 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.