Search results

I have some code in the open event of a form that opens a msgbox but the msgbox takes focus and has to be acknowledged before the form appears. I would like the form to appear first and then for the msgbox to automatically open. Is this possible?

Went with DLookup for now, effectve and easier for me. Thanks for your advice. Code for reference:

? Seems to work either way Galaxiom. David - form is unbound, does this mean DLookup should still be used?

Hi I’m attempting to open a form at a certain record where the value of an unbound textbox (txtBarcode) is equal to the primary field (signinID). All works well until I attempt to modify the OnLoad, OnOpen events etc of the form that I’m finding the record within...

Could you post a copy of what you've got so far - sounds like a referencing issue and you'll gather from my post I'm no expert but I'll give it a go.

Thank you for your very prompt and effective solution. Did the trick, for info: stLinkCriteria = "[Field1]=" & "'" & Me.Parent.[Field1] & "'" Did play about with Parent but was using a ! instead of a full stop Thanks again

Hi Been trying to open Form2 via a button on a subform (Subform1) which resides on MainForm1. I also want to filter the data based upon a value (Field1) on MainForm1 - been struggling with referencing mainform value despite looking at various posts/websites. Code so far (will work if button...

Star man - it worked!!! Thank you for your time

Had a further complication with the well documented 'OLE Server or ActiveX control' error but have imported everything into a new db and have appeared to have resolved that one - however still unable to setfocus on a specific page of the tab control

Thanks for the very prompt feedback - I've adjusted code a little but still get errors. I think it'll be down to the permittoworkform being opened, taking focus and the second line of the code failing?

Hi Been struggling for a couple of days now, I want to reference a page called Completion on a tab control (TabCtl220) on a form called permittoworkform and select it - all this from a button on another form. I don't want to put any code in the OnLoad event, for example, as I'd like to have...

Hi The following code may be of use to you here although my example will output to RTF as don't have facility to print to PDF (although is now pretty standard in Office 2007). You would have to adjust the e-mail addresses manually but there are other clever ways of populating the circulation...

I'm working in Access 2000. I have a continuous form "SecondarySupplierForm" that is opened from command buttons in individual records in several other forms. When a user clicks the button, "SecondarySupplierForm" opens, filtered to show just the records related to the 'SupplierNumber' of the...

I’d like to develop the following code in order to trigger another section of code (in this case ‘Mail_CDO’) not only when the cell value is greater than 7000 but also in the event that A1’s value remains the same for,say, more than 10 minutes. Any ideas? Private Sub Worksheet_Change(ByVal...

I’ve created a cross tab query that obtains the total of faults on any date inputted as part of an underlying parameter query – so far so good. However I’d like to generate a chart that reveals the trend for such faults – the only way I can think of doing this is to somehow automate an append...

You can use VBA , put likes of this code in the click event of each checkbox: If 34Mtrcheckbox = True Then Me.WtrMtr= "400" Else If 3/4Mtrcheckbox= False Then Me.WtrMtr= "400" End If End If Crude code but may get you there... be careful what you call your controls. Certain 'restricted'...

Thanks for taking time in replying - both methods worked a treat. I think I had initially copied (not cut) and pasted - and that was despite reading other posts on similar issues with tab page controls. Cheers D

Hello I've got lots of unbound checkboxes on a page of a tab control - upon navigating to a different page, the remnants of the border colour of some of the checkboxes remain visible (please see attached) Any ideas how to overcome this issue (apart from removing checkboxes and changing their...

Thanks for the reply Tim Been busy but just prior to your post finally cobbled something together that appears to do the trick: Private Sub CheckAntenna_click() Me.Parts_SubForm.SetFocus If CheckAntenna= True Then Me.Parts_SubForm.Form!Parts = "Antenna" DoCmd.GoToRecord , , acNext Else If...

Hi I'd like to add an image of a PDA to a form, add unbound checkboxes with their labels relating to different parts of the device. Upon clicking the various parts, a subform record will be added for that particular item. For example, if the antenna and screen were checked the subform records...