Recent content by SandyB

Hi Mihail, Apologies - Check is an annual visual count Plus periodic maintenance visual checkes, Normally as I mentioned they are checked by location, ie LOC 55RL. For search purposes it would be handy to do group parts so that a search by part type can be carried out, ie. Valves, Accumulators...

Hi Mihail, Thanks for the response, normally the stock is checked by location, however there may be times when soething has moved location for whatever reason, ie when it has been out of stores for use then it may not go back to the same location, this is something that we are trying to...

Thanks to every one so far for the comments, and suggestions to help readers understand what I am looking for so here goes. I currently work for an oil and gas company looking after a specific customer, the customer has spares which are held at our stores facility, currently the spares listing...

Loc - This is a location that can be the same for multiple parts Short Desc - ie valve Long Desc - Full Description of part ie valve size and diementions Com - This is a comments field Last Checked - a date field to show when the item was last check Thanks Sandy

Hi I as you mey see from my limited posts I am new to Access, I can create simple databases ok,but now want to get a bit adventurous and create a spares stock list, easy enough, but the problem is that in the DB I will have items with the same part no, but different serial numbers, but I will...

I am a new user to access having had very little exposure to it before and am looking for some help. I have a small db that i created to hold mutile projects stock that i look after. I have started the query and so far it is ok. in the Criteria field have enster [Project Name] this as you all...

Hi Nigel, That was spot on Thanks very much Sandy

Hi, I have a listbox on a form that looks up a table to to allow me to pick a stock location. The table only has 2 colums in it, the Primary Key Field (ID) and the Store location. When using this in a a form instead of getting the Stores Location, all I get is the ID. I have tried changing...

Severin, thanks for the help, I will Havalook behind the db to see how things are. It is very much appreciated. thanks again

pr2-eugin's thanks very much for the pointers - I am from the other side - I certified in Excel now i and begning to i know why. Thanks again

Hi, I have now been able to attach a copy of the DB as was requested Thanks

Thanks that brought it down to 640Kb - more like it.

I am seeing another ptential issue with this BD I have 5 Tables with no data in it yet the DB is saying that it is over 21Mb which i find strange for something with no data Thanks Sandy

Hi as requested I have attached 2 pictures in the attachment drop down one is what is showing in Design View and the other what is showing in Form View Thanks

Hi have checked all properties and visibility is set to Yes on all fields but still no joy