Search results

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.

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

Can you please elaborate more on this subject.. I mean the field OrderNo is an Autonumber, do I need to get the DMAX for it?

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

My problem basically is that from the FORM ORDER to the REPORT ORDER the user is linked to the parameter query asking the user to input his intials to view the signature on the report. Then if the user wants to send the ORDER REPORT to the client by email, i made a button that will call the same...

Hi All, I have an Order Form that when the user chooses to Preview the Order Report ; a Parameter Query will pop up, asking the user to enter his Initials if he wants to have a Scanned Signature (stored in a folder as jpg) on the Order. In the Order Report Menu I have created a button that the...

Thanks a lot... It worked perfectly. Thanks

Hey all, I have a form called Orders and have a subform called Orders1. Now in the Orders form I have a check box that shows whether the Order is closed or not. So when the Order is closed it will be ticked. (thus status:YES) What I would like to do is that when Order CHeck Box is YES, both...

Hope anyone can help me with this!! I have a Form where the user inputs the Order and associated with the Order I want to create another form able to let the user choose his Signature. So I have a Table called Orders and a Table called Signatures. How can I link them together? In the table...

Hi all, I need some help with a query in a Report. :confused: I need to group the Total Sum in quantity of a Product. These are based on the: MarketId Product Code Product Flavour Size In the query I am listing all the above fields, thus it is giving me a list of Products that have been...

No can't do that as sometimes Users setting up the Order may be instructed to issue the Order under a different person's signature

Hi all, Hope anyone can help me. I have a form that gives the Preview of scanned Signatures (Jpeg Format, saved in a Table : reference to a folder). The user has to choose his/her Signature from the Form and then once selected it must be inserted in the Preview of the Order (Report). So till...

Thanks a lot for your help MStef, i applied some of the example's feature to my program and it successfully worked. Thanks a lot.

Hi all, I have a form where the user can input the Year and Market and the corresponding Orders for that particular year will show up. (acting like a filter) How can I link the Year with the Order Date? so that only orders related to that particular year will show up!! In the Orders Table...

I have a Form acting as a Reference Form for the user..Thus the user needs to have only READ permission when accessing this form, prohibiting him to do changes neither adding, modifying nor deleting. In the security : UserGroup Permissions there are a variety of options such as Open/Run Read...

Hi all, I have a database stored in a folder, and this folder can be accessed through a Network. Is there a way to protect users from copying this folder to other areas? That is I would like to restrict access from users copying the folder where the database is stored. Thanks for any...

Form accessed by multi-writers Reply to Thread Thanks a lot for your help :)

Hi all, I need some suggestions regarding setting up a form that needs to store Order Bookings by Area. That is for example if I have 12 Areas shall i create 12 Tables as the Order Number has to be related accordingly such as A12-07-000 related to Area 12 and the Order No has to be unique...

Hi all, I need some suggestions about having a FORM that can be accessed by multi-users at the same time (multi-writers). What is the best approach to go about this problem? Thanks a lot for any help.