Thank you! It worked (almost) perfectly. I had to change @FooterVar to:
whileprintingrecords;
numbervar Counter;
stringvar output:="";
numbervar Open;
if remainder(Counter,2) = 0 then
output:="C"
else
output:="O";
if output="O" then
Open:=Open+1;
Output
It didn't like have the "Open:=Open+1;"...
What OS are you using? For Windows 2000...
Go to Windows Explore and select Tools > Folder Options from the menu bar. Select the File Types tab and scroll through the list until you see the DOC file extension. Select it and choose the "Change" button below. Select the version of Word you...
I am using Crystal 8.5, connecting to an Oracle database. Let me state from the beginning that there are probably better ways to get at the information that I need but this is what I have. I am willing to rewrite the report from scratch or fix what I have. Any help is very welcome.
I have 3...
Thank you! That worked perfectly! I am going to try what lbass recommended too (just to see the difference and for my own knowledge). You both are great for getting back to me so quickly.
Cathy (a.k.a. Travlnbard)
NEWBIE ALERT! I am using Crystal 8.5, connecting to an Oracle database using a tnsnames.ora file to connect.
I am trying to create a report that will show what calls are open for each user. A single call can be opened and closed several times. So I need to determine the date of the last...
The document was not sent as RTF. But the 2 users involved were able to work around the problem and said to close the call. I am going to let it drop since the problem is on a PC that I do not have ready access to.
Thanks for your help.
I have a user who created a Word document and highlighted text within that document. He sent it to another user (at a different location) via e-mail. The recipient cannot see the highlighting in the document. He tells me there is a checkmark under Tools, Options, View, Show, Highlight...
It turns out that I have other issues with my code but I think that is going to work once I get the conditions in order.
PHV,
Why did you put the & before and after the variables? Sorry if this is a dumb question but I am very new to VBA.
Thanks,
Cathy
I am new to coding in Access. I am trying to filter certain records to my main form. I think that it is simply my syntax that is wrong. Basically what I want is to filter all data for condition3 when condition1 or condition2 are true.
Forms!Main.Filter = strCondition3 & (strCondition1 Or...
Thanks for the info. That did not fix the problem. However, I uninstalled GroupWise (and deleted the C:\Novell folder) and then reinstalled GroupWise and the problem was resolved. Simply uninstalling and reinstalling did not do the trick.
Cathy
Just out of curiosity, can you do a copy/paste into Word? Is there a specific reason to import it into Excel? I have found that PDFs copy very well into Word and then you can edit any data there. Of course the tables in Word would then convert easily into Excel.
Just a thought,
Cathy
Open the PDF in Adobe Acrobat Reader. At the top of the Adobe window you will see File | Edit | Document | View | etc. Go to View > Continuous. That will change the way you are seeing the file and will allow you to select all. Then it is a simple copy and paste, once.
Cathy
Thanks for your help on this.
What I ended up having to do was to Run Regsvr32.exe to Register the DAO360.dll file. Thanks again. (Next time I will remember to click the box that says e-mail notification.)
Cathy
Tranman,
Thanks so much for your assistance. It works great! (And since I have had to it for 18 date field this posting has been a great help.)
Cathy
PS Next time I will remember to mark the post for e-mail notification so that I know when someone replies (duh).
I don't know if it will remove it completely but it may reduce the time that it apears.
Try this:
On the Tools menu, click Options.
Click the General tab.
Clear the Automatically create drawing canvas when inserting AutoShapes check box.
Hope it helps,
Cathy
I have the exact same problem, but I do not know where to type the input field string referenced above. I would like to covert the fields permanently from text to date.
Confused in NY (a.k.a Cathy)
I tried this but Access XP seems to be smart enough to realize that it is more current than Access 2 and it will not allow me to choose Access 2 over it. I cannot associate anything to Access 2.
However, I was able to create a shortcut to Access 2 and modify the shortcut target so that it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.