Recent content by JINKS

Im no quite sure what you mean, but I have a go. Setup a combo box, choose to enter the values your self and type the name of you reports. on after update for the combo box enter some code like this docmd.openreport [combo] that should print off the selected report.

I Want to change the page setup for a form using VB code, to the following: Margins: Top 5mm, Bottom 5mm, Left 5mm, Right 5mmm. Orientation: Landscape Paper size: A3 Anyone got any ides?

I have a continus formwith values that I want to some up in a box on the form footer. I know this is problebly dead easy but my mind is asleep today. [This message has been edited by JINKS (edited 03-16-2000).]

I want the colour of a value to change to red if it's a minus, other wise I want it to be black. I've tried using VB with an If statement and the me.value.forecolor command but it changes the colour of the entire column. Anybody got any ideas cos it's really doing my head in.

change the calculated field to: [hours/minute]*24*[hourly rate] That should sort it out.

I want to lock all the records in a continuos form but the current one, until certain criteria are met. I now how to us VB pretty well so that isn't a problem. I just haven't got a clue!

The me command won't work because that changes details on the current form. you need to set up a query that search for the entered code. Which then inserts it into the form your using.