Search results

Hello! Thank you Pat. I will redesign the DB. E.

Hi Jack! Thank you for advice, but could you explain it to me in more details. I have made an append query and run it with the button, but how to set a criteria to append only one record from "PI person" table (selected from the first combobox) to "Contact person" table. How to make appear the...

Hi! I have the following problem. I have a main form with two comboboxes. The first combobox shows all "PI person". The second combobox shows all "Contact person". Both are runing on queries. A the same main form I have two buttons, which opens the subform "PI person" or "Contact person"...

Hello David, thank you very much help. I have used the InStr(), Left() and Mid()functions to extract the data form old DB. I think that I have solved my problem. I extract each first item and put it to a new junction table: ---------------- |first |item1 | |second|item2 | ---------------- Then...

Hi, I have about 1000 records (raws) in "old" DB! Yes there are only three possible options of separating the items: space, comma or space+comma. Could you explain how this InStr() function works? Thank you very much David. Regards, E.

Hello, can anybody help me in the following problem. I have to fill the table tblITEMS in my "new" DB with the data from the tblITEMS in "old" DB, but some fieleds in this DB don't match. In "old" DB the tblITEMS has a field Format, which is a string of few items separted by spaces or commas...

Thank you Scott. I need some time to think about your solution. Regards, E.

Hi, Chris or anyone else could help me with the above problem? Please .... Thank you in advance E.

Hi Chris, Thank you for your advice. It works great, but I realized that after I close the 'User' subform the value in the combo box is the first record and not the new record that I have typed. In the 'Users' subform in the on close event I have add ...

Hi, I was wondering if anyone can help me. I have a main form with a combo box (it shows Users LastName) runing on a query. Here is the code: --------------------------------------------- SELECT DISTINCTROW Users.UserID,Users.LastName FROM Users ORDER BY Users.LastName...

Thank you very much Alexander. It works! I have also other problem with the records in combo box. Perhaps you can help me. If I choose a record from combo box drop down and it appears in the field. Then I delete the record from the field and try to open linked to that field subform (Service)...

I have a Form where I enter in New Services details, when I click save I want that form to close and that New Services's name to appear in a combo box on another Form - User Form and not only in the drop down of the combo box but in the selected text part of the combo box. How may i do this...