Recent content by novo

I just got crasy deciding the problem from the subject. The problem is that I can`t link any variable to the selection object in word, but it`s necessary for selection.insertrows method(((( Help!

May be it`s a silly question but how to cope with the following task: I need to retrieve the data from the table basing on the SELECT statement or any other alternatives and use it in - for example - in msgbox content, and then to put the data from the word selection into the table in access...

My problem is conceptual, for I feel I`m doing something wrong :( Data structure is following: daily reports from - let`s say - 26 employees about theire activities results on checking concrete 12 questions. The task: organise the prefiltered information (surely - by date and employees, but...

:D It`s rather simple - you have the initial common timereport table collected from employees. So, you should (0) ghroup it by project/division, (1) you should remap some project`s time inside divisions, (2) remap some employees for all department, (3) calculate the extratime in section of...

Thank you guys for your help - my worst apprehensions are being fulfilled... The critical quantity - about 45 subsequent saved Querydefs. After this treshold Access refuses to work justifying oneself that it could not open so many tables))) But I found the rest as I`ve realized that it`s not...

I have lots of saved linked queries (about 20 pieces) wich makes lots of transformation with data. For example, after the groupping action is done by one field it should be acted on the base of another field with some filters :eek::eek::eek:. As I`ve seen in MS help NESTED QUERIES wich could be...

Ta-dam!!! I`ve got it! With no need to determine any sizes and with constantly maximized background form!!! So, everething you need: In separate module: Public Declare Function IsZoomed Lib "user32" (ByVal hWnd As Long) As Long Public Declare Function ShowWindow Lib "user32" (ByVal hWnd As...

thanks a lot for the advice - i`ll sure try to apply it, but there are things - if you don`t mind, wich confuse me: 1) i don`t need to close the little pop-up form shown above the main background maximized form till i use the report functionality; 2) Width and Height - as i comprehend, theese...

Hi all! I have a well-known problem wich hase been disscussed widely in forums but with a slightly ambiguity that i can`t figure out. In my database i have the main form wich is maximized on opening the base. After this you can run another forms from the main form menus wich are modal, pop-up...