Recent content by Access_help_rob

thats awesome cheers man thanks rob

Ok i have a field called text01 which basically is a afield i have put together which says "Old stock code do not use, use 012345" Now thats the description for some stock codes but in this query im bringing in stock code and description, but i dont want to display any stock codes where the...

I have some data which appends to a table now in the table where the sourse is held i cant change the data structure at all. Heres whats happening a number like 5.543 is in my source and when it append to my new table it still appends in that format even though ive changed that field to number...

Mile this didnt work as if i have 0.75 i want to see -0.75 where as multiplying that field my minus one give me -3.50 any help cheers rob

I need to put a minus sign in front of my figures in a query but i cant change the underlying table as i am going to append the negatives to a new table any helpadvice would be great to how i put minus signs b4 them. thanks rob

Hey, wot i need to do is to put the changes into a new table so i have a before and after. So ideally im thinking put all data in the subform to my new table then comapring them to show the changes in a query, however i cant get the data in the subform to append to a different table, please help...

Hey guys, well basically i have a form which runs off a table. the data in the table is basically records of times people have booked to a job. Usually through the form people would change hours booked to a job etc and it would change on the underlying table, i would like the changes to be...

Hey, i have some data on cars like Make, model, engine, gear box, electric windows and so on, Now what i want to do is to some how be asked questions like you would with criteria selection. A car would spec would then be displayed which is selected from my answers. However i simply tired putting...

hey mile, alls i have done is go to design view of queries and see if there is a link to that table, i have done all of them now so it should be ok cheers mate rob

hey im trying to find out what queries reports or table etc use data or have links to a certain table in my database, is there a quick way to do this or is it a manual job of going through all queries, table, report? thanks for any help rob

cheers mile, i decided to just combine the fields together to make a unique number rather than messing around with cascading boxes but thanks for your time i appreciate it do u have msn? rob

Hey how would i combine to fields to make it eg, Purchase order is 1 field and line number is my second so instead of haveing saying 12345 as order and 0003 as a line number my combined field would read 123450003 thanks rob

hey, im not sure how to do cascading at all but wot would be nice is if i select an order, that it would display all the stock codes in that order ? please advise me how to do this thanks mile rob

Hey, my problem is on a form i need to enter purchase notes against lines on an order so i need to be able to select the order and then the stock code so i can enter notes against it. At the moment i have on combo box from one table which shows order number and stock code, but when u selet a...

Form/subform Help please Hi, i have a form which is linked to its a sub form via purchase order number now, on the main form there is a combo box which you can select purchase order number and a stock code on that order from the same drop down box, when you select the purchase order and stock...