Recent content by cancer2006

Thanks for the reply.

Hi Guys I would really appreciate your help. Thanks.

Hi guys I am using CRv8.5 and pulling data from MS Access97. I am unable to write the header in csv file. My csv file output is similar to the one in the following post http://tek-tips.com/viewthread.cfm?qid=1451173 I have my header in the report header section. How do I solve this problem...

Did you use any practice test software to prepare for the exam?

I am adding the page break control in the footer section of the report. Will it print a blank page at the end of the report? Thanks.

How would I check if the report is going to be printed on the both sides of the page, If I don't have access to the printer? I did a print preview. But it was as usual. Thanks. Private Sub PageHeader_Print(Cancel As Integer, PrintCount As Integer) If Me.Page Mod 2 = 0 Then...

Hi Can anybody explain what is the purpose of creating a duplex report and what is so different about it? I read the thread number 703-1397286, which was pretty helpful. But I still need more clarification. I have not created a duplex report before. Thanks.

Thanks Madawc and dgillz I have all the latest fixes installed and also placed the header in the Report Header section. However, when I open the file there were only 15 columns written, I have entered information for around 40 columns. Can you please shed some light on this. Thanks

I am using CRW8.5 and Acess97. I have to create a CSV file with 40 columns. I am writing the header info in the Text Box and it is placed in the Page Header section of the report. When I open the file in notepad. I see the header information being repeated. I am not sure what I am doing here...

I am using CRW8.5 and Access 97 The database table looks like as follows: Hours bcode 25.01 VAC blank blank 36.6 PTO I wan the output like as follows: Hours bcode 25.01 VAC 0 0 36.6 PTO Hours data type is number. Following is my formula: WhilePrintingRecords; numberVar nOutput :=...

Thanks for your help.

Using Access 97. Need to select data based on the following condition. Select * From tempTable Where (tempTable.date >= '01/01/2007') or (tempTable.date is null) data type of tempTable.date is Text. When I use the following code Select * From tempTable Where tempTable.date >= '01/01/2007' It...

I am using CRW 8.5 and ACCESS97 I have to select data based on the following condition. Get all the records where date field is null or date >= 01/01/2007 I am coding as follows If is null ({table.datefiel}) OR {table.dateield} >= "01/01/207" Is it possible to do something like this?

I want to adjust the formatting of the telephone number. as "123-456-7890" right now it is displaying as 1234567890. I am using Access97. my database field name is "Best time to call" data type text. How do I change the formatting? Do I need to write a VB code or go into expression builder...

I am using CRW8.5 and access97 Can you write DROP, CREATE, UPDATE, SELECT INTO statements from SQL Designer tool. I am getting the following error ODBC Error: [Microsoft][ODBC Microsoft Access Driver]Cannot modify the design of table 'eaccr'. It is in a read-only database. I have full access...