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...
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...
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.
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...
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.
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...
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...
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...
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...
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.
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
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...
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...