Search results for query: *

I am stuck on something here and losing hair. I have an unbound text box called "packingfee". I have another text box with a total value in it, let's call it TotalSale. I have 4 PackingFee prices which are based on values in TotalSale. If the value is <1 PackingFee = 0, if it is between 1...

Hi I wanted to add some Terms and Conditions to an access report (a quotation). However, these run to two pages and I wanted to simply tack them on , and force a new page for each. However, I don't know how to add them. I tried simply adding a Label for each and filling it with the text but I...

Once a project is "won" I need to create an Order Confirmation. I want to do this by duplicating the information contained in the "frmEstimate" and it's subform "frmEstimateProductServices" which is a continuous form with many records (items). I have seen Allen Browne's code for duplicating a...

I have a form (estimate) which has 4 subforms. And each of those subforms is a continuous form (say Mobilisation, Installation, Materials and Travel) and items which may be entered on each of the subforms potentially has different cost codes (using CostcodeID). Example: Subform "Mobilisation"...

I am trying to look up a rate which will be based on two conditions. Condition 1 is the ComponentID (in a combo box in a subform (continuous form) and Condition 2 is the RentalPriceBandID(in another combo box called "RentalPriceBandID" but this time in the Main Form. I am trying to populate a...

I have a quotation system in which several currencies can be selected. I have a table for currencies and their rates with a look up box on the quote form for the current rate (one which is periodically updated). However, the problem is that when that rate gets changed, the calculations on all...

I have developed a quotation system which includes items, rates, discounts, quantities and calculated prices. When I get an order from a client, I would like to simply press a button to copy the whole quote down to an Order Confirmation form which can be a) sent to the client and b) used as the...

I have a form "Estimate_Item". On it, I have three cascading combo boxes. I have text boxes on top of them so that I can make the whole thing work on a continuous form. It is code I found and works brilliantly. I choose a Fitting Category, which prefills the next combo box with relevant Sub...

I have read the the faq181-74 and this exactly what I want to do. I want to create a simple user login form with password referring to a table with: UserID; Username; and Userpassword. However, I cannot get one to work correctly and anyway, how does access know who the currentuser() (as per...

I am checking for completed fields within a form in the Before Update event. However within the Form Unload event I am also using open args code to close the form and open the previous form. The problem is that when my MsgBox comes up and I check the OK button, the darn form closes! Can...

I have the following Tables: zmtContactName zmtCompany I have the following forms: ContactName_Edit ContactName_List Company_Edit Company_List Now each company may have several offices and several Contacts. On the Main Form Company_Edit I actually have three subforms: 1) A subform of...

Just to confirm the correct form structure 1) Main Form "Job_Edit" 2) Subform "Job_Edit_JobTask_List (contains a look-up for all the tasks in the table zmtTasks). It is a continuous form. Each record also has a check box which has an onclick event. This onclick event as follows: Private Sub...

I have a form "Job_Edit" with a subform. The subform called "JobTask" is a continuous form and includes a look-up combo box for a range of tasks. After I choose say 4 separate tasks, I can print a report in the correct order no problem because I inserted a text box with control source =1 and...

This one has me stuck I have a main form "Enquiry_Edit". In the main form are several subforms which become visible based on a TRUE click on a checkbox "VapourExtraction" with the following On Click code. The following is an example of one subform [EnquiryVacuumType_Edit]...