Search results for query: *

Just for your information: A Proforma is like a quotation, before issuing the actual Order and confirmed by the customer

Hope someone can suggest a way of how to go about this situation: I have a Proforma Sub Form that has a Proforma No with input mask "PI"00/000;0 and then on the Proforma Form there is a combo box, used as a Search Facility for Proformas, having the same input mask "PI"00/000;0 The problem is...

Yes I am closing a form when the report opens. The exact situation is this I have a form (FORM1), where the user chooses the Order No and then another form opens (FORM2) where the user chooses the type of Preview to view and finally the Report Opens. On the second Form i am closing BOTH forms...

Hi yes it is actually referencing a report total within the report detail.. but now what is happening is that it runs the report correctly and when i press from the navigation menu PAGE2, a run time error no 2450 message box is displayed, telling me form not found. cannot understand why it...

Hey maybe someone can help me... When running a report, sometimes I get Formatting Page..Press CTRL+BREAK and then gets stuck. This is happening when the report runs and I have to move to Page 2 or Page 3 of the Report. Any suggestions about it. Thanks.

Hey thanks for your help..It seems that everything is working fine now and I put a checkbox as you told me in the calling form for the user to choose whether to paste the signature or not. All I need further testing now.. Thanks a lot for the suggestions

Thanks for your help both of you.. In fact I managed to create a linked image object on the report and an unbound tect box on the order, reading the current user. thus when running the report it only shows the signature associated with the user. However my problem is that it is giving...

Hi, can you explain further about such point, maybe using an example of how I can go about it, cause I am still new with certain functions... Thanks a lot

Hi all, hope someone can help me with this: I have an Order Form that once all details are filled in, the user chooses to view the Preview (REPORT) of the Order. I have a table called USERS where it stores the USERID thus it is able to configure who is logged in the database. When clicking...

Thanks a lot for your valuable and detailed help. Appreciated. Thanks once again..

Sent as zip Thanks

Thanks I sent the email today... Thanks a lot

No I'm sorry I don't have a website where I can upload... maybe by email?

Can I attach my database where I included the form somewhere? maybe you can give it a look thanks.

yes it is an error ....sorry

I placed it in the AFTERINSERT event not beforeinsert and eliminated all input masks and formats now it is giving me the Order No but when I go to the next field it is not incrementing well..It is giving me the same orderno as before

Private Sub Form_BeforeInsert(Cancel As Integer) Me.OrderNo.DefaultValue = "=""A01-07-"" & Format(DMax(""Right(OrderNo,3)"",""OrderBooking"")+1,""000"")" End Sub OrderNo : Name of the Field (Primary Field : what type of field should I do it?) OrderBooking : Name of Table

I took out the Input Mask, but now on the FORM only the number is being generated such as 1, 2 etc..but in the table it is well stored with the actual format A01-07-001

I put your code in the FORM (AfterInsert)and put the OrderID as autonumber and Primary Key in the Table. But the below is showing on Form: A01-07-__1 A01-07-__2 and should be as: A01-07-001 A01-07-002 However in the Table it is storing the Order No well (i.e. A01-07-001) , it is simply not...

I have a Continuous Form and the first Field of the Form is the Order number having Input Mask "A01-07-"000;0; I want to make the last 3 digits of this field to be written down automatically and incrementing the number, once the user goes to the next line. Thus : Line number one in the form...