Search results

Hi, Allan57! Thank you for your response! I have tried, but no success. There is an Error msg from VBA: Runtime error '2046' : This Command is not available at the moment. Do you have any idea? Many thanks. Krava

Hello all! I would like to have one stupid question, because I could not find any answer on this forum. I want save the Form as Report. I can do that from "Menu bar", but I want to do that from the code (VBA or Macro) without inputting the output parameters by users. Do you have any idea how...

RuralGuy! Thank you very much anyway! Krava

Hi Kevin! My suggestion would be to change your query used as record source for your Combo box from simple selection query to Summarizing query - you will Group your field "shift_date" so you will get it in the result only once. Then, you can sort it in "descending" mode and in SELECT statement...

Hi maisam! I am not sure but I would do it e.g. like this: check attachment

Hi, RuralGuy! I am attaching the sample DB with a Form with Tree object. If you or somebode would have any idea how to change the background color (white at present) I would help us. Thnank you in advance. Krava

Hello, RuralGuy! So I am back to you with some additional question. Do you have any idea how to change the Background Color of Tree View Control? I mean that the background color is white and we would like to change it to different color, if possible. I know that this is not the most...

Hi RuralGuy! It helped a lot! Thank you very much!!! Krava

Hi! I need a help. I would like to (if possible) to place into Form an object that could create a Tree-like menu structure. The source from this object should be table/query. Is this possible? Many thanks. Krava :)

Hi, Pat! I have tried it and I managed to change the Connection property on permanent table links so the result is just excellent! Many thanks one more time. Krava

Hi, Pat! Thank you for your suggestion, I will try it. I agree with you about permanent link efficiency, but I have a reason to do so, because our company is located in three different locations. At every location there is a server and number of clients. I develop an application on the same...

Hi folks.! I am new at this forum and I would like to have one question to you. I have postet this thread on VB forum but no success so I hope for success here. I am stuck with one problem I cannot figure out. I have a data *.mdb placed on server and I have a client *.mdb at every PC. The data...