Search results for query: *

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

NumberVar SemiColPosition := 0; StringVar LastName := ' '; SemiColPosition := InStr({Your_Text_Field}, ';'); LastName := {Your_Text_Field} [1 to SemiColPosition - 1]; This code worked for me. Hope it helps you. <p>LindaC<br><a...

It sounds like none of your records are meeting the criteria of your formula. Make sure the links between the 2 tables are correct. List the whole table to make sure there are rows on the table which will make it through your formula. <p>LindaC<br><a...

You can set up specific values and restrict your users to these choices. Check out the thread '3 Parameters' in this forum. Malcom explains this nicely.

Have you tried grouping by person. Put the date field in the detail section, right click on it and choose Insert Summary then on the screen displayed choose maximum in the top box and your group field in the second box.

If you make the Excel worksheet an embedded OLE it will print with the report and will change if changes are made through Excel.