Recent content by crann

Basic formatting in place and working fine. Just the flash. Just another quick one. Is it possible to have 2 timer events with different intervals. What happens if you wanted a requery every 10 minutes but a different timed event every 5 minutes for example. Thanks

I use MS Access 2013. 32 bit. Having read the recent comments I am now questioning whether I should be using a report or form to display the required information. Thanks

Hi I am using the following code to create a flash on the PStatus field within my form. The form is a tabular list of many records and I only want the records with a P1 text in the Pstatus field to flash but all feilds are flashing: Is it possible what I am trying to do? Thanks

Hi Sorry maybe I was not clear in my reply. The report I am talking about is a Matrix of maintenance jobs it is always on display on a slave pc which displays any changes in data via a sharepoint linked table. Our team use this report to see where jobs sit in terms of their priority. As and...

Hi I use a report as I am only displaying a list of live information to the users. I do not require data entry or editing from this screen. I didn't think it was right to use a form and then lock out all the fields? I only use a form if I need to enter or edit data. Is that correct? Any...

Would it possible to add into the code the following: If PStatus field = P1 then flash the PStatus text red continously until Pstatus is changed. The report shows live maintenance jobs and scheduling and we have a very short response time for P1 jobs hense why we have set the audible alert and...

ok thanks so much, that works great. I think it is actually quite uselful to be able to check if the sound was played, that way I can check the team were given an audio prompt.

Hi No i have 32 bit. I have now got it working the only issue is when there is a "P1" in field it plays sound but then changes all fields yes/no to yes not just the "P1" field. Any guidance Thanks so much

Hi Thanks ok got to be honest I am a little lost. Step by step if possible. I have the following code on the timer event of my report that refreshes report at intervals: The sound file i want ot play is saved as Z:\5741226.Wav. I have added a yes/no field in table with field names as above...

Hi I have a report that shows a list of maintenance jobs. Each job has a priority code for example planned maintenance is a P3 and emergency call out is P1. Is it possible to play a sound if a new record is added with a P1 status when the report refreshes which is set to around 5 minutes. So...

so, I have already downloaded the windows map app on to my tablet. Now I want to know if I can launch it through Access and paste the current forms address into the search bar on Windows maps. Thanks

Thank you I have been using the Shell function for launching other programs but I dont know how to launch a downloaded App. It seems impossible to find the file path for the windows map app. any advice? Thanks

Hi I use an Access DB on my windows tablet, can I launch the windows maps app I downloaded from the windows store through a Cmd button? If so how? Thanks

Thanks If I am honest that makes little sense to me as I dont have very much code experience, I understand the user is trying to detect which browser is running to decide how to launch the URL etc. I am now only using windows platform for all my work so I need to try and find something...

Thanks Minty The problem is that only gives a set of directions I don't believe it will allow you to access the turn by turn live guidance option that is available on many of the map apps. My db is on several windows tablets in the centre consol of our vehicles so its a perfect format for the...