Search results

Hi to everyone, I am building an inventory database for parts that go into producing a product. I have a parts table, goods in table and a goods out table. I also have a 'Transaction query' that takes goods in and subtracts goods out to produce a stock level. This is all very basic and works...

Thanks Statesman for that. It does work well. Cheers Graham:)

Good evening, I have seen a number of questions asking the same question but not one that fits my needs. I have a query that I need to select a number of criteria for. I have lots of parts that make up sets. I want to have a form with a list box that lists the set names. When one is selected...

Hi Just a bit of an update. I have tried this on another PC and it works correctly. No problems at all. Any idea why? Thanks for everones help. Graham

Hi Sorry I did mean the one I didnt want. I have tried it on the same query with another field and it does the same. I might have to start again with a different numbering system.

Hi Again Without the criteria set it works perfectly includung the customer I want but as soon as I put the criteria it stops at 14999. I have also recreated the query but it does the same.

Hi PNGBill Thanks for getting back to me. I have never used the 'not' before and it does the same as <> but the number problem is still the same. There is at least another 30 lines after 14999 but they are not showing. I am at a loss with this one. Graham

Hello to all. I seem to have a problem with a Query that does not want to play ball !! I have a table with a primary key autonumber being the unique serial number for a form. I have made a query from this table using all the field from the table. In the customer field I want to exclude one of...

Thanks for that Brian I see how it is done now. Kind Regards Graham

Hello to All. I have two problems which combine to make 1 big problem. 1. I am importing data from an Excel spreadsheet. One of the fields is a date field. But not just a date but a time as well. 30/04/2010 13:33:47. I dont need the time part. In my database I have a query which asks for a...

Hi Kryst51 Thanks for getting back to me. No havn't donethat although I did think I might have at first. I just seems to remain a mystery to me like a lot of access Graham

I have 2 tables linked by a one to many relationship. I have a number of queries and forms using this information. No Problem. I now go back to the tables one is OK the other has fields missing. Design view displays the missing field. Even the forms that use the 'missing' fields show the data...

Hi to all I have a query which I nee to select records from a certain date. I would like to use a 'date picker' control to select that date. I have looked through this form but can't find an answer. I have tried to use this in the criteria on the query ' [Forms]![Form1]![text0]' with a form...

Hi David Many thanks for looking at this for me. That will link the tables thanks. But I need a record on the costings table for each of the part numbers so that I can enter the hours. There are 61 PO records but the Form 'Table1' only has 21 records. Each day when new records are appended to...

With Attachment ???

Hi David Many thanks for looking at this for me. I have attached a cut down version as there is so much data. You will see that I have tried a Linked table as well as an 'import and append' but when they are updated the other 'Costings' table remains the same size until manually increased. I am...

Hi to all Can someone help or direct me in the right direction please ? I have a large table linked to an Excel spreadsheet with 30 or so columns. The Spreadsheet changes on a daily basis so the Access table also changes. No problems there. Where I am having problems is trying to get other...

Thanks once again Brian. I have been able to do what I wanted to do with your guidance. Graham

Hi again Brian Sorry to cause confusion I did not complete the requirements. Yes you are correct I do want a list of single POs so that I get a single list of Lot Numbers against each PO. I will have a look at the site you gave me and get back Thanks once again. Graham

Hi Brian Thanks for getting back. This link did not seem to work though. I think it might be cascade the combobox but I need to get single POs. I can do this manually in the query by using the column filters but I need to do the same in the Form. Or am I asking too much. Graham