Recent content by GaelicFatboy

I had a think about this over night. The easiest solution I could come up with is to make a Class module with two properties, namely VariableValue and VariableName, then make a collection of this class. Thanks for your help. D

Hi Everyone, I have a sub which uses a collection to store twenty or so variables, each of which I give a name as the key. During debugging I can view the collection in the locals window but the valuables are listed by item number only. Is there a way to view the key name for each item as well...

Thanks for the code, it works fine. In the meantime, I had a little think over night and can up with this... Dim rptMain As Object Dim rptSub As Report Set rptMain = Reports("Xray_PackM1_rpt") bytY = rptMain.Count - 1 For bytX = 1 To bytY Debug.Print rptMain(bytX).Name Next bytX Your...

Hi Chaps, I'm trying to construct a collection of all the subreport names in a report, but I'm having trouble retrieving them. CODE SO FAR: Private Sub Report_Load() Dim rptMain As Report_Xray_PackM1_rpt Dim rptSub As Report For Each rptSub In rptMain Debug.Print rptSub.Name Next End...

Thanks for your help. Denis

Cheers Colin, I suspected as much, is there mileage in writing a bit of code in an "OnLoad" sub to set all the event properties for that form? I'm developing the code just now so it's prudent to cover this sooner rather than later. Thanks for your help. Cheers Denis

Hello, I'm looking for a spot of advice about event calls. I have a form with a datasheet containing three fields, and after an update I have a few lines of code to check what the change was in an "AfterUpdate" sub. The problem is, after the event trigger, which is in the form's event list...

Good point, and no I didn't. Just rectified my mistake and the form event traps are now triggering nicely. This property is the last on one the list and the only one to drop off the bottom of the screen and out of view, so I forgot about it. Cheers for your help. D

I got the key press working using a control event trap, the form events don't catch the key press. Cheers for the right click heads up, I'd forgotten about that just now. Cheers for the help, much appreciated. D

So how do I trap Ctrl V, the on Key events don't catch it in the main form or the sub-form? Cheers D

The client has requested the Ctrl C and Ctrl V options, unless I can stop the users from using Ctrl V to paste records. Any thoughts? Cheers D

I have a table on a form listing a schedule of parts which are allocated to a client and site. Behind each part listed on the table are two different lists of properties associated with each part. What I'm looking to do is use the Ctrl C (copy) and Ctrl V (paste) to copy and paste records to...

There's no facility to change the default database font name under the "Access Options". "Datasheet" only has size and weight. "Object Designers" only applies to Query design font. And there is no other reference to font names under the Access Options window. What I want to do is globally...

I've just changed from Access 2013 to 2016, but when I open any tables or queries, in 2016 version, I notice the font is "Calibri" instead of "Century Gothic", but if I use 2013 the font is "Century Gothic". So how do I globally change the default font name to "Century Gothic" in the 2016...

Cheers for that, it's all working now. I was using the ordinal position to step through the fields from start to finish, but the code was running through one iteration and then dropping out with an error, so I didn't think to try using the name's string variable (I put it down to man flu)...