T
tboyce
I wish to create a database for my brother in law. He installs large CCTV
Camera systems for local Councils, in schools, College's, Industrial Estates,
and such like. Before he gets the job start. He has to compile a quotation
based on proposed cameras, towers and broadcast equipment, this gets assessed
before, maybe being amended before a quote is accepted and then he produces
an invoice to bill the Council. He was producing these documents in Word and
meant a lot of copying and pasting from old doc's to produce the finished
articles. I had done an ECDL Advanced Access course, and thought I could
knock him a database up in no time. Big under estimation of what was
involved. Basically, I created a contact table, Sales, Products and Quotation
tables. No quotation can be built without adding a new contact in the
relevant table first. Then, I copied the invoice table and called it
quotation table as in the business the quotation is built before the invoice
is agreed. Hope you following so far. I was hoping that, by entering the
contact names and products into their relevant tables I could recall this
information without the need to type it in, making the data available to the
database itself. Once I finished the tables I created the forms to input the
data necessary to produce firstly, the quotation record (fields Quotation No,
Date, Customer ID) and a sub table which shows the details of the products
Prod Name, Cost Prod details, qty req, (Line no & Quote no, not shown).
Problem starts here. I created a query just based on the contacts table.
Showing Company Name, Contact ID, Address, Post Code, etc, to enable the
placement of a combo box that uses the query to select and show the company
name (Column 0 bound) with column 1 being the contact id. This is just a
tester to see if I could make it work, which it does fine. Under the combo
box I have placed a text box and entered the dlookup formula to check the
query and return the town and post code. Like so =Dlookup("[Town]",
"QryContacts Query", " [CustomerID] = [cboCompany].column(1)") which it
doesn't, I get a Name? problem. Really I like the idea of a combo box lookup
, as it returns a value much more quickly, still a Name? issue though, like
so =[cboContacts Query].column(4)
I have also tried it on the sub form with the same results being produced. I
don’t see what else I can do, nobody can tell me about combo box lookups or
dlookups for that matter and am stuck fast. Please help me.
Camera systems for local Councils, in schools, College's, Industrial Estates,
and such like. Before he gets the job start. He has to compile a quotation
based on proposed cameras, towers and broadcast equipment, this gets assessed
before, maybe being amended before a quote is accepted and then he produces
an invoice to bill the Council. He was producing these documents in Word and
meant a lot of copying and pasting from old doc's to produce the finished
articles. I had done an ECDL Advanced Access course, and thought I could
knock him a database up in no time. Big under estimation of what was
involved. Basically, I created a contact table, Sales, Products and Quotation
tables. No quotation can be built without adding a new contact in the
relevant table first. Then, I copied the invoice table and called it
quotation table as in the business the quotation is built before the invoice
is agreed. Hope you following so far. I was hoping that, by entering the
contact names and products into their relevant tables I could recall this
information without the need to type it in, making the data available to the
database itself. Once I finished the tables I created the forms to input the
data necessary to produce firstly, the quotation record (fields Quotation No,
Date, Customer ID) and a sub table which shows the details of the products
Prod Name, Cost Prod details, qty req, (Line no & Quote no, not shown).
Problem starts here. I created a query just based on the contacts table.
Showing Company Name, Contact ID, Address, Post Code, etc, to enable the
placement of a combo box that uses the query to select and show the company
name (Column 0 bound) with column 1 being the contact id. This is just a
tester to see if I could make it work, which it does fine. Under the combo
box I have placed a text box and entered the dlookup formula to check the
query and return the town and post code. Like so =Dlookup("[Town]",
"QryContacts Query", " [CustomerID] = [cboCompany].column(1)") which it
doesn't, I get a Name? problem. Really I like the idea of a combo box lookup
, as it returns a value much more quickly, still a Name? issue though, like
so =[cboContacts Query].column(4)
I have also tried it on the sub form with the same results being produced. I
don’t see what else I can do, nobody can tell me about combo box lookups or
dlookups for that matter and am stuck fast. Please help me.