Search results

Hi all, I have a combo box that is populated by a query. The query is ID, NAME, TYPE and i only see NAME. Can I fill 2 fields of the corresponding table by selecting that combo box, the one with NAME and the other with TYPE automatically? How can i access the other ,hidden, data of a combo box...

The problem is that when I do that I need to manually select the one result that is in this second combo box. I want that when I enter the one combo box I automatically fill the second combo box with the result of a query that is just one line of data.

Hi all, I have a List box that is filled by a query that is triggered with a combo box, how do I extract the info in that list box so I can fill another combo box. I used Me.List.Value but it does not work. The bound columns are all ok but I can’t get it to work. Also I don’t know should I use...

Hi all, I have a search form with a listbox that displays the results of a query. How can I select a field in that listbox and fill a combobox in a different form with that value. Thaaanks

You are a GOD :) Thanks !

Hi all, I need your help with partial locking of a record. This is the situation when there is a shift change and one record is started by one person and finished by another. What one has written another can’t change but must finished a record. So u must lock only the combo boxes and text...

I need your help with partial locking of a record. This is the situation when there is a shift change and one record is started by one person and finished by another. What one has written another can’t change but must finished a record. So u must lock only the combo boxes and text boxes that are...

:) yea - but now in the process of learning this i realized another problem... so back to the head hitting wall :/

Found something :) http://www.databasedev.co.uk/reminders.html

Hi all, How to make a question window popup when I want to: 1. Exit the program, the query1 and query2 is fired and if they are empty the window is just Are you sure you want to quit 2.If the query1 is not empty I must have a different window that informs the the query is not empty but you...

Can some one help me with this, this will be a crucial part of my db and I will use this in many places. I have a search form – when I find a specific object I want just that object selected in my other form that has one to much relationship to a table that the search form is going thru. What...

I made it work BUT...it’s not what I want :( - I’m using this basic form for just entering the data so I don’t actually need to find the first record, I just need to fill the combo box with the found record. The search is for the name of the street (with some other information), when I dbl click...

My query does not pull the whole record, must i include a unique id in my query and will he automatically search true the unique ids? And is this correct interpunction? rs.FindFirst "[ID_RASKRSNICE] = & STR(Nz(Me! [List9], 0))" And my form is already open, how do i bring it to font when i...

Hi all, I found this sweet little search db example that I want to learn to integrate into my db. It’s a simple search and double click select back to the original form. That is the problem, i integrated the search but double click with selecting the record i can't solve. Here is the link to...

:) Would like to learn how to solve this with the Tag property. If you can tell me how i would be grateful :)

Hi all, Can you change the color of lines of records in a table in dependence from a check box? So if you list it in a specific subform or something like that it will be a different color? Is there another way of doing this and is there an example? Thanks

I think i solved it :) For Each ctrl In Me.Controls If (TypeOf ctrl Is TextBox) Or (ctrl Is NEZAVRSENE_INTERVENCIJE) Or (TypeOf ctrl Is ComboBox) Then ctrl.Locked = True End If Next

Can someone help me please, i need this because i need to have one checkbox free to be changed after i lock the record.

I need the ENTER this into the table event or something, the form is for that table its not for this different new table. How do i enter the info from my form into the table with a click?

Thats a good idea, but how do i write the current form info into the table. I need the data that is currently in my form to be the result of my query...