Recent content by LOUISBUHAGIAR54

  1. L

    List items on a form erratically invisible.

    Hi thanks for connecting. I think you may be right because recently a different version of access was installed on some computers. But why should a different version cause list items to disappear ? Can I corrent this without changing the access version ? Many thanks again for your valued...
  2. L

    List items on a form erratically invisible.

    I have a large database with a front end and a back-end on a server. There are multiple users that use different front-ends on different computers. The problem is that one specific list on a form fails to show its items on some computers but behaves normally on other computers. The different...
  3. L

    defective number variable in an SQL statment.

    sPOT ON. Many thanks for your immediate help. I do not know how my searches on the internet prompted me to write in that variable as I have written it in the defective SQL statment. Now it is working well. Cannot thank you enough.
  4. L

    defective number variable in an SQL statment.

    Hi All Access programmers, I have been trying to solve this problem with no success after a search on online sites. I have an SQL statement with two variables, that does not seem to get going. I know that one variable is punctuated well and is working but the other seems to stick for...
  5. L

    How do i fashion a report on this crosstab query ?

    I now presume that a solution may need to have code to stratify the time portion and to have fixed column headings. I have found this article interesting but I do not know how I can apply it to my problem. http:/support.microsoft.com/en-us/kb/155489 Many thanks.
  6. L

    How do i fashion a report on this crosstab query ?

    Hello again. Sorry I did not keep up. The number of columns may change as well as it depends on the number of times medicines are given to the patient. As medicines to an individual patient are given in a single batch at any one particular time the column heading will be at that particular...
  7. L

    How do i fashion a report on this crosstab query ?

    I am sorry that representing the results of the query as shown above has probably put off more attempts at solving this problem. I admit that the results of the query appear confused on this post. The problem with being able to put this query on a report is that the headings are dyanamic...
  8. L

    How do i fashion a report on this crosstab query ?

    Many thanks for the reply. Unfortunately that did not work out. When I try to do the report using the report wizard no fields appear in the dialogue box of the wizard. I think that the problem lies with the columns. Since they are dynamic and the time (column ) headings (HIN) change with...
  9. L

    How do i fashion a report on this crosstab query ?

    I am trying to make a report on this crosstab query. PARAMETERS [Forms]![Dispensing History]![Combo5] Text ( 255 ), [Forms]![Dispensing History]![Text2] DateTime; TRANSFORM First(Query2.NurseID) AS FirstOfNurseID SELECT Query2.Description, Query2.Dose, Query2.Frequency FROM Query2 GROUP BY...
  10. L

    Switching on computer sound using vba

    Yes I will look into that. It may be an alternative. In any case the code I came up with is functioning well and it switches the sound on and increases the volume as expected. Many thanks.
  11. L

    Switching on computer sound using vba

    In this case I have no problem as the client is myself and I will be downloading the software on the company's computers. I will look into your suggestions. Many thanks. Louis Buhagiar
  12. L

    Run time error '3011' exporting to excel

    check whether there is an empty space in SHAREPOI_NT.
  13. L

    Switching on computer sound using vba

    I have done some more research and found a very practical solution to my own problem. There is a .exe file called nircmd.exe which one can download from www.nirsoft.net. I downloaded this file, unzipped it and placed it in a folder. Then I used the Shell() command within my access code to...
  14. L

    Switching on computer sound using vba

    Thanks Jiri for your help. I always want the sound to be uttered by the computer. My difficulty is that someone might switch the sound off, or reduce the volume of the sound on the computer. In that case I want to code to note this has happened and the switch the computer sound and volume...
  15. L

    Switching on computer sound using vba

    Thanks for your reply. Which part of the code switches on the computer sound if it is switched off ? Thanks.
Top Bottom