Search results for query: *

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

Initially, I did not had the guidelines and all the fields were all the way to the left. The report is still showing the data in column B in excel and column A is blank. Thanks for the prompt response.

All the column header and fields are aligned using the guidelines from left to right

I am using CRW8.5SP3 and Access97. I am trying to export the report in excel8.0 extended format. When I open the file there is a blank column added to the front of the report. Which has to be deleted every time I open the excel file. Data wise the report is ok, Report is also fine in the CRW...

I am working in access97 need help in writing a query Table1 has two columns with ID and NAME. Table2 has has two columns, ID and CHECKDATE. In Table2, there are multiple checkdates associated per ID I like to run a query which will give me the highest checkdate on each employee in Table2...

I am using CRW8.5 and Access97. Is there a way to run sql statements from CRW8.5? I have to run about 10 or more sql statements and output the results in table. Then write my report off that table. Thank you.