Search results

Thanks for the responses. Essentially what I need is to somehow intercept and stop the AfterUpdate event of the mainform by identifying if the subform has been clicked. Focus could therefore go back and forth between main form and subform without trigeering the automatic e-mail.

Hi Is it possible to prevent the AfterUpdate event firing on a main form when a subform on the same form has been selected? Have tried Screen.ActiveControl.Name to identify if the subform has received the focus but it appears that the main form AfterUpdate event fires and the last control to...

Thanks for all your feedback (well almost all), didn't realise anyone replied and did exactly what linq recommended and it worked. Cheers

Little late, I've acheived this using the Windows Media Player ActiveX. I'm using Access 2010 but suspect it's available on 2007 (if you're still on that version after all this time)

Hi I've embedded a Windows Media Player (WMP) active x control in the header of a continuous form. Works well until I either scroll through the records or click on different records - the WMP decreases in size until it's no bigger than a postage stamp. I've looked at various settings both in...

David was very kind to assist me on several occasions, my condolences to his family and friends. RIP

Thanks David That'll work geat for the example that I posted - I'll give it a try later. I also have another crosstab where additional values can be added. In the event that someone adds a value, the crosstab will also have to be updated -this won't happen very often and with my memory, there...

Could someone please assist with the following issue with a chart (on a form) that is based on a crosstab query. Row source for the chart is a crosstab query that counts the number of records based on the level of risk. (High, Medium and Low). I'd obviously like the bar chart colours to appear...

Thanks for your input DocMan. The only thing that the datalogger and widget tables have in common is that when the data is recorded or the widget produced, it is date/time stamped. There will be gaps where these dates/times aren't the same so therefore widget records will be omitted from the...

Unsure whether I've grasped the concept of a union query but I'd appreciate confirmation that I'm on the correct track. I have one query that is populated automatically (DataLoggerQuery) with several parameters being captured in the underlying table. I'd like to populate the underlying table...

Thanks for the feedback - I've established it's possible by downloading the ODBC driver for Advantage and linking the underlying tables from Advantage into Access tables. Cheers

Hi, has anyone had experience with importing/linking Access to an Advantage database. I'm able to import tables from Advantage into Access (the underlying data I can't edit because it's linked) but would ideally like to be able to manipulate data in Advantage from Access. Is this possible?

Absolutely perfect - thank you so much for your time

I've got 10 small images in a report that appear depending upon whether a tick box (for each image) has been ticked. I'd like to have all of them in a row and in the event eg Image 8 is unticked, Image 9 and 10 (if both of them are ticked) move to the left to fill in the gap. Usually there are...

Thanks for the feedback - still struggling. Tried running regsvr32.exe but only greeted with an error message. Also, I haven't used any reserved names etc

Upon loading and referencing an ActiveX object in the VBA window, I've tried to change the location of the object in the Tools ] References list by browsing to another version of the object in a different folder. However the location details always revert back to the original location no matter...

Me three!!!

Thanks - it works!!! State of disbelief here as I removed the quotes earlier in an attempt to guess syntax but it failed to work. Must have removed the pertinent info on this occasion. Thanks again

Thanks very much David - works a treat. On a slightly different note, wonder if you could also assist with following as you've already assisted and you appear to be the DLookup king. The following code was working until I included a letter in the unbound txtBarcode value (wanted to add letter...

Thanks Allan, will give it a go.