Search results

I have added a .jpg picture to my startup form, the image on disk is 659k however when inserted into the form increases the database size by 90MB I am unable figure out whats going wrong, help required

I have a small database running on LAN with one computer holding the backend linked to 12 computers on which the frontend runs, I was using windows xp in the computer holding the backend, it ran well but would automatically delink one of the computers and run only 11 frontend users. To overcome...

Hi I need to print bills of variable length depending on the number of purchases, I need to use a paper roll which will print a continuous bill to be torn off when it stops printing without wasting paper in the event of a single item purchase nor split the bill into two if the number of...

:banghead:Hi, I was using a database with a backend in one computer and 10 frontends at various user desktops, it was slow but running well, so I decided to procure a new computer and install Windows Server 2003 to hasten the transfer of data. After linking all the users into one domain and then...

Hi I am using the code minutes: (DateDiff("n",[starttime],[endtime]) returns a number 59356850 instead of the correct answer which would be 11 min both starttime and endtime are General dates need help, what am i doing wrong :banghead:

I am using Access 2007 and have designed a report printing the prescription of the patient, the length of the prescription varies and hence need the printout length to vary accordingly, I use a paper roll for the printout, I am unable to control the length of the printout, it is either too long...

Hi I've a database that I am trying to replicate, the problem is that the macros continue to work in the master, however they do not work in the replicas. Is this a recognised problem or am i missing something. Your help will be of great value.:rolleyes:

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?

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