Search found 48 matches

by jwestan
Fri Aug 28, 2009 9:06 am
Forum: VBScript
Topic: MS access Connection then write to Excel
Replies: 16
Views: 9270

MS access Connection then write to Excel

That was awesome, now it runs in a little under two minutes.

I will work on the formatting to see if I can gain a little more.
by jwestan
Fri Aug 28, 2009 4:52 am
Forum: VBScript
Topic: MS access Connection then write to Excel
Replies: 16
Views: 9270

MS access Connection then write to Excel

Thanks, that is what I needed.

I will let sleeping dogs lie.
by jwestan
Tue Aug 11, 2009 6:39 am
Forum: VBScript
Topic: Creating Groups out of ADO recordset
Replies: 11
Views: 6048

Creating Groups out of ADO recordset

Sorry I was incorrect in my last post.

I had to place a nGroup= 0 above the do loop and that only gives me 5 groups.
by jwestan
Tue Aug 11, 2009 5:53 am
Forum: VBScript
Topic: Creating Groups out of ADO recordset
Replies: 11
Views: 6048

Creating Groups out of ADO recordset

I was able to get my database code to work and it is creating 6 groups not 5 so I am guessing that it might be 1 site over nGroupSize? Also during this part of the code Do Until objRecordSet.EOF n = n + 1 If n >= nGroupSize Then nGroup = nGroup + 1 grpName = "AllStores_Grp_" & nGroup W...
by jwestan
Mon Aug 10, 2009 4:04 am
Forum: VBScript
Topic: Creating Groups out of ADO recordset
Replies: 11
Views: 6048

Creating Groups out of ADO recordset

Thanks jvierra, This works but only after the first 600 records, the first 600 records arent incremented. This is how I am using it in a loop. Any suggestions? If objRecordSet.BOF Then  MsgBox "No Matches were found for the SQL Query",vbOK, "No Records found error" Else  rsCount ...
by jwestan
Sat Aug 08, 2009 9:20 am
Forum: VBScript
Topic: Creating Groups out of ADO recordset
Replies: 11
Views: 6048

Creating Groups out of ADO recordset

How could I then increment the group number every nGroups? So that I would have 600 records in group 1 then 600 records in group 2, etc? That was my issue, that I could not figure out how to do that dynamically, so that if I had 3200 records and wanted 4 groups that at every 800 records I would incr...
by jwestan
Fri Aug 07, 2009 1:42 pm
Forum: VBScript
Topic: Creating Groups out of ADO recordset
Replies: 11
Views: 6048

Creating Groups out of ADO recordset

Sorry,

Based on the number of records I want to divide them up into x number of groups, which would be a parameter. So if I have 3000 records and I want 5 groups then that would be 600 records per group.

I am having trouble trying to get the logic to work obviously.
by jwestan
Fri Aug 07, 2009 9:21 am
Forum: VBScript
Topic: Creating Groups out of ADO recordset
Replies: 11
Views: 6048

Creating Groups out of ADO recordset

Thanks jvierra, I was also looking to make the 1600 and 800 dynamic as well based on the group number but have not been having any luck. I tried this and it just kept dividing after it reached the group number. Anymore suggestions? Thanks grpNum = "5" rsCount = "3000"  n = 0     ...
by jwestan
Fri Aug 07, 2009 7:58 am
Forum: VBScript
Topic: Creating Groups out of ADO recordset
Replies: 11
Views: 6048

Creating Groups out of ADO recordset

I have a SQL query that returns say 3000 records and I want to group the data in 5 groups. I want to be to do this dynamically as the recordcount and group number can change. I have done this in my current code but would have to change it based on group number and record size. I have a counter that ...
by jwestan
Thu Jul 23, 2009 2:01 am
Forum: Other Scripting Languages
Topic: Encrypt db password in HTA
Replies: 1
Views: 2843

Encrypt db password in HTA

Does anyone have any ideas on how I can encrypt a database password for the hta? The hta is currently used on the a machine that will have PCI hardening done to it and I want to ensure that we can still use the hta. I have database passwords currently not encrypted. Also is there anything I could us...