Search results

Hi Can anyone can help me with a search algorithm?.... I have a form with multiple controls (textboxes and comboboxes). In one combobox i have 3 values: legal entity, employee and and individual. Basing this values another subform appear for the search: for the person a search can be by its name...

Hi i have a problem with a variable value...I have 2 variables and i need them to take values from tables. Dim dosarid As Integer Dim cnp As String ……………………………………………………………………………………………… DoCmd.RunSQL "INSERT INTO tblDosare (DenumireDosar,CodDosar,DataDosar,Instanta) VALUES ('" &...

Hi, I have 2 forms: the first form is the search form (frmSearch) and the second form for search results (frmResult). In the search form i have 2 textboxes and 3 comboboxes. In a combobox if the user is chosing a value another subform appears on the form containig another search criteria (some...

Cnp.. CNP is text i corrected and declare it string and not gave initial value zero but still don`t work

Same problem I had tried. The program works the same but the same problem occurs: the variables do not take the values from the table with dlookup. I don`t know what to do because errors do not occur... Thanks

Thanks but... This will not work because Me stands for Forms!MainFormName. I am more interested in how can i take those values from table with dlookup instead of typing them when "insert parameter value" occurs.

Hi, I have a problem with a variable value. I have 2 tables calles FIles and Persons and i want to create a relationship between them one-to-many (More files for the same person) because a file can have the same number of file but not the same date. So for this relationship i have created a...

Thanks Thanks i will examine this because the problem was a relation between files and persons. The problem is that i can`t keep more files with the same person because SS# of a person is unique. I will use your ideea and see what i get.

Hi, I have a situation and i do not know how to handle it. I am developing an application for a lawyer. In the data base i have the following tables: Files, the people table (that are involved in a lawsuit), and other tables. The problem is the following: in the people table, beside the primary...