Recent content by LindaC

Thank you both for the info. I have managed to take code from my Main Menu form and create a .bas file and it works correctly :-) LindaC lcastner@co.orange.ny.us

Hi Craig, Thanks for the info!! Is there a difference in the code/syntax between the form, a .bas program and a .cls program? Yes, I am learning VB on the fly :-) LindaC lcastner@co.orange.ny.us

Hi All, I am writing my first VB program and could use a push in the right direction. The Tax Map Dept. keeps track of all property sales/ownership and land changes for the county ie when a parcel is split. When the project is complete the program will manage 2 data bases for the Tax Map...

That is the way I would handle it. Break up the hours into 24 groups; then total in group footer; display group footer and supress details. Good Luck!!!! LindaC lcastner@co.orange.ny.us

I would create a formula to group the hours. ie if yourtbl.hr > 12:59 and yourtbl.hr < 2:00 1 else if yourtbl.hr > 1:59 and yourtbl.hr < 3:00 2 ect... I would then group on that formula field and place totals in the group footer and supress the details...

I had s similar problem yesterday. Using 'Database' then choosing 'Set Location' I changed the location of the database to be the same location as the .exe file. I then copied the .qry file to the location I indicated in the report. Works fine now. LindaC lcastner@co.orange.ny.us

Bring up your sub-report to edit it. Click on 'Database' and choose 'Show SQL Query'. You can now edit the SQL code. LindaC lcastner@co.orange.ny.us

Hi! Have u tried going to the Section Expert, select the Page Header section, click on the suppress formula button, and enter OnLastRecord. I am not sure but that may work. LindaC lcastner@co.orange.ny.us

Saboni, First group your report by 'Id'. Leave the details as they are. Right click on each of your fields and insert a summary for the string fields and a sub-total for the numeric in the group footer. In the 'Section Expert' supress the printing of the detail section. LindaC...

Hi Savoc How about grouping by classid and then putting a count field in the group footer. LindaC lcastner@co.orange.ny.us

Hi Sergio, Have you tried to suppress the Database field if it is null or equal to spaces? Right click on the database field and choose the 'Common Tab'. At the top of the window is the suppress formula button. Click that and enter the formula: IsNull(Database field) or Database field = '...

Hi Bujin, Below is a copy of a more complicated if statement I have in one of my reports. if {RISK_MANAGEMENT_PROFILE.RISK_STATUS} = &quot;A&quot; or {RISK_MANAGEMENT_PROFILE.RISK_STATUS} = &quot;&quot; then 'ACT' else if {RISK_MANAGEMENT_PROFILE.RISK_STATUS} = 'S' or...

Hi JonBartels, I don't know of a function in CR to change a string in that format to a date. I would build the date in a formula and then sort the formula. I would create 3 formulas 1(Month), 2(Mon_to_Num) and 3(mmddyy) to transfer the month to a number using the String function Mid...

Hi JanTro, You can add a second table to your report by choosing Database|Add Database to Report and follow the prompts from there. You will need to link the two tables together by a common field. As far as concattenating the fields create a formula: Table1.field1 + ' - ' +...

Hi Sharon, Go into the Section Expert - Format|Section. Highlight Header B. Click on the Suppression Formula button. Key 'OnLastRecord' or choose from Functions box|Other. Header B will not print on last page. :) LindaC lcastner@co.orange.ny.us