Recent content by Brum

Thanks a lot R! That completes my project! Woo-hoo! Andi

Private Sub cmdDelRcd_Click() On Error GoTo Err_cmdDelRcd_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_cmdDelRcd_Click: Exit Sub Err_cmdDelRcd_Click: MsgBox Err.Description Resume...

Man I´m useless. This should be my last question on here (for a while!). My form won´t delete records. I used the command button wizard for a "delete record button" but for some reason nothing happens when you click it. Am I missing something obvious?

Thanks a lot guys, I'm sorted now.

The DoCmd.Minimise only works for the form the code is in. Or at least I can't seem to find a way to make it apply to a different form. I think the answer lies somewhere around this sort of idea though. Anyway, thanks for your help (so far!) guys. Andi

Not quite. I have a modal form running in the background the whole time which blocks the user from seeing Access. But I also have a command button (on a different form) that opens up a report. With the modal form open, the user can't see the report. So what I'd like to do is minimise the modal...

Hi, Any idea how I make a form/report maximise (and minimise) through the click of a button on a different form that's open? It sounds an easy question but I'm struggling! TIA Andi

Quality. That did the job. I tried that before, except I forgot the (apparantly- I don't understand why) important step of renaming the combo box. Which defaulted to a lookup table which was the thing that scuppered my system. So thanks a lot LQ!

I might be way off but can't you just click Tools|Options and on the view tab check the box for "hidden objects"?

Hello people! I got a problem. I have a form with a drop-down box ("StockCategory") with 10 options on it. I also have a command button ("cmdCables") that is only applicable when 1 ("Cables") of these 10 options is selected, but makes no sense when it's any of the other 9 options. What I'd...