Search results

Hi I would be greatful if someone could explain how the add picture button in the employees form of the Northwind database works. I'd like to have a similar button in a form I am trying to make. Thanks Varun

Hi, I need to insert JPEG format photos in the OLE feild of my form, The photo does not show on the form or the report, only the path is shown. However with a .bmp photo the photograph is displayed. Is there a way to overcome this problem THanx

Hi I need to make a report on based a crosstab qry, The qry has column headers which vary frequently depending on the state the application is used in. The report i generate initially fixes the column headers and then does not accept any changed headers once the crosstab qry is run using...

If the value is $1.32 I need to round off the figure in the currency field to read $1.30 and not $1.3, how should I go about it?

increment fd hi try using two field one with just the preffix and the other with the regular increment field then use then together to get C1,C2 etc by concatenation. varun

page size setup problem Hi The problem is the page set up which i am not getting right, the printer is using a roll of paper, and even if the bill is just two enteries long it still roll out full 11.5 inches of paper, what settings must i give to stop the printer from spewing out excess amt of...

parameter Hi I use a text box in a form and give its address in the query parameter, so dates entered in the form are used as parameters and in the report place unbound text boxes whose data source is set as the text boxes in the form from which the parameter qry draws the dates. hope this sort...

Hi I am facing a problem with the page set up of a report in my application, The report prints a bill of items purchased, what should the page size settings be so that the report adjusts its length to include all the items on the bill on one page and does not waste paper in case the billing is...

Hi I need to format my report in 7-8 columns per page, The problem is that the columns must be restricted to the detail section and not invovle the group headers so that they form sort of separate paragraphs on the page preceeded by the group header. Help will be great!:D varun

Hi My application requires that 4 digit incremental numbers be allotted to candidates. e.g 0001, 0002 ......0010 and so on. How can I get an automatically incremental field. Your help would be greatly appreciated varunmathur

My application produces a list of successfull roll numbers of a examination. The report extends over 15 to 16 columns; It looks ungainly and occupies too much space. Is there a way to print the list of successful candidates in a row format separated by a "Tab" space or comma and "Word Wrapped"...

I have an application which act as compendium of documents and searches for documents based on Keywords. The no of hits are seen in the in the cout of record at the bottom of the form but i wish to customise it to make it more prominent How should I go about it Thanks Varun

Hi I need to provide the database with an option to open one of the two forms depending on whether the user is a new one or has visited us earlier, Since the user is'nt a primary key, I just register the name and time the user visits the database. Any suggestions how could go about it. Thanx in...

Hi I had a similar problem; I used a form to show the desired message and closed the form either with the timer or command button varun

Thanks, but crosstab queries dont solve my problem- The report is require to output a list of successful roll numbers sorted subjectwise. The result requires that they be printed in ascending order 10 Roll numbers to a line from left to right. tricky but I am sure is possible varunmathur

Hi I need to print a report with figures laid horizontally instead of vertically, is there any way of doing it. (Similar to what paste special- Transpose does in MS Excel). Thanx in anticipation Varun

Hi I am using a no of forms/Reports containing the same fields and design to output/obtain data from different queries depending upon the users choice. Is there a way by which I can change the source of the form/Report at runtime depending on the users to choice to obtain data through a...

Hi Thanks the code worked just fine. varun

Hi I need to calculate the age of student in years ,months and days as on a particular date; I manage to get the years and months part correctly but the days do not calculate correctly. Any help would be appreciated. varun

Hi In the 'lostfocus ' property of the combo box place a macro which will set the 'visible'property of the controls you wish to make visible to 'yes' depending on the selection in the combo box. varun