Search results

Hi All, I need to generate a number that each time increments by one, that is takes the next number in line. For example I have an OrderNo Field that each time the user wants to create an Order he must first book the next Order Number in the Form. The Order number thus must be unique, in...

Thanks a lot for the help, it worked successfully ;)

Thanks a lot that worked excellent :) Thanks once again :D

Hi All, I need to create a button (SEL) on a form that when selected it TICKS all the check boxes to YES (a field PSelect stored in a Table). This will reduce time for the user, having otherwise to tick all the boxes one by one. Any suggestions about the code, please? Thanks a lot.

Set up DATE criteria Reply to Thread Hey I got the point, but please can you show me the code to go around it, as I am still a beginner. Thanks, very much appreciated. :o

Hey i need to setup a date (Shipment Date) which does not leave the user to enter a date which is less than a months date from another date (Order Date) That is if the ORder date is 17/01/07 it does not leave the user to enter the Shipment Date as 18/01/07, but it must calculate at least 30...

Hi in the Page Footer i have a text box storing the page number of the report. I wish that my page number does not leave a lot of empty space from the bottom of the page. I am trying to set the Bottom and top measurements from the page setup, but it is saving only changes for the Top and...

I need to export a report either in HTML or snapshot so that the Report consisting of an ORDER keeps the same format. However this report has to be signed respectively by the Manager, and so I wish to create a field storing as a bitmap their signature. Is there a method of how I can go around...

Thanks for the help that worked successfully. However I still have another problem with another report. This report is divided into various Footers and it has a Footer named ProformaFooter, and then it has the Page Footer which has the same page coding : ="Page " & [Page] & " of " & [Pages]...

I have a problem with the Page Footer consisting of the Page Numbering : ="Page " & [Page] & " of " & [Pages] It is counting all the pages for example if in all there are 3 pages on each page it shows: Page 1 of 3 Page 2 of 3 Page 3 of 3 However I wish that the last page is not added, that...

Numeric Field when null display tex So basically now the basic concept of transforming null fields into FOC text is working. However I still need to configure out the process of summing up the Total Value. This is because i have a list of Products is the PRICE field is null then it is turned...

Thanks for your help. It successfully worked

Hi All, I have a field called PRICE and obviously it is a NUMERIC field as it need to perform calculations such as calculating Total Quantity * Price etc. At the moment the PRICE is inputted manually by the User on a Form and when it has no Price it is simple left blank. What I wish to include...

HI all, i have a form THE OREDER FORM and on it there is a subform that stores a list of codes and corresponding products for a particular order. Now what happens is that sometimes ORDERS have the same product codes, so what I wish is to see if it is possible in same way or another to copy...

Hi, I am trying to filter a report by Form using combo boxes. On the form it contains 5 combo boxes that according to the user's preference it will filter the report. Below is the code under ONCLICK BUTTON TO SET FILTER: Dim strSQL As String, intCounter As Integer 'Build SQL String...

Hi i dont know whether it is possible to export a report into a jpeg format instead of a snapshot viewer?! My worries are if snapshotviewer is not installed on all PC's, users will find it impossible to view the documents. thanks for any suggestions.

Hi can anyone tell me whether it is possible to filter columns on a report to be able to print only the selected fields?! that is you have a table for example with fields company name , telephone, address, mobile and this develops a report with a list of details, having as column headers name...

URGENT HELP NEEDED - Copying previos data hi can someone check a bit the code i posted, cause i believe that there is a small error somewhere, as it is copying data, but not pasting the data in the table... thanks a lot

Hi, First of all sorry for not explaining well, hope by these print screens you can understand better the idea. Form 1 is a continuous form where it can handle a list of containers. Near this list there is a button called Transit Details that when clicked it opens in another Form that is Form...

hi, i just uploaded a fake example just to see the concept of it. vesselform is the main form (continous records) that when transhipment button is clicked it opens in vessel (form). in the second form vessel on the first record the user enters data such as the port, vessel 1 leaving for example...