Search results

Try this, Dim rstthumbs As Recordset Dim dbs As Database Dim Txtz as Control Set dbs = CurrentDb() Set rstthumbs = dbs.OpenRecordset("SELECT naam FROM Thumbnails") set Txtz = me!zoeknaam 'use the ME! if the control is on the same form rstthumbs.movefirst ' start of recordset do until...

Joey, Your a gent and a scholar, exactly what I was after, many thanks. Dave

I've got a chart embedded in a report and I need to automatically set the maximum value on the y axis dependant on course type for which the chart is showing data. Does any one know the property I've got to change in the chart. I've looked through help and my books but I can't find any...

Bretti, Try changing ME.ID to something like ctlID Dim ctlID as Control set ctlID = me!ID and .seek "=", ctlID (Access is a bit dodgy about direct references to objects when using seek) also check that your control data type is the same as the field in the recordset otherwise the seek...

Simple solution: (I'm assuming you know either Macros or VBA) 1. Create a new application linked to your current data base (Is your database split FE/BE or single application) and make a form that opens automatically on startup. 2. In the forms 'Timer interval' event property section change...

I think we can all sympathise with your user problem. Does each of your users need to print off a report every hour or is it the system that needs to print off 1 report every hour. If you can clarify this it would be easier to provide a solution.

I'm not entirely sure you can change the parameter box title, a work around may be to create your own 'Paramater Box' using a form you would design and then supply the users parameters for the query using code. This way your parameter box can look any way you choose. I am assuming your pretty...

Are the values in your combo box based on a query or values that you've typed in? If it's a query then just adjust the sort order of the query to reflect the column that you want to a-z. If its values that you've entered yourself then you're a bit stuck. If its only a few rows then you're...

change the code in this line: Set RsList = Tbl.OpenRecordset(dbOpenTable, _dbReadOnly) to this: Set RsList = db.OpenRecordset(dbOpenTable, _dbReadOnly) replacing Tbl with db that should work hopefully

Alternatively you could use the Ldb viewer software free from microsofts home site - email me and I'll send you a copy if you can't find it

Does anyone know how to reference the indexes in a linked table. For example when using the seek method, I keep getting err 3251 which is effectively telling me I can't reference the indexes of recordsets which are linked tables. Any help would be appreciated.

You need to base your suppliers combobox on a query with fields such as category supplier In the criteria section of the 'category' field in this query insert: [forms]![Yourformname]![yourcategorycombobox] This will supply the category from your category combobox and filter out the...

On your listbox form try inserting the requery action into the 'got focus' event property of the form not the list box control therefore when the form reappears the listbox will requery. Hope this helps

Is it the coding thats the problem, or just the scheduling of the tasks (for example when your not there). To do the tasks you require the database most be opened and run at some point. Whether or not you physically open the database is a different matter. Try having a look at some software...

Brett(i), Possibly the easiest way for you to do this is as follows: Combobox1 (Surnames), The column that has the surnames should be the 'bound' column, the column with the data that you want to pass on. Combobox2 (firstname), You want to base this combobox on a query with say 3 fields...

It is bad practice to store calculated values in a table (these are called notional fields). You would be better served calculating these values in a query or report so you can print off your results. Then use the form with the calculated field just for referring to a particular person

Try something like this: If is null(Yourcontrol.value) Then Goto Stop_Closing_Form Else Docmd.close Exit sub Stop_Closing_Form: msgbox your message exit sub if you insert something like this in the on click property of your close button that should prevent them leaving a null value in your...

I have a number of List boxes in one of my applications showing about 3500 individuals in each list box. When I type 'E' for example it takes me to all those whose surname begin with E unfortunatley I still may have to scroll down through upto 200 entries before I get to the one I want. I know...

Whilst I know that pivot tables are used for calulating values of data etc, I would really like to be able to use a pivot table (because of its' layout and ability to refresh the data held) without any calculations and just show the data supplied from a table/query (which is text not numeric)...

One solution (without making the database an MDE file) is to remove the close form function (X) and make the form Modal which will not allow them to access any forms behind the switchboard as the focus will remain on the switchboard until they select an option. Then you must create a button on...