Recent content by Troogroove

The Form is bound to the DB, and it just shows 1 record at a time. All the fields are bound to the corresponding parts of the DB, so the username box is bound to the username field in the table.

I am trying to add a search to a form, which will search the DB and then return the result to the form. A previous DB that is beign retired soon has this function and works, so i thought I would just copy the code behind the button. [code] Screen.PreviousControl.SetFocus...

I have created a report to return information based on the begin and end dates entered and it returns the data. The problem is that it returns 3 or 4 entries for a month where as i just want one entry for the month. I have a sum calculation in the query to total the total cost. I have set up...

This is going to be a simple one for someone, but it is proving to be a pain for me. I have two collums in a table, one that is a value another is a quantity, i have another field that totals the two fields. This works fine and shows the total but it does not store the total into the database...

I resolved the problem by using some VB, it does exactly what i need it to do. It may not be the best solution in the world but its a start. Here's what I did: Dim varCost As Variant ' Lookup the Cost of an item from the table MI_Products based on what is selected in Product_Lookup field...

This is the SQL i am using at present but it will not function as i think it should. Again this is another skill i have not used for many years and I cannot remember my join function. Be it an inner or outer. SELECT tbl_MI_Products.[Cost (Inc Vat)] FROM tbl_MI_Products WHERE...

I have read that and digested it, so now what alternatives are there to achive the same result?

Ive had tried it in the form but it either gives me errors or returns 0.00 heres the SQL "SELECT tbl_Master_Records.[Product-Lookup], tbl_MI_Products.[Cost (Inc Vat)] FROM tbl_MI_Products INNER JOIN tbl_Master_Records ON (tbl_MI_Products.[Product Identifier] =...

Here are my two tables (cut down a Little) Table1 PK: Record number Case number Product Cost Table2 PK: Product ID Cost Product ID and Product are linked (one to many) I use a drop down in table1 on product to select the product and once it has been selected i then want the cost from table2...

Hi all, It is along since i have used access for anything and I am having problmes getting it to do what i want it to do. I have 2 tables one which hold the data needed and the other is being used to hold a list of products with prices. In my main talbe in which the data will be entered into...