Search results

Basically yes. The idea was that the user could stay on one form and change the filter criteria. I guess maybe subforms might do the trick. Would that be easier to do?

I have been using two forms, to allow my user to filter the data which is presented. In order to do this I built a query, which picked all the needed data from relevant tables, and based the main form on this query. The user was then first presented with a filter form on which there are two...

I will be using VBA to import a large quantity of data from excel to access. Let us say, that I have two tables which I need to write the data into: tblMain with two fields: uid (auto numbering) Titel (text) tblSub with three fields: uid (auto numbering) MainUid (number) Text (text) The...

Seems that everything is working. The last thing to do is to save the adjusted sorting back to the table. I did this by adding a button to the form with the following code: Private Sub cmdSaveSort_Click() Dim i As Integer Dim tmpUID As String, tmpSort As String, strSQL As String...

Got the up/down functions to work. The code is as follows: Private Sub cmdMoveUp_Click() Dim tempItem As String, tempIndex As Integer tempItem = lstSorter.Value tempIndex = lstSorter.ListIndex lstSorter.RemoveItem lstSorter.ListIndex lstSorter.AddItem tempItem...

Found the problem. I had three columns in my list box. When changing that to one it worked!! It was the same issue, that caused the error in my own script. I will continue working on the move up/down part of it, but it will not be until tomorrow. Thanks so far /Soren

That is one step further (although you are missing 'With rst' and ' End With' around the loop that builds strRow :) The script now writes one row of data to the list box, with each entry in separate columns. What I was trying to do, was write each entry to a separate row. What do I need to...

Ok, so far I have this: Private Sub Form_Open(Cancel As Integer) Dim qdfTemp As QueryDef Dim rstEmployees As Recordset Dim strSQL As String Dim i As Integer i = 0 Set qdfTemp = CurrentDb.CreateQueryDef("") strSQL = "SELECT * FROM tblDataSortering ORDER BY...

I did look into that option earlier on, but as I understand it, the list box RowSourceType must be set to 'value list'. And if that is the case, how do I then load my data into it?

I am looking to make a form that will load data from a table into a list box. Once the data is in the list box the user should be able to move a selected item up or down using to command buttons. The result should then be written back to the table. So far I have this: Table: 'tblDataSortering'...

I worked out a solution by entering =DLookUp("sum([normering])";"[1aDB]";"[grad] = 'M331' and [aarstal] = 2010") as the textbox's ControlElementSource /Soren

I have a simple table consisting of four fields: uid grad (rank) aarstal (year) antal (number) (see example here: http://www.vinther-jensen.dk/access/test_1aDB.mdb) I would like to present the data in a grid on the form as shown in the example with grad (rank) down and aarstal (year) across...

For you info, James, I have updated the example (still same link as original), which now works without the linked text box. It is still a rude example and the linked text box might be better suited for more complex structures. Cheers, Soren

James (#6), That is exactly what I am trying to do. I will give the linked text box approach a try. Thanks. Cheers, Soren

James, If I understand you correct, you then update the text box on the main form with the selection in a given subform. And then use the updated text box as the driver for updating an other sub form. Is that correctly understood? /Soren

Guus2005, I am not quite sure that I follow you. The table that you describe is - as far as I can see - identical to my 'Child' table. Could you expand a bit on how you see it used? /Soren

I need to present several levels of data in a form, but am having trouble when I exceed two levels. I have made a rude example, which can be found here: http://www.vinther-jensen.dk/access/several_levels.mdb In the form 'frmListe simpel' there is an example of how I wish to be able to choose...