Search results

Thank you Curtis, this seems very handy. Tim

Thanks Adam, with a little playing that worked. Curtis, if you are up for it, could you explained how to use the tag property to exclude a particular control from a group of controls, it seem like a useful thing to know. Thanks

Can some one tell me if there is a way to exclude a control from this statement 'Loop through each control on the form to get its value. For Each ctl In Me.Controls With ctl Select Case .ControlType Case acTextBox .SetFocus I tried...

Thank you both this helps. Tim

It's a search form and depending on what I'm using it for the E.P is usfull or not. Now the E.P is exacuted on lost focus, I could move it to on click so that I can tab, but I'm trying to learn vba and wanted to see the code that would do this as it seems like a vary usefull thing to do.

Guirg, maybe this will help, it would take a little reworking. I have used it as a foundation for a searh tool a number of times. http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=12024&d=1135634856

I have a form with texts boxes and comboboxes, some have event procedures behind them, is there a way to turn an E.P on and off with code behind a command button or check box. I have looked in my begining vba books and googling but no luck, Thanks

Sorry, first time here, realized I posted in wrong place. Thanks for the heads up

Wait I was puting it in the wrong place I did as you suggested and it worked Thank you pbadly Sub Command0_Click() On Error GoTo Err_cmdDelete_Click Dim SQL_Text As String SQL_Text = "Delete * from Equipment WHERE DemoID = Forms!frmDelete!TxtDemoID" DoCmd****nSQL (SQL_Text), acEdit Dim...

That's what I thought but it's just ignored

Hello, I have a small form with a txtbox and a command button for deleting records from a table, it works well but I want to add a reset phrase so the txtbox will clear after the delete and refresh the form, the code behind the button is Sub Command0_Click() On Error GoTo Err_cmdDelete_Click...

Hello, I have a small form with a txtbox and a command button for deleting records from a table, it works well but I want to add a reset phrase so the txtbox will clear after the delete and refresh the form, the code behind the button is Sub Command0_Click() On Error GoTo Err_cmdDelete_Click...