Search found 363 matches

by AndyGable
Thursday 5th January 2023 9:52pm
Forum: General
Topic: Need someone to look over this code for me
Replies: 3
Views: 1390

Need someone to look over this code for me

Hi Everyone I could do with a new pair of eyes going over this code for me to see where i have gone wrong as I can not seem to find it First of I am using this to add item(s) to the DataGridView Dim iInd As Integer = 0 Dim ItemToadd As String Dim ItemToadd1 As String Dim ItemFound As Integer = 0 Ite...
by AndyGable
Thursday 22nd December 2022 9:25pm
Forum: General
Topic: [Solved] Show ETA On a Mysql function
Replies: 6
Views: 1990

Re: Show ETA On a Mysql function

Hi @Quincunxian Thank you for that example I will see what I can can come up with if i have something say like 56,003 seconds how would i convert that into minutes so I could display it on screen you can use \ and $ operators \ gives the division without the remainder % gives the remainder the foll...
by AndyGable
Thursday 22nd December 2022 5:31pm
Forum: General
Topic: [Solved] Show ETA On a Mysql function
Replies: 6
Views: 1990

Re: Show ETA On a Mysql function

Hi @Quincunxian

Thank you for that example I will see what I can can come up with

if i have something say like 56,003 seconds how would i convert that into minutes so I could display it on screen
by AndyGable
Wednesday 21st December 2022 7:59pm
Forum: General
Topic: [Solved] Show ETA On a Mysql function
Replies: 6
Views: 1990

[Solved] Show ETA On a Mysql function

Hi All I have the following MySQL Function that I use to copy my Product table from the Server to the Local System's database Dim DataResult As Result Global.DisplaySystemMessage("Processing Please wait...") i = 1 $Query = Null $Query &= "Select " $Query &= "barcoden...
by AndyGable
Wednesday 14th December 2022 10:21pm
Forum: General
Topic: [Solved] Screen not updating
Replies: 5
Views: 1574

Re: Screen not updating

Thanks @BruceSteers that worked perfectly
by AndyGable
Wednesday 14th December 2022 8:38pm
Forum: General
Topic: Resource temporarily unavailable
Replies: 0
Views: 12925

Resource temporarily unavailable

Hi Everyone I hope someone can help I am trying to print a End of day report to my Point of sale Printer but I keep getting "Resource temporarily unavailable" while it is printing This is what I am using to print to the printer Private Sub PrintOnPrinter(DataToPrint As String) Dim LineData...
by AndyGable
Saturday 10th December 2022 10:27am
Forum: General
Topic: [Solved] Screen not updating
Replies: 5
Views: 1574

Re: Screen not updating

@BruceSteers

Thanks for that I'll try it when I get to the computer

Also would it be better to keep the timer or would wait 3 wait 3 seconds and then start the process?
by AndyGable
Friday 9th December 2022 11:37am
Forum: General
Topic: [Solved] Screen not updating
Replies: 5
Views: 1574

[Solved] Screen not updating

Hi all, I am sending messages to my user via a label called SysMessage but I am only getting the first one to show when the form loads I get on screen labSystemMessage.Caption = "Starting End of Day" & gb.crlf & "Please wait..." labSystemMessage.Refresh and this is correc...
by AndyGable
Tuesday 29th November 2022 3:27pm
Forum: General
Topic: [Sloved] Convert image back from base64 encoding
Replies: 10
Views: 1596

Re: [Sloved] Convert image back from base64 encoding

Once you explain that what I was getting from the database was string data correctly formatted I just changed it to be

ImageFile.Image = Image.fromstring(frombase64(image string))
by AndyGable
Tuesday 29th November 2022 1:23pm
Forum: General
Topic: [Sloved] Convert image back from base64 encoding
Replies: 10
Views: 1596

Re: Convert image back from bade64 encoding

I think I have a issue with the recall of the String from the database When I recall the string I get "/9j/4AAQSkZJRgABAQEAYABgAAD......etc...." it is not the same as what I have in the database 0x2f396a2f344......etc..... Yet, the string, attached by you, that you receive from the databa...