Search found 11 matches

by chrissalon
Mon Jan 04, 2016 12:21 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDAQ resistance to 2decimals in excel example
Replies: 4
Views: 16256

Re: DrDAQ resistance to 2decimals in excel example

Thanks for your support Hitesh,
Function works well in VBA and in fact works well using Xojo Programming.
(see my previous post (DrDaq Access using VB).
Much appreciate your feedback.
Regards,
by chrissalon
Sun Jan 03, 2016 12:13 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDAQ resistance to 2decimals in excel example
Replies: 4
Views: 16256

Re: DrDAQ resistance to 2decimals in excel example

Thanks for your response Glovisol. I looked at the posts but they don't answer my query. Maybe I did not phrase it right. I want to read the resistance using VBA in excel. Call UsbDrDaqGetSingle(handle, 6, value, overflow) This returns in 1K readings not 1.250K or 1250 ohms. I am using the current d...
by chrissalon
Wed Dec 23, 2015 12:54 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDAQ resistance to 2decimals in excel example
Replies: 4
Views: 16256

DrDAQ resistance to 2decimals in excel example

How can one get the reading of the resistance to 2 decimals. I get rounding off. A value of 2.538 in Picolog give 2.00 in the excel example that comes with SDK. Is it driver related or the way it is declared? When I covert the VBA to Xojo I also get 2.00. In one of the forum post one explains the re...
by chrissalon
Tue Dec 22, 2015 12:24 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDaq Access using VB
Replies: 12
Views: 26495

Re: DrDaq Access using VB

Thanks to Martyn (Above) and John A from Xojo forum I got the help to convert the excel VBA to Xojo (VB6 alternative) https://www.xojo.com and attached an example if anyone is interested. Xojo is free if you don't want to compile the program. Keep both USBDrDAQ.dll and USBDrDAQExample.xojo_binary_pr...
by chrissalon
Tue Dec 01, 2015 1:31 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDaq Access using VB
Replies: 12
Views: 26495

Re: DrDaq Access using VB

Thanks Martyn that works. The DO stay on thus can switch on and off. How can I keep the RGBLED on so I can use a scrollbar to vary the colour? This is done using the Pico scope. It will be a good demonstration in may example App. Currently I used a loop to change from 0 to 255 for the red, green and...
by chrissalon
Mon Nov 30, 2015 12:23 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDaq Access using VB
Replies: 12
Views: 26495

Re: DrDaq Access using VB

Hi Martyn, Forgot to paste the code here it is Declare Function UsbDrDaqOpenUnit Lib "USBDrDAQ.dll" (ByRef handle As Integer) As Int16 Declare Function UsbDrDaqCloseUnit Lib "USBDrDAQ.dll" (ByVal handle As Integer) As Int16 Declare Function UsbDrDaqEnableRGBLED Lib "USBDrDAQ.dll" (ByVal handle As In...
by chrissalon
Mon Nov 30, 2015 12:21 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDaq Access using VB
Replies: 12
Views: 26495

Re: DrDaq Access using VB

Hi Martyn, Thanks to your tips I had some progress with accessing DrDAQ with Xojo. I am able to get values from all the channels including the DO 1 to 4. I am still having a problem with getting the device info as Xojo declares with string are slightly different but I will get there. I mow trying to...
by chrissalon
Mon Nov 23, 2015 1:56 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDaq Access using VB
Replies: 12
Views: 26495

Re: DrDaq Access using VB

Hi Martyn, Thanks for guiding me through this. My programming intention is to continue with Xojo ( found it more fun for my age). I know most of the basics of Xojo so user interface issues are not a problem. I have managed to output the status open and close from the declares but had to change the L...
by chrissalon
Sun Nov 22, 2015 11:54 am
Forum: VB and VBA (Excel, Access)
Topic: DrDaq Access using VB
Replies: 12
Views: 26495

Re: DrDaq Access using VB

Thanks Martyn for giving some hope of conversion to VB. As I said earlier I only learned VB6, and the new versions have become too complex to just do simple tasks. For this reason I have moved to Xojo which is compatible with VB but only less complex and easy to program. I can interface with many su...
by chrissalon
Mon Nov 16, 2015 9:06 am
Forum: VB and VBA (Excel, Access)
Topic: DrDaq Access using VB
Replies: 12
Views: 26495

Re: DrDaq Access using VB

I have seen this example. I am not that experience yet to consider all the requirements to convert to a VB program, thus not sufficiently helpful for me to get started. I haven't learned C thus not helpful there. A am sure that it is not too much trouble to include an example in VB (not only excel) ...
by chrissalon
Sun Nov 15, 2015 2:04 pm
Forum: VB and VBA (Excel, Access)
Topic: DrDaq Access using VB
Replies: 12
Views: 26495

DrDaq Access using VB

Can anyone give me an example on how to read the USBDrDaq using VB6 or VB .NET to get me started (beginner).
Thanks for any guide.