Recent content by ANDREW_SAUNDERS

can anyone resolve the cause of the runtime error?

Thanks Harry As I am new to vb code i am having a job to grasp where to put your lines of code I have tried to make a small function "NoToPrint"() but am now completely baffled Perhaps you could give me some more guidence Thanks Andrew

oh It would be useful for you to know where it was falling over when i run the report it cannot find the field "receivedqty"

well I have tried what you sugested and unfortunatly it did not work as did other ideas it prompted ! To make things easier for me to grasp the principals i have made a demo table with ony 4 records in it have called table "Table1 " the field with required number of lables to be...

Hi thanks for replying what I have is some vb code which has been adapted from a function i have downloaded this enables printing of labels on sheet format I have removed the parts that i am not using ie skip blank used labels etc by entering in the code a fixed quanity number it works with...

I am making a label printing database every thing is working ok but I need to referance a specific field which contains the quantity to print i can get it to work by using in the code qytprint= 3 ( or what ever number hard coded) but i need to pick up the corect variable amount from...

hi you have the idia I have to produce a list of personel who are on holiday each week my current idea works ok when the one or both of the two dates fall within the selected week but if they span it it fails to select them !!!!! I an trying to make a function to test each day betwen the...

I have a holiday database where [1stday] and [Lastday] are entered I need to find all records that have a date within a certain week with a date range of Sunday to Saturday I have a problem with my current idea in that if one or both of [1stday] or [Lastday] are out side the selection...

where is the best place to get on line infromation about writing functions ? i have tried with a simple example which works but keep geting "null errors " when opening database form

where is the best place to get on line infromation about writing functions ? i have tried with a simple example which works but keep geting "null errors " when opening database form

hi thanks for the reply i have already tried this but will have another attempt Im i corect in putting the calculated fields into the control scource ? regards Andrew

I have a form developed from an table where the user can input info about dates ie start date of holiday and end date this will be part of a shift patern cover database the form also has textboxes where the dates in between these two apear ( via expressions in the scource field) also it...