Search results

At your code i changed only at the FOR routine, the listbox and the combobox with my listbox name and combobox name. I checked this out, but nothing happens. I can select a choice from the combobox without getting any errors but despite i am updating the form. the selected choice does not get...

I changed it and then i had a compile error at me.listbox(nIndex,1). Its something it does not identify this. I also tried me.listbox.itemdata (nIndex,1) or me.listbox.recordset(nIndex,1) but i get an error for removeitem: runtime error '6014': The rowsource type property must be declared at...

I get a compile error: method or data member not found. and the .Count is highlighted.

Hi there! This question of mine came from another thread of mine, but i thought i should post it as a new thread. I have a combo box and a listbox. All i want is when i select a value(text) from the combobox to check if there is a same value(same text) at the listbox and if there is, then this...

Otherwise, regarding my first statement, for the combo boxes which i cannot include at my code 'cause of exceeding the 1024 character limit, i could use an after update code, so i will scan my list box and if record of the listbox matches the record i have selected from the combo box then this...

Another idea of mine is to make two queries that select all surnames except the ones that have been already chosen. The one query will exclude half combo boxes and the other the rest. Then i will make a union of these 2 queries. With this, i will not have problem exceeding the 1024 limit...

At the listbox i use a query at the row source.Something like this: SELECT table1.surname from table1 where table1.surname not in <> etc (like first post). And at the after update combo box i use the me.listbox_name.requery code. My disadvantage is that i have lots of combo boxes. The combo box...

ok i found it! I selected the text box and then properties. At OTHER tab is has an option called auto correction. I set it to no and everything is fine(i use access 2007). Thank you really much for your help

hi there. I use greek languaged office and at a table my surname field contains values writtern at Greek. At a from i created a text box and a list box. The list box shows all values from surname field. When i start typing something at text box, then there is a filtering at the list box - like...

I am trying an alternative code at after update combo box, like this: Dim i As Integer For i = listbox_name.ListCount - 1 To 0 Step -1 If listbox_name.Value(i) = combobox_name.Value Then listbox_name.Value(i) = "" End If Next i but i have a mismatch message.

Hello there! I have a list box and a combo box. I have for row source the same field of array at both the list box and the combobox. All i want is, when i select a value from the combo box, the same value from the list box to disappear. I have written a piece of code at list box: SELECT...

thank you really much | found it

Hi there! I use buttons to all of my forms, buttons like New, Edit, Return and Print button. When i click on print button, i get the buttons too at the paper. How can i make the buttons not to show up at the printing page? Thanks in advance

ok i am really sorry. I thought that if someone else had seen that the thread has post, that he/she wouldn't reply that easily. Sorry, i won't do this again! :o

i use 3 combo boxes at a form that take data from a table. The form is at continuous mode, so i get all the relative records from the table. I use a clear button, but when i click on it, only the first row comboboxes get cleared. Could anyone give me some piece of code that i could use to clean...

I know that i need i query, i just do not know how to write it, 'cause i cannot manage the other rows' fields cause they are multiplying depending on the records of the table

Here is an attachment. The language is greek and i have written over the table field with red color. This is at design mode. When i turn it to projection mode i get all the records. If for example i have 10 records at the table where i drag the fields, then i get all the 10 records as rows.

It is one form actually. Consider one row with fields: Name, Surname and ID but from the form properties i have selected the option:continuous form. So i get at one form all the records(name, surname ID) as continuous records of the same form. I cannot manage the names of the other rows...

Hello there. I have 3 combo boxes in a row that take values from table fields (name, surname and ID) and i have selected the choice continuous form. So, i get all users (name, surname and ID). I have a clear button, in which i have written at on click event: me.comboboxname1.value = ""...

Ok. I got what i want. Thank you very much!