Search results

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 guys thanx very much i went for miles option, stars guys absolute stars 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

Hey, my question is quiet simple, in my report i have purchase order numbers which have notes against them telling the staus of the order. i may get 10 lines on my report for a number such as 011111 and the notes might say "order cancelled" I just want these notes to appear once againt that...

Hey there, well i have a database which shows changes made to a vehicle in our company every day, now i have been asked for a report which shows just vehicles whih were modified last week, so i created the querie and entered the criteria Between Date()-7 And Date() however, they also want me to...

Hey there, well my problems quiet simple but i dunno how to solve it, ive got a list of fields in my querie which show orders we sent off to supplies now i have done a calculation to work out any outstanding purchase orders which was simply ordered quantity - recieved quantity. This querie runs...

Hey, ive got a table which holds purchase orders and a field next to it which holds notes against that purchase order. i then have a form which brings up those purchase oders nd you can enter notes against the purchase orders. my problem is that i have a search button but its very tempramental...

Hey, well i have a table full of purchase orders and i want to be able to append new purchase orders to it without duplicating the originals or deleting them, so i was hoping there was something you could do where it looks in the table and just adds new purchase orders, please help rob

what do u mean by that? please help rob

Hey there, i just wondered is it possible to update a table with data that is not already there. Fo example say in my table i have number 1-10 and those numbers have notes by the side of them, now in my query i have number 1-20 but i dont want transfer all 20 accros i just want the ones i dont...

Hey there well basically heres what ive got to do. Im creating a form so that people can enter notes against purchase orders. I have a purchase order field which is from ym database where all purchase order details are stored and i have a notes field from a table called PO Notes so that they can...

hey there i really need some help i have a table which contains a list of 890 suppliers however i sorted these by one of the fields in the table and i just want to display the first 150 records in a new query or table how would i do this please help thanks rob