Search results

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...

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 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 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

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, 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...

Hey there just a little problem i could do with some help, firstly i have a report which you can select a purchase order and stock code from the same drop down combo box, i have a stock description text field on my form, order line number and the stock code also displayed in a text box on the...

Form Combo Box help please Hey, i have some fields in tables called Order number, stock code, due date and Notes. Now in my form i have made a combo box to select the Order number, but i then want to display in a combo box all the stock codes underneath just that order, at the moment i can...

Hey there here is a very strange situation i hope you can help me with. Me and 1 other IT administrator have the full version of access 97 on our Pc's all other users who need to look at reports and program related to access have MS Runtime installed, My problem is that there are a couple of...

Please help my report problem Hey, ok heres my problem, i have a field in my report which shows the "sum" data in the fields, all this works fine and the report displays correct however. I then went to do a total of all the sum values so i enter in my report in a text box =Sum([My field]) and...

Hey there if i wanted to do an update query to replace every field which has a blank value with a 0 wot would i type and where would i type it thanks rob

hey there i wondered if you could help me i need to substitue any fields in my querie which are blank with a 0 please help cheers rob

hey , k i have a quearie which brings up suppliers names and fax numbers, for any supplier who doesnt hae a fax number i want to enter a "123456789" please help thanks rob

hey there, k im trying to fax off some reports via zetafax im just not sure of the code at the top of tha page i need to enter for zetafax to understand i know it has to be in zetafax font but wot do it type? and wot do i type at the bottom of the report so it knows it finished, thanks for any...

please could some one tell me what are the faxing parameters u enter at at the top and bottom of the page for the fax to send my field containging the fax number is called FAX please help thanks rob

Hey there ive got a report i wish to fax however i dunno wot i type at the top and bottom i know its somet like %%fax but i dunno exact please can u help, the field in my report for the fax number is just called FAX thanks rob.

hey, i think this is a small prob but im not sure how to do it, i have a report with lots of suppliers and suppliers info on, basically instead of lots of suppliers displaying on the same page i would like something that creates a page for each supplier, please help thanks rob