Recent content by systemx

Cheers Bob!

Hi all, I have been searching for a setting that enables me to change the background colour of a tab control on a form. It may be something obvious that I have missed. Changing the type to 'transparent' and setting the form background colour does not seem to work. Any ideas? Cheers, Rob

Thanks....I will definately add this feature next time I patch the F/E!

Hi and thanks all for the advice. Ruralguy....the link provided provides some fantastic and simple advice. Doc Man...your post has perhaps inspired me to investigate redesigning elements of the database to reduce the need to send/retrieve over the network. I'm thinking I could approach it...

Hi all, I have an Access 2003 DB that has been in use for about 4 months. The database is split F/E (local) and B/E (networked drive). It may have up to 30 concurrent users some of which are Access 2000 users. Today it crashed in a big way. I have had a number of instances where the B/E has...

Got it working! Managed it with this.... 'Populate the MVL details from tblMVL Dim i As Integer Dim arrMVL As Variant i = 0 arrMVL = Array(Me.txtMVL1, Me.txtMVL2, Me.txtMVL3, Me.txtMVL4, Me.txtMVL5, Me.txtMVL6) strSQL = "SELECT * FROM tblMVL WHERE CUSTOMER_NO =" & CusNo & ";" Set ADOrs =...

Hi all, Hopefully someone can help me with this piece of code. I have six textbox controls (txtMVL1 - txtMVL6) and wan't to populate them from a recordset. Here is the code I wrote to loop through the recordset - 'Populate the MVL details from tblMVL strSQL = "SELECT * FROM tblMVL WHERE...

Hi Takstein, If you have the Silver Windows XP theme applied to your PC - then Access will automatically follow suit. Unfortunately, to the best of my knowledge there is no way to tell Access to always apply this scheme. Therefore, in a multi-user environment - if your user's local settings...

Hi all, I am using a method found on this site to kick users from my BE. When they log in to the DB, a bound form opens which contains the version number (for verification purposes) and a single checkbox. The form timer calls a script to check the value of the checkbox. If checked...

Thanks for the advice guys. It's funny, even though I feel like I am relatively competent now in most aspects of Access and VBA - I still have such a tremendous amount to learn. I appreciate your input and have a great deal of respect for not only your experience - but the collective experience...

Thanks Peter & Bob for taking the time to reply. Having now completed the function - I can see that in this particular case the array probably did not make things all that much easier. For me, it's more about finding new ways to do things so that I am not limited in my approach to problems. I...

Hi all, I am brand new to using arrays and think that they may present an a good method to avoid lengthy nested IF statements. My array contains 10 values, each the contents of a textbox control on a form. eg arrMVL = Array(Forms!MyForm!txt1.Value, Forms!MyForm!txt2.Value, ...) I want to: -...

Thanks mate. I am developing in Access 11. I was hoping to access it programmatically to use differnet icons for seperate forms - depending on which 'area' of the DB the user is currently in.

Hi all, A simple request but not sure if it can be done! I would like to change the icon next to the form 'Caption' in the title bar to my own custom icon. Does anyone know how I can access this property programattically (or at all?). Regards, Rob

Hi BigJim, From my experience (although limited) - I have found there is no easy way to get a grip on another person's database. As different people use different conventions and method's - this has posed a problem for me in the past. I find the best way to understand the database, is by...