Search results for query: *

Hi All, I have a series of buttons that I want to be on/off style buttons - i.e. click once to turn on and once to turn off. In order to show that any given button is on, the button text will turn white, and when off it will turn brown. I have all this working, except that if a user does not...

Hi, I have a procedure that loops round and fills 3 list boxes. during the procedure I want to be able to see the values that are being entered into the list boxes in real time. I have tried refreshing and repainting the form at the end of each loop, but nothing seems to work - ie I can only...

does anyone know how long your value list can be when using "rowsource" to populate a list box in Access 2000?

Hi, Does anyone know how you can create a new recordset using data held in a public array??

Does anyone know if you can use a public array as a form's record source, and if so how??

Hello, I am trying to change various attributes a database using vba. The first of these is the relationships between tables. I think my code should look something like the following: Dim rel As Relation Set rel = currentdb.CreateRelation(???????) My query therfore is - if I have two...

Hi, I am currently using the x command to open up a MS Access database from SAS. The only problem is I need to open up the database in administrator mode. If I was doing this manually I would hold down the shift key whilst double clicking on my access database. Does anyone know a way of...

Hello all, I wondered if anyone new if there was a DOS way of opening up an access database, which is equivelent to double clicking on it in windows explorer whilst holding down the shift key. ie a way that dos can open a ms access database in administrator mode, Any ideas would be gratefully...

Hi, I have used the control toolbox menu to create various tick boxes on a word document. After creating these tick boxes I have turned the design mode off, so that they are active and can be checked or unchecked. The only problem is that everytime you open the document, the tick boxes are no...

Hi, I have a form which creates a table based on various criteria: Dim conDatabase As ADODB.connection Dim rstLookup As ADODB.Recordset Dim strSQL As String Set conDatabase = CurrentProject.connection strSQL = "Select [Audit_Freq].[value], '' AS lookup, '' AS notes...

Hi, I have a listbox which uses two events, the first is the Click event and the other is the KeyDown Event. If a user clicks on the listbox I want it to do one thing, and if the user spins through using the up and down arrows I want it to do another thing. My code looks something like this...

Hi, I have a problem with a multi colum listbox. I want the user to be able to click on one of the items and then have various hidden column elements show up in captions on another part of the form. This all sounds simple enough, however the problem I have is that the Click event does not...

Hi, I have an issue when trying to select a value from a list box I have created using the rowsource property. The following code is what I am using to get values from the selected item within my list box: Private Sub MyList_Click() For Each varItm In MyList.ItemsSelected...

Does anyone know if I can program where a reference module is, as opposed to going through [tools] - [references...] etc. The reason is I have a module that I connect to which always sits in the same location as the database, however if I move both module and database to another location the...

I have a listbox that contains a list of values which when selected sets off an ADODB sql command to the database and populates another listbox in the form based on the values selected in the first listbox. This all works fine and dandy when a user is using the mouse to select the value/values...

I have written a database that makes use of ADO 2.5, but have subsequently discovered that not all versions of Ms Access within my department have this avaiable to them. Does anybody know if I can download this from somewhere, so that I can get my database working on everybodys PC? Cheers Skinicod

I am trying to find a method to get access to open a text file and display it in a textbox. I also want (if possible) to be able to save the text in a textbox as a text file. I am currently using access 97 and suspect that the answer to this may involve API. Any suggestions would be great...