Search found 45 matches

by Marvin1023
09 Dec 2016, 05:20
Forum: 脚本函数
Topic: ListView数据或数组生成Excel
Replies: 13
Views: 19373

Re: ListView数据或数组生成Excel

Powerful :roll: thank you very much :) with two listview or more use: #Include, <CLASS_LV_COLORS> #Include, <CLASS_EXCEL> Gui, Add, ListView, x5 y5 w200 r10 vCTRL_LV1 hwndHLV1, aaaaaaa|bbbbbbb|cccccc|dddddd Loop, 5 LV_Add("", "Col1" A_Index, "Col2" A_Index, "Col3" A_Index, "Col4" A_Index) CLV1 := Ne...
by Marvin1023
08 Dec 2016, 14:22
Forum: 脚本函数
Topic: ListView数据或数组生成Excel
Replies: 13
Views: 19373

Re: ListView数据或数组生成Excel

work with LV_Colors.Cell() and LV_Colors.Row()

Can you add LV_Colors.AlternateRows() and LV_Colors.AlternateCols() And Title column of Gui ListView.

I think your script will be complete.

Thank you.
by Marvin1023
08 Dec 2016, 10:14
Forum: 脚本函数
Topic: ListView数据或数组生成Excel
Replies: 13
Views: 19373

Re: ListView数据或数组生成Excel

Omg. good job :)
by Marvin1023
07 Dec 2016, 23:41
Forum: 脚本函数
Topic: ListView数据或数组生成Excel
Replies: 13
Views: 19373

Re: ListView数据或数组生成Excel

Thank for reply
I will look at how to add color in excel file.
by Marvin1023
07 Dec 2016, 23:10
Forum: 脚本函数
Topic: ListView数据或数组生成Excel
Replies: 13
Views: 19373

Re: ListView数据或数组生成Excel

This work with [Class] LV_Colors ?
by Marvin1023
03 Nov 2016, 15:50
Forum: Scripts and Functions (v1)
Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Replies: 43
Views: 94655

Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)

Hi, I use <CLASS_ADOSQL> with MSSQL this work. Now, I would like use with MS Access. This is my script: #SINGLEINSTANCE FORCE F1:: TEST_SERVER := "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\xxxxxxx\Desktop\db\db.accdb" TEST_DATABASE := "tsaisie" TEST_REQUEST := "SELECT * FROM " . TEST_DA...
by Marvin1023
26 Oct 2016, 21:20
Forum: Ask for Help (v1)
Topic: [REQUEST] SplashTextOn/Off if script use
Replies: 3
Views: 1938

Re: [REQUEST] SplashTextOn/Off if script use

i have a script with GoTo and GoSub.
I wish show SplashTextOn during all the action.

a label may be use by another goto or gosub.

I do not if this is possible.
Can be OnMessage
by Marvin1023
26 Oct 2016, 19:01
Forum: Ask for Help (v1)
Topic: [REQUEST] SplashTextOn/Off if script use
Replies: 3
Views: 1938

[REQUEST] SplashTextOn/Off if script use

Hello,

it is possible to display [SplashTextOn] if the script is in use (thread)
and [SplashTextOff] if the script is not use (thread).

Exemple:
If i run this script:

Code: Select all

F1::
Sleep 10000
Return
a SplashTextOn/Off appears and disappears automatically.
Thank you :D
by Marvin1023
26 Jun 2016, 15:56
Forum: Ask for Help (v1)
Topic: Gui ActiveX HTML + JS.
Replies: 4
Views: 2567

Re: Gui ActiveX HTML + JS.

Hi,

If i use:

Code: Select all

Gui HTML: Add, ActiveX, x0 y0 w800 h600 vHTML_COM, Shell Explorer
No ScrollBar

And if i use:

Code: Select all

Gui HTML: Add, ActiveX, x0 y0 w800 h600 vHTML_COM, Shell.Explorer
ScrollBar ?
by Marvin1023
23 Jun 2016, 19:39
Forum: Ask for Help (v1)
Topic: Gui ActiveX HTML + JS.
Replies: 4
Views: 2567

Gui ActiveX HTML + JS.

Hello, I would include a js file in a GUI (ActiveX) But I get a blank page. With the html file this work. why it does not work? #SingleInstance Force Gui HTML: Add, ActiveX, x0 y0 w800 h600 vHTML_COM, Shell Explorer HTML_COM.Navigate("about:blank") GoSub, HTML_SRC HTML_COM.document.write(HTML_SRC) ;...
by Marvin1023
18 Jun 2016, 19:24
Forum: Ask for Help (v1)
Topic: [SOLVED] delete specific character in first left in var
Replies: 4
Views: 1374

Re: [SOLVED] delete specific character in first left in var

Just like that !

it is possible to add a condition ?

Ex:
00000080 get 080
0080 get 080
by Marvin1023
18 Jun 2016, 19:19
Forum: Ask for Help (v1)
Topic: [SOLVED] delete specific character in first left in var
Replies: 4
Views: 1374

Re: delete specific character in first left in var

Capn Odin wrote:Are you saying you want to remove all leading zeros from numbers and only the first char from strings ?
Edit: If so try this.

Code: Select all

var := "00080"
RegExMatch(var, RegExMatch(var, "^\d*$") ? "([1-9]\d+$)" : "((?<=\w)\w+$)", res)
MsgBox, % res
Thank you working !
by Marvin1023
18 Jun 2016, 19:18
Forum: Ask for Help (v1)
Topic: Help - Perform action according to criteria
Replies: 4
Views: 1457

Re: Help - Perform action according to criteria

upperLeftX := 75 upperLeftY := 80 lowerRightX := 200 lowerRightY := 200 Loop, 2 { Sleep, 1000 PixelSearch, Px, Py, %upperLeftX%, %upperLeftY%, %lowerRightX%, %lowerRightY%, 0x00FF00, 3, fast if ErrorLevel MsgBox, That color was not found in the specified region. else MsgBox, A color within 3 shades...
by Marvin1023
18 Jun 2016, 18:00
Forum: Ask for Help (v1)
Topic: [SOLVED] delete specific character in first left in var
Replies: 4
Views: 1374

[SOLVED] delete specific character in first left in var

Hello,

How to deleting a specific character in first left ?

Ex:

Code: Select all

080 get 80 
Or
008 get 8
Or
ABA get BA
I tried : StringReplace
But this delete all character :/

Thank for your help
by Marvin1023
27 May 2016, 16:01
Forum: Ask for Help (v1)
Topic: Gui datetime control
Replies: 8
Views: 2595

Re: Gui datetime control

Thank Shadowpheonix this work by key. but i want to use checkbox. This work. I can disable, but I can not enable. PRIMARY_GUI_EVENT: If A_GUIEVENT = NORMAL { If (A_GUICONTROL = "FIELD_GUI_DATE_START" or "FIELD_GUI_TIME_START" or "FIELD_GUI_DATE_END" or "FIELD_GUI_TIME_END") { GuiControlGet, CheckBox...
by Marvin1023
26 May 2016, 13:44
Forum: Ask for Help (v1)
Topic: Gui datetime control
Replies: 8
Views: 2595

Re: Gui datetime control

This is my code: I need enable or disable all gui datetime on primary_gui if checked #SINGLEINSTANCE FORCE #PERSISTENT ;#NOTRAYICON SETBATCHLINES -1 APPLICATION_NAME := "APPS" APPLICATION_COPYRIGHT := "" GLOBAL_FORMAT_DATE = yyyyddMM GLOBAL_FORMAT_TIME = HHmmss GLOBAL_BARCODE_LENGTH := "8" GLOBAL_IQ...
by Marvin1023
26 May 2016, 11:50
Forum: Ask for Help (v1)
Topic: Gui datetime control
Replies: 8
Views: 2595

Re: Gui datetime control

I need Enable all gui DateTime or Disable all. I need only code for enable or disable gui DateTime. i found this exemple but not work with datetime checkbox: #SingleInstance, force ; Press F2 to enable/disable the DateTime control Gui, Add, DateTime, vMyDateTime, LongDate Gui, show return GuiClose: ...
by Marvin1023
26 May 2016, 09:27
Forum: Ask for Help (v1)
Topic: Gui datetime control
Replies: 8
Views: 2595

Gui datetime control

Hi, How to gui control DateTime for enable or disable by default is disable: - vFIELD_GUI_DATE_START - vFIELD_GUI_TIME_START - vFIELD_GUI_DATE_END - vFIELD_GUI_TIME_END ... Gui 1: Add, DateTime, x145 y20 h23 w120 vFIELD_GUI_DATE_START gPRIMARY_GUI_EVENT BackgroundTrans CHOOSENONE, %GLOBAL_FORMAT_DAT...
by Marvin1023
03 May 2016, 11:48
Forum: Ask for Help (v1)
Topic: Format time with concatenation.
Replies: 2
Views: 1073

Format time with concatenation.

Hi, i use this code for add or remove time with EnvAdd But the time format is not good in msgbox. I need only HH:mm:ss FormatTime TIME_NOW_1 += -3, Hours TIME_NOW_2 += -2, Hours TIME_NOW_3 += -1, Hours TIME_NOW_4 += 0, Hours TIME_NOW_5 += +1, Hours TIME_NOW_6 += +2, Hours TIME_NOW_7 += +3, Hours Loo...

Go to advanced search