Search results

IIf(IsNull([Q29]),[Q28],([Q28] & ", ")) Chris B

I assume the notes and labels are reports. In report design view, click page setup then page then use specific printer then pick a printer then save. Should be OK. Chris B

Did you tick Page header Footer or Form Header Footer (Must be form) Chris B

Are they set to visible? What data / labels do you have in the header and footer? Chris B

Not sure what you are up to, but where a control might be empty, if you set the Can Shrink / Can Grow properties to Yes, they won't take up space if they are empty. Chris B

Put a textbox (hidden) called say dateentry1 in the detail section with the control source set to =[Enter Date], then reference this textbox in the report header with = [dateentry1]. Then it should work OK. Chris B

Hold down the shift key as you open the db. Then everything will appear and you can change settings if you wish. Chris B

No idea sorry. I guess though that the Netware program would have options regarding locking the pc which you could turn off provided your admin is OK with it. Chris B

Access is full of such surprises - that's what makes it so much fun. Chris B

You can enter all parameters on the form and reference the queries back to it - e.g. a text box on a form (Form1) called Input1 would be referenced in the query criteria as =Forms![Form1]![Input1]. You might use this just for the initials, but use normal parameters in the query for the rest, or...

Set the first checkbox control like this - Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False If CheckBox1 = True Then CheckBox3 = False End Sub And modify it for the other two. This will allow you to check one of the three only. Chris B

Must watch out for that ..... Chris B

Have a look in Control Panel - Power Options. Chris B

Use the button to open a pop up form. Enter the parameters here. An OK or whatever button on the form fires the required events and the parameters remain available. Last thing you do is close the form. Chris B

In Access right click a macro, click create shortcut. Give it a findable location. Point Windows scheduler at it. Access will open and run the macro. An orderly exit is good. The best way is to open a form with a timer as the last item in the macro, and invoke exit. If you use the scheduler to...