Search Result

Yannt · Feb 19 '12, 08:30 PM

Hi,

I'm trying to simplify and make this piece of code more efficient (basically would like to remove the 2nd loop); any suggestions?

Thanks
Yann

Code:

    Dim db As Database, rst1 As Recordset, rst2 As Recordset, qry1 As String, qry2 As String
    Dim intCurrentProgress As Integer, intTotalWidth As Integer, intProgressBarMax As Integer

    q = MsgBox("Are you sure you want

...

dharol · Dec 13 '11, 11:05 PM

Total newbie here, many apologies if I have failed to find an extant answer to this question.
Using:
SQL Server 2000

I need to restore several hundred databases from an external drive to local drive.
Would like to batch, eg, call on a text file listing old and new db names/paths and loop through to end of text doc.

Currently have non-batching script:

Code:

DECLARE 
@olddir

...

AdilSaumtally · Nov 12 '11, 07:15 PM

my assingnment is to design an application that will generate two random operands that will formulate a question in the form:
5 x 2 =

Assuming 5 and 2 are the randomly generated operands.

The user at this point will enter the answer followed by the enter key. The entered value is compared with the computer calculated answer. If they are the same, a counter representing the correctly answered questions is incremented;...

scylla · Nov 4 '11, 03:27 PM

Dear members,
I'm a newbie and I created a simple program, but I have one problem I can't deal with. I should work on Win CE.

Ok: I want this program to read 'array of arrays' and save encoded data into file.txt. Every 3 bytes from there should be encoded from ASCII (function below).

The biggest problem is with loop (or some other way to fix it) to read all array (without any skips).

Now it's like:...

firasqureshi · Nov 3 '11, 06:20 PM

I am new in Access and stuck on loop issue. I have two combo which are getting values from a temp table. Temp table has only one column. This table gets updated values everytime. Temp table contains value from 1 - 10. These values are used as defining range to select toggle button from 1 - 10.

Scenario: if start combo selct 9 and then on got foucs of last combo data appears only 8 & 7 because 6 does not exist in the table and here...

sandy armstrong · Oct 19 '11, 08:26 PM

Hello, I have create a marco that will go on a site and extract data. thru a web query.
I would like it to keep looping through the column that has all the urls. and stop at the last row containing a url...

SO....
Column K has the URLS starting at K2 these urls come in because a rss feed

Code:

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+L
'
With ActiveSheet.QueryTables.Add(Connection:=

...

Ruchi22 · Oct 14 '11, 05:37 AM

I have a datagridview with checkbox column in form1.. When the user selects certain rows with checkbox, I wish those selected rows be visible in datagridview in form2..

Here is what i did..

First looped through rows with j, in the rows, counted columns available via i and then, tried to obtain the checked values..

Code:


        For j As Integer = 0 To Form1.dgv1.RowCount - 1

...

sammyj · Oct 7 '11, 05:49 AM

Howdy,

I need to create a pair of circles, but have them drawn five times onto a single window. I am totally stumped. Here is what I have so far that prints one pair of circles:

Code:

def p91_clone():
    win = GraphWin("cloning dots")
    leftEye = Circle(Point(80,50),5)
    leftEye.setFill('yellow')
    leftEye.setOutline('red')
    rightEye = leftEye.clone()
    rightEye.move(20,0)

...

John Co · Aug 9 '11, 01:09 PM

I have very little knowledge or experience with VBA. I have an HTML file that is not in columns. It is a report that lists every time a vehicle comes in for repairs.

VIN 5578

Date 7-8-99

Part No. Duration. Code
8657 77 09H
1937 2 18S
9192 123 87J

The report repeats for each occurrence. Could someone...

farid121 · Mar 1 '11, 08:06 PM

I am trying to update the main form with each record in the subform.
I have two tables Invoice and Payment table.
The main form has the payment details which I need to update for each invoice selectedon the subform.
EG
Invoice Table (SubForm)
Ref no , Inv No , Amt
1 , 101 , 10.00
2 , 102 , 20.00 etc

Payment Table Feilds...

Steven Sargent · Feb 24 '11, 02:54 AM

EDIT: I figured out my problem. Thanks.
There was no problem with my loop. The error was elsewhere in my code.
............... ............... ............... .

Deekay · Feb 4 '11, 01:28 PM

I am using a straight forward For Next Loop which operates perfectly when I write

Code:

For n = 1 to numOfDigits
'do something
Next

However when I change this to

Code:

For n = numOfDigits to 1 Step -1
'do the same thing as before
NEXT

(where numOfDigits = 8 at this point in the code)
I am getting an error message saying 'overflow' at the For... line...

Colin Rodrigues · Feb 3 '11, 08:50 AM

I have 2 arraylist which have equal number of elements. I need to print these values alternatively in an html table..for eg:

arraylist1 conatins: moviename1,movi ename2,movienam e3
arraylist2 contains: 8.00pm, 9.00pm, 10pm

Now, it has to be printed like this:

=============== =============== ==============
moviename1
=============== =============== ==============
8.00pm
=============== =============== ==============...

Colin Rodrigues · Jan 31 '11, 03:29 PM

this is my data,

cinema1 4pm
cinema1 5pm
cinema1 7pm
cinema2 2pm
cinema2 4.45pm
cinema3 10.45am

These are 2 different coloumns which I get from a webservice which can be arranged into an arraylist or array.. Now what I need is..the data to be displayed as follows..

cinema1
4pm 5pm 7pm
-----------------
cinema2
2pm...

ronparker · Jan 11 '11, 11:49 PM

Hey guy!
I have a couple questions, which I don't think are too advanced. I created an algorithm called "Best" for simplicity I will not include the mathematical details of it. I ask the user to input 6 values: Stock, min,win,Stop,GO , and end. Looking at the last 5 inputs, they are all integer inputs eg: 1,2,3.
This code will take my algorithm and spit out a csv file called "boom.csv" with two columns of numbers...

Search Result

Inefficient Loop

Batch script for database restoration

multiplication test

Reading from array into the file - with encoding ascii characters

Access Loop Combo

Looping Marco thur url

Looping in Datagridview

Draw five times on one window with for loop

VBA script to pull data from HTML file into an '07 Ms Access database

Recordset Update from one table to another using main form/Subform

What is wrong with my foreach loop?

How to fix overflow error message in for next loop?

How to print alternate arraylist values from two arraylist?

How to loop through two arraylist?

How to loop to make many .csv files?