help! i'm caught in the endless of "compile error message: do without
loop." i thought that i closed all of my statments but it appears
not. does anyone know why my structure is incorrect?
what i'm trying to do is to find "series key" and if so, then parse
the appropriate data. then if it finds "issuer" it needs to exit.
thanks in advance!!!
jung.
Set rst = dbs.OpenRecords et("Test", dbOpenDynaset)
Set rstclean = dbs.OpenRecords et("CDtest", dbOpenDynaset)
rst.MoveFirst
Do Until rst.EOF
'Open Current Record for editing
If x = InStr(rst![Field1].Value, "SERIES KEY") Then
Do While InStr(rst![Field1].Value, "SERIES KEY") <> 0
rst.MoveNext
rst.MoveNext
rst.MoveNext
Do Until IsNumeric(x) = False
rstclean.AddNew
key = rst![Field1].Value & " "
'etoile = rst![Field2].Value & " "
Pay = rst![Field2].Value & " "
Coll = rst![Field3].Value & " "
cashbalance = rst![Field4].Value & " "
rstclean![series].Value = key
'rstclean![Star].Value = etoile
rstclean![Payments].Value = Pay
rstclean![Collections].Value = Coll
rstclean![CashBal].Value = cashbalance
rstclean.Update
rst.MoveNext
x = Len(rst![Field1].Value)
Loop
rst.MoveNext
Loop
rst.MoveNext
ElseIf InStr(rst![Field2].Value, " ISSUER") <> 0 Then
Loop 2 4266
"ElseIf InStr(rst![Field2].Value, " ISSUER") <> 0 Then" needs a body
and an "End If" before the "Loop" statement.
On 3 Mar 2004 16:15:51 -0800, pi******@yahoo. fr (JMCN) wrote: help! i'm caught in the endless of "compile error message: do without loop." i thought that i closed all of my statments but it appears not. does anyone know why my structure is incorrect?
what i'm trying to do is to find "series key" and if so, then parse the appropriate data. then if it finds "issuer" it needs to exit.
thanks in advance!!! jung.
Set rst = dbs.OpenRecords et("Test", dbOpenDynaset) Set rstclean = dbs.OpenRecords et("CDtest", dbOpenDynaset) rst.MoveFirs t Do Until rst.EOF 'Open Current Record for editing If x = InStr(rst![Field1].Value, "SERIES KEY") Then Do While InStr(rst![Field1].Value, "SERIES KEY") <> 0 rst.MoveNext rst.MoveNext rst.MoveNext Do Until IsNumeric(x) = False rstclean.AddNew key = rst![Field1].Value & " " 'etoile = rst![Field2].Value & " " Pay = rst![Field2].Value & " " Coll = rst![Field3].Value & " " cashbalance = rst![Field4].Value & " " rstclean![series].Value = key 'rstclean![Star].Value = etoile rstclean![Payments].Value = Pay rstclean![Collections].Value = Coll rstclean![CashBal].Value = cashbalance
rstclean.Update rst.MoveNext x = Len(rst![Field1].Value) Loop rst.MoveNext Loop rst.MoveNext
ElseIf InStr(rst![Field2].Value, " ISSUER") <> 0 Then Loop
You did not close your IF statement. It requires an End If. Sometimes
compile errors having to do with any type of loop can be deceiving. Almost
as if the compiler just picks the first block when any End statement is
missing. Also, I'm not sure what you are trying to do with the last two
lines, so they may or may not cause a problem. If not an error, then likely
a logical one.
Mike Storr www.veraccess.com
"JMCN" <pi******@yahoo .fr> wrote in message
news:27******** *************** **@posting.goog le.com... help! i'm caught in the endless of "compile error message: do without loop." i thought that i closed all of my statments but it appears not. does anyone know why my structure is incorrect?
what i'm trying to do is to find "series key" and if so, then parse the appropriate data. then if it finds "issuer" it needs to exit.
thanks in advance!!! jung.
Set rst = dbs.OpenRecords et("Test", dbOpenDynaset) Set rstclean = dbs.OpenRecords et("CDtest", dbOpenDynaset) rst.MoveFirst Do Until rst.EOF 'Open Current Record for editing If x = InStr(rst![Field1].Value, "SERIES KEY") Then Do While InStr(rst![Field1].Value, "SERIES KEY") <> 0 rst.MoveNext rst.MoveNext rst.MoveNext Do Until IsNumeric(x) = False rstclean.AddNew key = rst![Field1].Value & " " 'etoile = rst![Field2].Value & " " Pay = rst![Field2].Value & " " Coll = rst![Field3].Value & " " cashbalance = rst![Field4].Value & " " rstclean![series].Value = key 'rstclean![Star].Value = etoile rstclean![Payments].Value = Pay rstclean![Collections].Value = Coll rstclean![CashBal].Value = cashbalance
rstclean.Update rst.MoveNext x = Len(rst![Field1].Value) Loop rst.MoveNext Loop rst.MoveNext
ElseIf InStr(rst![Field2].Value, " ISSUER") <> 0 Then Loop This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much appreciated.
Thanks in advance
|
by: Yannick Turgeon |
last post by:
Hello,
We are in the process of examining our current main application. We have to
do some major changes and, in the process, are questionning/validating the
use of MS Access as front-end. The application is relatively big: around 200
tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data
(SQL Server 2000), 40 users.
I'm wondering what are the disadvantages of using Access as front-end? Other
that it's not...
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
by: Grasshopper |
last post by:
Hi,
I am automating Access reports to PDF using PDF Writer 6.0. I've
created a DTS package to run the reports and schedule a job to run this
DTS package. If I PC Anywhere into the server on where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
|
by: Toby Newman |
last post by:
At the page:
http://www.strath.ac.uk/IT/Docs/Ccourse/subsection3_8_3.html#SECTION0008300000000000000
or
http://tinyurl.com/4ptzs
the author warns:
"The for loop is frequently used, usually where the loop will be
traversed a fixed number of times. It is very flexible, and novice
programmers should take care not to abuse the power it offers."
| |
by: Hardrock |
last post by:
I encountered some difficulty in implementing dynamic loop nesting.
I.e. the number of nesting in a for(...) loop is determined at run
time. For example
void f(int n)
{
For(i=0; i<=K; i++)
For(i=0; i<=K; i++)
|
by: James |
last post by:
I have a VB windows forms application that accesses a Microsoft Access
database that has been secured using user-level security. The
application is being deployed using No-Touch deployment. The objective
in utilizing this new deployment method is to reduce the maintenance
overhead as well as making it easier for my users to setup and run the
application initially. I have VS 2002, Windows XP, Access XP(2000
format).
He is my problem....
|
by: Sarah |
last post by:
I need to access some data on a server. I can access it directly using UNC
(i.e. \\ComputerName\ShareName\Path\FileName) or using a mapped network
drive resource (S:\Path\FileName).
Here is my problem: my vb.net program has problems with UNC. If the UNC
server is restarted or goes off-line, my VB.net program crashes. The code
for UNC access to the file is included below and is put in the tick event of
a form timer control running every...
|
by: The Facilitator |
last post by:
Well, Outlook seems to be making my life more and more challenging.
Categories are added in one field and are delimmited via comma. Have
three questions on this one...
The first is right now my query will only check the first characters
in the field to confirm whether they match the original split I did
with the other code I showed under VBA breakout (you'll notice I used
the code in the part I show here for part two and three of this...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |