Search results

Thanks for the help jdraw, Just needed to create 2 queries. One as the custRebateDiscount and the other as the partCostForCustomer and put them together in another query and all is good. Thanks again Gazza

Ok here is what I am trying to do. I have 4 tables : TblCustomers Account DiscountGroupID RebateGroupID TblProducts PartNo Description ListPrice TblDiscounts DiscountGroupID DiscountGroup...

Hi all, I have the following sql statement in a query: SELECT TblCustomers.Account, TblProducts.BinNo, "" AS ColumnC, "" AS ColumnD, [Listprice]-([ListPrice]*[Discount])-[Monetary] AS NettPrice FROM ((TblSalesGroup INNER JOIN TblDiscountGroup ON TblSalesGroup.[SalesGroupID] =...

Hi all, I have a continuous form that is bound to a query. It pulls the data from a table if certain fields are empty. If I update the fields that are empty a function is run to check if the data is valid and then moves to the next record. This all works fine if I am working on the first...

Hi Simon, Thanks to your advise I have now sorted my problem. What I ended up doing was adding another field to the table and when the data is imported into the table the function is run and fills in the data for all the records. So thanks gain for all the advise Gareth

Ok, I sort of understand where you are coming from now. If I have understood what you are saying is that the function will only run when the Invoice no is clicked and it will either display the image or tell you that it doesn't exist. The problem is I need my form to only display records from...

Hi Simon, I think I`m being really dumb here but I can`t see how or where I would implement your code so that it will only run once. When I open up the Query that shows all the records that I need and the code checks each record to see if an image exists it opens up straight away without...

Ok thanks very much for the help so far. I have made the changes that you have suggested CJ_London. Simon_MT :How and where would I store a flag for InvoiceExists? I have just created a new query based on the PO045 table containing 1650 records and added an InvoiceExists field as below...

Hi CJ, This is what is driving me crazy, CheckInvoiceExists is a function that takes the value in the InvoiceNo field and checks to see if a file exists with that name. This works fine when I run the original query to. Not sure what you mean by include the relevant table in your query...

Sorry Posted the wrong SQL for the first query. Here it is : SELECT PO045.BinNo, PO045.PartNo, PO045.Description, PO045.Qty, PO045.Supplier, PO045.PONo, PO045.GRNo, PO045.InvoiceNo, PO045.DateRecieved, PO045.Active, TblClaimGroups.ClaimGroupID, TblClaimGroups.ClaimAmount...

Hi all, Hope someone can help with a query that is running slowly if I enter a WHERE clause. Basically I have a query that pulls data from three tables and has another field which checks a folder on a network drive to see if a document exists. This works fine and opens up instantaneously...

Jdraw, Thanks for the reply. The problem I`m having is not so much with the addresses but more with the companies. As a rather bizarre example lets say nokia which is owned by Microsoft(Ignore the name change of nokia for the moment). On our delivery tickets we have a deliver to box which...

Hi all, I am trying to figure out how to setup the tables for the following scenario but am unable to find what I am looking for. If I have a customer(company2) that has an address for goods to be delivered but the invoice has to be made out to the parent company and address (Company1)...

Hi jdraw I could probably use multiple spreadsheets to do this but it wont be very expandable when I need to add some other features this is why I am trying to use access. a) at the moment I for this problem I have 2 tables (TblProducts and TblSalePrices)which have based a query on, The first...

Hope someone can point me in the right direction. I have a continuous form that has 5 columns of data per line and it also has a 6th column that I can enter data into. What I want to be able to do is if I enter data into the 6th column it will copy that record except the 5th column to a report...

Thanks Brianwarnock worked like a charm

I have a table with a field named BinNo which has a list of items with a bin no in the format 1.234( this number can be any number up to 6000.9999). Is there a way for me to have a field on a form where I enter a number (i.e 1) and it lists all the items with a 1 before the decimal point but...

Ok after reading a few bits on the internet I realised that you cant use Dlookup on a continuous form. I have set up a query based on TblPODetails and have added the following Dlookup to the Primary Key Criteria field: =DLookUp("PurchaseOrderID","TblPurchaseOrder","PONo = " &...

Thanks for your patience jdraw. That line should read: So my question is how do you handle receipt of goods from suppliers if the goods are sent in in multiple Shipments but they all relate to one purchase order that you have created? After a bit of reading I think I need to set a recordset...

Ok after alot of trial and error I have got it sort of working except this one bit. I have now added two new tables ( TblPOHeader and TblPODetails), I have done this as I figured that a purchase order isnt actually a transaction until it is received which leads me to my problem. I have two...