Search results

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

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

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

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

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

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

Hi all, I have a continuous bound form based on a query (designed to look a little like a spreadsheet). When the user clicks on a check box, I would like the date to be written to the table for the corresponding record. I have this code - Dim ADOrs As ADODB.Recordset Dim strSQL As String...

Hi all, My database has right click disabled (for obvious reasons). I have added a new form which contains a pivotchart. The intention is for the user to be able to build custom charts. Because the right-click is disabled (I assume) - the user is unable to access the 'Field Properties' box to...

Hi all, My apologies first for making another thread on this issue. I have tried all solutions I have managed to locate with no success. I am developing in Access 11. A small percentage of my users are using Access 9. When the Access 9 users attempts to open the database, the 'Outlook'...

Hi all, Today some of my users (primarily Access 9 users from what I can tell) have started experiencing weird Crash to Desktop issues. The issue occurs when the user clicks a command button, which in turn should open an unbound form. All other database functionality is working correctly...

Hi all, Hoping for a little help. I am trying to DCount all records in a tblMail where field 'Date_Received' is empty/null. I am using - Me.txtMOustanding = DCount("*", "tblMail", "[Date_Completed]" = Null) This seems to count all records in the table, and not those where Date_Completed...

Hi all, I am work in a medium sized (80-100 people) Government Contact Centre. As some people may know from previous posts, for several months on and off I have been developing a database which could be best described as a 'ticket of work' system for many of our transaction channels. I am...

Hi all, One thing that infuriates me about access (perhaps a lot do with my own limitations as a designer) is that chunky 8-bit feel it has to it. I'm trying to achieve something a little special with some of my forms, perhaps along the lines of the look and feel that you get when using a...

Hi all, Hopefully a simple question. I have a listbox on my form which is based on a query. For each row in the listbox that meets specified criteria, I would like to format the row (make font italic and forecolor red). Dim i As Integer Dim intCount As Integer i = 0 intCount =...

Hi all, On my main form I have a continuous bound subform. The subform contains a small 'View' label next to each record. The intention, is that when the user clicks on the 'View' label, another form is opened that previews some details for the current record. Currently, for this to work...

Hi all, I'm not sure if this can be done with the expression builder. I have a query that brings in a value from an open form when run. The query can be called from two seperate forms. In my expression, I would like to check which form is open, and port the corresponding value. In VBA - If...

Hi all, Just a little advice on how to approach a problem. I have some simple address validation in an unbound form. When the user types in a suburb, I have a DLOOKUP function that returns the appropriate postcode for that suburb. My problem is that most suburbs have more than one postcode...