Search results

:banghead: You need the subform as well - sorry. Try this one.:)

Do you see the "Click to view estimate" button ?

Import the form MainMenu from this database. Save a copy of your database first, just in case the wheels fall off. I have changed the form to be form view, continuous. Added a command Button to open frmEstimate. Changed the text box names and labels. Access defaults by naming form controls the...

I know this is outside of the original post question but... You have two ways to open the Estimate Form. One is an existing form and the other, is a new form. When opening a new record form, you can have some feature not Visible. The point of a new record is you first must assign a...

Does the same job as you have setup to click on the ID text box control. A Command Button is just more like a normal human action. If you want to trun on your TV you push the onoff button rather then touch the corner of the screen. You have Command Buttons for Exit. I can add a Command Button...

I am on Main Menu. Do you want SumOfPrice to work at stage ? and Quote Date ? Click on ID (a specific Command Button with caption "click to ..." would be more user friendly) and Estiamte form appears. Please run through what you want to happen from here. Sorry if I am a bit dumb but Industry...

I noticed another field name that is a reserved word - Type.

Some observations... tblEstimateDetails doesn't need ProductName. You can query this from tblEstProducts. Units may also be able to be queried. Consider changing Primary Key names to tblEstimatesID, tblEstDetID, tblEstProdID etc. Repeated use of ID could be very confusing when using fields in...

Great country. Roads are quite good:)

In Raglan. Cloudless day yesterday. Overcast and rain today:(

Opens now. :) I am going out for a walk on the beach:cool:. Brilliant sunny day here but Freezing cold. 14deg C. Will have a look at the database in a few hours.

I get an error message when attempting to open the zip file.

If you could attach a sample of your database with non sensitive data, it would help. Often the vba code would start with an SQL to select the data that relates to the record being reviewed. Then the data is processed. This may require more variables being populated - more sqls. Why I...

It is normal to refer to a table for your variables, in code. I assume you are effecting all products qty price the same. Have a table with fields for (eg) QuoteQty and RatioQty plus Primary Key of course. Consider Select Case to handle the calculation.

Thanks RainLover, watching Chevy Chase movie:)

How can you create a table without a primary key ?? Primary key can be a text field (complaint name) but I would think you are better to have it as a Number field and the 2nd field is the complaint name. You can still set the text field to not allow duplicates ie avoid two records for "sore...

You need to set your Table Relationships. Use a Form to hold your Drop Down Arrow (combo box), not a table.

Be mindful of Normanlising your database. This refers to how you set up your tables. Some points I can think of that should be considered in new databases. Don't put spaces in table and field names (any names) Don't use table level lookup fields. Use a Form for this. Name all your form...

Here is the full sql strSQL = "SELECT TBLAPPLOAN.APLPK, TBLAPPLOAN.APLACCDET, TBLLOAN.LDPK, tblLoanIssueStatus.IssueDate, " & _ "QryLoanTotalToPayResult.SumOfLoanTotalToPay, TblRefinance.RefinanceID " & _ "FROM (((TBLAPPLOAN INNER JOIN TBLLOAN ON TBLAPPLOAN.APLACCDET =...

If the result is to create a unique record for an Operation on a Hernia then on your Main Form, you have two combo boxes - left to right. the left combox will select Option One - Hernia. The next combo box will select the sub category and refer to the result of combo box 1 (left hand side). Left...