Search results

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...

Hi there, A little bit out there - but wandered if anyone knew if this was achievable perhaps through an API or system call. Specifically, I would like to gain access to the 'Summary' properties of MP3 and other audio files. Will post an answer if I find one first! Regards, Rob

Hi all, I have almost finalised the initial development of a fairly large split local F/E- network drive B/E access database. The database concept has grown from a 'Complaints Capture' database to a comprehensive 'Ticket of Work' database for a variety of different types of work. Being my...

It's OK. Confirmed. I am an idiot. I had it under the criteria for the field, instead of in a seperate expression. All fixed. :rolleyes:

Hi all, I think this could be another one of my stupid moments. Here is my query expression - IIf([WHAT TEAM?]=1,[strCurrent_Team]="FINANCE",[strCurrent_Team]<>"FINANCE") When run, the user is prompted to enter a team number. If they enter 1, then by my reckoning the query should return all...

Thanks MStef. Just one of those things...I knew the approach was arse about but could'nt think of the logical (simple) way of addressing the problem! I will simply use a non-visible control and include it in the query. Cheers, Rob