Search results for query: *

I know excel has a feature that allows one to format a number to a desired zip format. However I am using an export report that is dumped in excel. What happens is the number comes over as a text column (ie 232262007). I want excel to read the number as 23226-2007. Yet if the number comes...

Using Office 2000, i created a form with no password. I protected the form, choosing form in the radio selection. I later decided I needed to make additional changes and wanted to un protect it again. However, now the unprotect option is grayed out, which makes no sense. If I protect I...

No there was no password

That is correct. I protected it as a form. And now for some reason I cannot unprotect it. Never happended like that before

I designed a form in MS Office 2000 for Word. i have text fields, command buttons, radio buttons (etc). I then chose Tools Protect Document. Now I want to make changes. When I go back to Tools Unprotect, it is not enabled. I checked the Security and I checked proerties to see if I selected...

Prior to converting our servers to another location we were able to run reports through a crystal report and export that report to a .txt format. We moved our servers, loaded crystal on those servers and now when we run a report using .txt, the report name shows up but the contents are empty...

Using Access, I want to open a word doc located on a particular drive (ie I drive). Lets say the report name is adhoc and it is inside a folder called memo. The path would be I:/memo/adhoc. In my access form using a command button and inside the properties, I want to use an event and say...

Using Access 2000, when I click to open a database in Access, I want to have the form load first, open and have it populated with data I created in a table. I thought I simply would go into properties in the form and do a docmd.maximize to maximize the form and onload, do a docmd.open. It does...

Here is the code gnerated by the input mask 00000\-9999;0;_ Can you explain that further. I placed a # in replacement of the last 9 and that did not get rid of the - in the case of a 5 digit zip code. The input mask is set up to handle a 9 digit zip. What I need is a conditional suppression...

Using the input Mask wizard zip code, I chose the zip code that uses the 9 digit zip code as follows 99999-9999. Some zip codes only have 5 zipcodes. However the output looks like this 99999-. How do I get rid of the - in the case of a 5 digit zip

Using CR8.5, I am showing a pledge and payment transaction as follows: date amount transaction 01/15/05 25 pledge 01/25/05 5 payment It works okay unless the person makes multiple payments on the same pledge. If that occurs here is what happens: 01/15/05 25...

Tell you what, let me take you inside the actual report itself. I may not be explaining myself correctly. Two groups: Gr1 grouped by gift.effdate. Gr2 grouped by gift.acct#. Formula named @sort created with the following:if {table.trans} = "Pledge" then 1 else if {table.trans} = "Pledge...

LLBass your last statemet is exactly right. Lets say a pledge comes in on 1/15/05 under account number 1. Conceivably, a gift could come in on another account number, say accT#2 before the first payment on acct#1 even comes in. What I want to see is a series of pledge, payment, then gift in...

lbass, Thanks for the information, however this is the same as sorting the transaction.type field in descending order. Let me rephrase this and demonstrate exactly what I want the report to look like. The field name is in parathesis date(gift.date) trans(trans) amt(table.amt) acct#(acct.num)...

Using crystal 8.5, I have a financial report that looks similar to the following: date trans amount acct# 01/05/02 Gift 100 1 01/10/03 Pledge 50 2 01/15/03 Gift 75 3 01/22/03 Pledge 50 3 01/25/03...

Using crystal 8.0and 9.0, I am attempting to create a financial report. I have 3 issues. 1. Need to group acsending by gift effective date (gift_field.effective_date). 2. Keep account numbers(gift_field.account_number) together so I can summarize by account number and gift effective date. 3...

skries I am trying to initially group by effective date and then by account number. I want to total all pledges payments and gifts by the particular account number then move on to the next account#, still grouping by date in ascending. Would the advise you gave me still be appropriate

I am trying to keep gifteffdate and acct# together to show a report as follows: date name acct# trans amt pledge balance 1/12/03 J Doe 4100 Pledge 200 1/15/03 J Doe 4100 Payment 150 50 1/19/03 F Doe 3255 Pledge 500 1/23/05 F Doe 3255 Payment 100...

I set up a table in a database called mafishin_Database1. I am using mysql server side and checked and verified that the table does exist. I set up a table called manage.php with the code listed below. It allows the user to put in an email address, choose suscribe or unsuscribe radio button...

I used mysql server side to create a database named Database1 and a table named MyTable. Here is the the code for the input form: <head> <TITLE>Insert Form</TITLE> </head> <body> <FORM ACTION="insert.php" METHOD=POST> <p>Add Text Name<br> <input type=text name="last" size=30> <p><input...