Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 3rd, 2017, 01:35 PM
Registered User
 
Join Date: Jan 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default DO Loop Error

I have 4 databases in MS Access 2010 (Data is in SQL Server 2008) Front end only in MS Access 2010. I've been tasked with building a new front end and migrating the 4 different Databases (from 4 different departments) into a new combined database so all 4 departments are able to see the other departments data and to merge those records that exist in different departments but are for the same person. I've built the data structure for the new database and am now working on migrating the data from the 4 into the new database but I'm getting a weird error. I have a do loop to loop through each record in the departmental database step one is to import the customer data into the new structure. the new structure also includes a primary key of the first four letters of the last name plus the first four letters of the first name plus the DOB in the format mmddyyyy So John Johnson born 1/1/1974 would be JohnJohn01011974

I then have a nested do loop to take the existing data and export it to the related tables for that customer.

the issue is that on the outer loop I'm getting an error that states there's no do associated with that loop but I've rechecked the code and there are 2 do statements and 2 loop statements so the error makes no sense.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Error type: Loop without Do cannielynn0312 Classic ASP Basics 1 February 21st, 2008 09:15 AM
loop error crmpicco Classic ASP Databases 7 March 4th, 2005 10:59 AM
'loop' without 'do' error! tjh205 Classic ASP Basics 3 January 22nd, 2004 07:58 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.