Search results for query: *

Dear All, Thanks for a great forum. I want to make my buttons generic for all lists in my report forms. I have several buttons and each list has their own, Appeals reports, DC reports ect. The buttons do the exact same thing for all lists. So I have a Run Report button, a Run Query button...

Thanks so much Duane [bigsmile] see this link : Works brilliantly https://docs.microsoft.com/en-us/office/vba/access/concepts/miscellaneous/detect-user-idle-time-or-inactivity also I added code to quit Access if idle time over 5 min! Thanks again you're a star! Thank you, Kind regards Triacona

Thanks Duane for your reply. Unfortunately the folder permissions are centrally managed, so I can't do anything there. You mentioned other ways of bumping users, please could you let me know those options. As previously mentioned, it is a simple reporting program, so no users log in, they...

Dear All, I have an issue where I need to stop the .laccdb file from appearing when opening access. The reason is that the users open it and leave it open and don't logoff properly leaving that file running. This is a problem as when I need to update the file with the new version, it will...

Hi all, [smile] I'm a bit stuck here in terms of how to display the index number for debugging... I want to display the value of each i ( index ) so I can see what the index value is at any point in the loop. It seems to work for the first value each time, but then gives 0 for all others...

Hi Olaf, Thanks for answering [smile] Basically this is a very old system, using radio towers to transmit to a central location, as the car parks are far from each other. The system is legacy and was implemented 20 years ago. I have been tasked with getting that information onto a web page. The...

Thanks for all your help on this [bigsmile][2thumbsup] I think I have solved it, also removing the GROUPBY and adding the Between dates in the for loop as such: SQL = "SELECT " & _ "UNI7LIVE_DCAPPL.REFVAL AS Reference, UNI7LIVE_DCAPPL.DTYPNUMBCO AS PsCode, " & _...

Hi all, Thanks for a great forum. I hope this is the right topic for this query? I have the following issue. I have a server, which has SQL server and a database, for car parking data ( spaces total and spaces left ). I want to broadcast each car parks spaces left to the Server IP and...

Dear Andy, The return is thus: 01/01/2019 31/01/2019 Is it to do with the formatting? Thanks again for all your help [smile] Thank you, Kind regards Triacona

Dear Andy, Thanks for your help on this, your code gives me the Expected: end of statement error again. Just to note the: [Forms]![MainScreen].[txtStartDate] [Forms]![MainScreen].[txtEndDate]) are date controls on my MainScreen form, so they may not behave like a string...I think, I'm not sure...

This saves : "((UNI7LIVE_DCAPPL.DATEAPVAL) Between # & [Forms]![MainScreen].[txtStartDate] & # AND # & [Forms]![MainScreen].[txtEndDate]) & #" But gives the following error when the event runs: Thanks again for all your help [smile] Thank you, Kind regards Triacona

Thanks for your help [smile] I get an I tried the below, but it still gives the Error: "HAVING " & _ "((UNI7LIVE_DCAPPL.DATEAPVAL) Between "#" & [Forms]![MainScreen].[txtStartDate] & "#" AND "#" & [Forms]![MainScreen].[txtEndDate] & "#" )" Any more help would be greatly appreciated...

Hi Andrzejek, Thanks for replying [smile] I have stepped through the code and the between dates runs... see the output SQL and intermediate window SQL here: SELECT UNI7LIVE_DCAPPL.REFVAL AS Reference, UNI7LIVE_DCAPPL.DTYPNUMBCO AS PsCode, UNI7LIVE_DCAPPL.DCAPPTYP AS ApplicationType...

Hi all, Thanks for a great forum! [smile] I am hitting my head against a wall here, staring at the code, I need a fresh set of eyes. I have the following code: '------------------DC RUN QUERY BEGIN--------------------------------------------------------- '------------------DC RUN QUERY...

Hi all, Thanks for a great forum. I hope this is the right topic for this query? I have the following issue. I have a server, which has SQL server and a database, for car parking data ( spaces total and spaces left ). I want to broadcast each car parks spaces left to the Server IP and ports...

Dear All, I do not even know where to start, but have been asked by my director to solve this problem. I have a SQL server that runs a query that outputs serveral rows. Each row has a two results that I want to output, column: Name and column: Number of spaces. I have the SQL, but I need to...

Dear All, I have solved the problem with the following: Dim i As Integer Dim output As String Dim character As String For i = 1 To Len(strText) character = Mid(strText, i, 1) If (character >= "a" And character <= "z") Or (character >= "0" And character <= "9")...

Hi All, Thanks Andrzejek for your help, much appreciated [bigsmile] I think you are correct. Please see below my delema. I am trying to remove this ⊥ symbol ( Unicode ) For Each ch In letters If ch = vbUnicode Then ch = StrConv(ch, vbFromUnicode, 1) Else...

Dear All, Thanks for a great forum! I have a function ( below ) which I plan to use to weed out Unicode character from a string. The query feeds the array a string and then I work with it as below. Function ReplaceUniCode(strText As String) As Variant ' Replace % with the character you want to...

Awesome thanks! MajP, what you have looks right, I will give it a go! [2thumbsup] Thank you, Kind regards Triacona