Search results

Lightwave that is brilliant! Thank you. Simple design, and effective. Thanks very much! :-)

At the risk of you guys tellin me to p*** off and learn it for myself, do you think you could spell it out for me?

Thanks guys for all your replies. I love it when severa people start to spitball ideas out... I've read your comments and things are a little clearer now, but I have something else to add to the mix. When I used excel to track and manage my stock I did it this way: A1=Formula B1=Received...

am i right in thinking then that the column i am asking for help with is not possible? This is the third site I have tried this post on and no-one seems to be able to help me. As i sais, everything else in the database is working fine, it's just this one 'function' if you like. i also have a...

Hi guys, I'm nearly all the way through creating a database for the new company I work for and I have hit one major stumbling block. My database is designed as a stock control/invoicing and collection system. It has been a steep learning curve as I am fairly new to access and have never used...

Thanks for your advice, but after watching that video and reading some of those articles it's still not clear to me what is required. Could you shed any more light on it or even give me a starting point from which I can learn to create this column? The database is going to be used as an...

Hi guys, Another problem I need help with... I have a table that contains a list of items. These items are tables, chairs, cofas, tvs and the like. What I am after is a way of creating a column that is like a 'status' column. For instance the values would be 'stock' 'sold' 'scrapped'...

Thanks Curtis that has really helped. Also it gave me something to think about in "normalising" my database, after some *light* reading I see what you mean now. Thanks. Andy

I don't think I explained myself very well.... Table A ID:25464 Product:Table Form A [Box1](Entered by user)ID:25464 -macro or inner relationship or something- [Box2](Auto filled by macro or equivilient)Product:Table Then a few more boxes on form a like:- Date, Sales Rep. ....save...

Hi guys, I'm very new to programming with MS Access and have a ajor issue I can't resolve. I have a form (form a) and in this form I have a box for entering a product ID number from another table 'not the one this form is used for' what I want to be able to do is.... When the ID number is...