Search results

Example database Maybe somebody can help me with this, I added a sample database of how it should be. All items should be saved in the attendance table (Present and Absent) Hope you guru's can help me on this one.

not exactly Thanks Banana, but in this example it uses another table to store the selected data, and that's just what I don't want, because it's a multi user database. My current listbox updates an txtbox with the ID's selected in the multi select lixtbox. If it's possible to store the NON...

Hello everybody, Hopefully somebody can help me on this one. I searched the whole internet and access forums, but I didn't find the exact solution for my problem. I've got a table with students, a table attendance, where I now only save the students who are absent, but I would like to save...

Hello, Does anybody know if there's a way to use the NOT selected items in a multiple select listbox? The selected items are put into a txtbox (A) but I want the unselected items to be put in txtbox (B). Is that possible? The multiple select listbox is updated by an cbobox. Thanks allready...

Hello, when I use the following query I get an error: This expression is typed incorrectly, or it's too complex to be evaluated. What am I doing wrong? SELECT tblCursist.Naam, tblAbsentie.Datum, tblAbsentie.Lesuur, tblAbsentie.AantalLesuren, tblAbsentie.Deelkwalificatie, tblAbsentie.Docent...

Example Hello, i've put the example database with my reply so it makes it a bit more clear. There's one form, and the most bottom right report (Absentie per Cursist per Periode) is the one I'm having trouble with. please have another look. When this is ready, I'm done :) Tnx in advanced!!!!

Thanks Wayne for your comments. It still doesn't work. When I select some options in the listbox, I always get the error message. No matter what I do. Can you please have another look? Does the recordsource query of the report need to be exactly the same as the query below? Private Sub...

Hello, I'm trying to make a report query work but with no succes so far. Can anyone please help me? I've got a multiselect listbox and a txtbox (txtCursisten) where the results from the multiselect listbox appear. I want to get the results out of a table (tblAbsentie) where I can set a start...

Unbound They show unbound... I still don't exactly know what bound and unbound means in Access. I've made an attendance db for a school and this is what I want to do: first combo selects a class from tblClass. next combo selects a student from tblStudent where Class = cboClas (this works fine)...

Not duplicate Only the data from the combobox excists, but I just want to take the selected value from the combobox and the values from the textboxes and put them in a different table than where I got the data from the combobox. (is that stil clear ???? :) )

Hello, this might be easy but I just don't know how to do it. I have 1 combobox and several txtboxes and I want the data from these into a new record by pressing a button. For example: Combobox: Name1 txtBox1: Adress txtbox2: City Button: get data from fields and put in table. table...

Yes Thank you Wayne! It workes fine! I'm very grateful.

Select ALL yes, I know that selecting items from the listbox works fine, but the SELECT ALL button doesn't work fine. please help again....

Please help Is there anyone who can help me with this last little problem? I'm finished after this and then I will post it with the example DB's for the rest of you! Thnx again, SeBasTiaan

after update List2 Can it be that the List2_AfterUpdate function interferes with the select all button? It does exactly the same in the select all function, so when the select all button is clicked, the afterupdate also does his thing? Sebastiaan...

DB example ok, I made a new DB with only the neccesary tables and forms...

Db Ok, I will post my DB... need to make it a little smaller...

Not for me :( What bit of code worked fine? The Select All button works fine indeed, but the value into the txtbox not. Did that also worked fine with you??

Almost there Can anyone please tell me what is wrong with this bit of script? I'm almost there but the value he writes in the textbox is duplicated. Everything that is selected in the listbox shows up 2 or 3 times like 1,1,2,3,1,2,3 instead of 1,2,3 Private Sub cmdSelectAll_Click() On Error...

Select all in Listbox AND Update textbox Hello, I've got this multiple select listbox which writes data into a textbox: Private Sub List2_AfterUpdate() Dim Cursisten As String Dim ctl As Control Dim Itm As Variant Set ctl = Me.List2 For Each Itm In ctl.ItemsSelected If...