Search results

Hi use the "&" ie concantenation operator. This will combine the two feilds eg [first name]&[surname] This should solve your problem varun

Thanks Pat But I dont get what you mean, Request you to please elaborate. varunmathur

Hi I wish to hide fields/ reports with null value as the preview with the error message, Is there a way to just say "NO DATA" thanks varunmathur

Hi I have a field for roll numbers allotted to candidates for an examination, They are in serial incremental order but have a prefix of two alphabet which denote his examination centre e.g JD 1045. Is there a way by which I can automate this entry. 'Autonumber' is not suitable as I have no...

Hi I've small database working well in my PC havig windows 98 SE; however it does'nt run on my bosses PC which is on Windows NT can any one tell me a way out thanks varunmatur

Hi! The datediff does'nt work very reliably in my database so I simply use :- ([end date]-[start date])/365 and set the result to zero decimals. It works OK varun

I have a report with 2 group headers and a need to display the numerical data in the detail section in descending order that follows in row format. since the detail section contains only one column I tried arranging the data using columns in the page setup, however this puts all data into column...

Hi, I tried this some time back using this code to convert the sum total in a page footer into words. The problem I faced that was that It worked fine in the print preview of the report but failed to print of paper; There was a blank in the report where the total was supposed to be. Has any...

I'm having a problem:- My reports oriented in "landscape" tend to forget their orientation and open in "portrait", and has to be reorienteted every time I preview the report. varun

Thanks for the help.

I have a table which I populate thru a form, a few feilds are the same for all records entered together eg date of test(not todays date), course etc is there an easier way to do it than having to enter the same data repeatedly. varun

Hi! I've posted this earlier but am hoping to get a better solution to the problem:- I am using access2000 I have report that uses VB to 1) calculate the total in every page footer. 2) convert this number into words. 3) Add 1 to this number . 4) convert this number into words. All this is in...

Hi Place a text box in the report give its control source property as =1, and its running sum property to over group. This will add a serial No field to your report. varun

Thanks Pat and Illhoutx, The codes been a great help. but now a wird problem has arisen:- The running sums and the number in words are correct in the preview mode of the report. but on printing the report the fields are blank or show the value as 00.00. Any Idea why this could be happening,could...

Hi pdx_man My reports page footer is really loaded with VBA.(1) calculates the running sum of a field in the detail section of the page. (2) Converts this number into words. (3) adds 1 to the number (4) Converts this new number into words. I think I am asking for trouble, but I have to have...

My reports contain totals in the page footer which are running sums of the Paid fields of the page. The totals appear correct on screen but when I print the report the total becomes 00.00, Please help. varun

Hi! Try dragging in the Right margin of the report in its design view.Even a small bit extra can result in every alternate page being blank. Varun

Thanks Pat, It works now. But unfortunately the code is'nt too good and it reads some numbers correctly and does'nt some numbers. Anyway thanks Varun

I am using Access 2000. And am making a database to acct for pay and allowances of employees, I need to place the total pay in words in a text box/label in a report.I have written a VBA code which i think should work but I dont know how to make it read the value of a running sum in a report and...

The code works, I think I must be making some error while typing the code. sorry to waste everybodies time Varun