Recent content by Ian-W-

Thanks, I just seperated the coloumns into two. One for type i.e Pentium 4/AMD and one for speed which I made into a number. Works great now Thanks

Hi, i've just done an audit of all the hardware in the company. I want to run querys to say for example find all PC's with cpus's over 1000MHz I currently have like"*"&[Enter CPU Speed]&"*" this only displays records if you enter the exact figure. I have tried >=[Enter CPU Speed] but that...

The stock code, description etc are in a table. I tried using combo boxes but the problem with them is that I need the form to clear when I move to my second record. When I tried using a combo box the main form moved to a new record but the combo box kept the same data.

Hi, im creating a database for my company, im by no means an access whizz and this is the first db i have created. It is working but i know i could get it alot more streamlined.... heres a screen shot so i can explain what i want to do... I want to be able to click the drop down stock code...

Sorted now boss. I had the field set as a number and then the format as currency. I just set the filed to currency and it works. Thanks Ian

Hi, I'm creating a stock tracking database. I need to enter weekly rental charges such as £1.35. When i enter £1.35 it is rounding it to £1.00 If i enter anything over £1.50 then it rounds to £2.00 I need it to show the exact amount, how do I do this. Thanks Ian

Thats like what im after! Now just to work out how it was done. Cheers Ian

sorry, I didnt make that very clear, Lets say I have 6 boxes Customer Name .............. (this is the drop down box) House Number ................ Address Line 1 ................ Address Line 2 ................ Post Code ................ Tel No ................ I want...

Stuck..... :confused: Ive been given the task to create a database for my company. I have to create a database to handle rental furniture, i have the basic tables sorted but im stuck because I know what i want to do but dont know what it is called :confused: I have a table named...