Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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
  #11 (permalink)  
Old January 12th, 2007, 12:39 PM
Registered User
 
Join Date: Jan 2007
Location: overland park, ks, USA.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

All of the data I am capturing is just text...

The screen looks like this

 SICE04 CUSTOMER SEARCH ENTRY 10:29 CS 01/12/2007

 PRO NUMBER CHK DIGIT SUFFIX BILL DATE ORG DST
 054 - 704279 7 01/11/07 ATL MED

 PPD/COL: P SERVICE TYPE: SG


 SHIPPER: NAME SIEMENS
             ADDR 3130 N BERKELEY LAKE RD NW
             CITY DULUTH ST GA ZIP 30096

 CONSIGNEE: NAME MARVINS INC
             ADDR 2015 HIGHWAY 19 N
             CITY MERIDIAN ST MS ZIP 393074959

 BILL TO: NAME SIEMENS INC % DATA2LOGISTICS
             ADDR PO BOX 61050
             CITY FORT MYERS ST FL ZIP 33906


  EXIT CITY ST ZIP COUNTRY
  ______________________ __ ______ ___



  TENDERED BY NAME
  _____________________________________


  SHIPPER ROUTING ____ TIME CRITICAL: _

 ORIGIN CARRIER LINE
 SCAC DATE BILL NBR AMOUNT
 ____ __ / __ / __ ________________ _______

 ORIGIN CARTAGE
 SCAC BILL NBR AMOUNT
 ____ ________________ _______

 FUNC ENTER-NEXT PF1-HELP PF2-MENU PF5-CUST SEARCH PF6-RESET
 KEYS: PF9-PRNT SESS PF15-ERRORS PF16-CODE MANUAL PF18-COR PF24-FORCE
 MSG ==>

the loop file looks like this:

SICE04_Name SICE04_Row SICE04_Col SICE04_Length
ProNumberProPrefix 4 2 3
ProNumber 4 8 6
ProNumberProChkDigit 4 22 1
ProNumberProSuffix 4 32 2
BillDate 4 40 8
OrgTerminal 4 55 3
DstTerminal 4 63 3
Ppd-Coll 6 11 1
ServiceType 6 36 3
ShipperName 9 19 45
ShipperAddr 10 19 45
ShipperZip 11 57 9
ConsigneeName 13 19 45
ConsigneeAddr 14 19 45
ConsigneeZip 15 57 9
BillToName 17 19 45
BillToAddress 18 19 45
BillToZip 19 57 9
ExitCity 23 3 22
ExitSt 23 27 2
ExitZip 23 31 6
ExitCountry 23 39 3
TenderedByName 28 3 37
ShipperRouting 31 19 4
TimeCritical 31 46 1
OrigCarrierSCAC 35 2 4
OrigCarrierMonth 35 8 2
OrigCarrierDate 35 13 2
OrigCarrierYear 35 18 2
OrigCarrierBillNbr 35 22 16
OrigCarrierAmount 35 40 7
OrigCartageSCAC 39 2 4
OrigCartageBillNbr 39 8 17
OrigCartageAmount 39 27 7


The table I am adding to looks like this

FullProNumber ProNumberProPrefix ProNumber ProNumberProChkDigit ProNumberProSuffix BillDate OrgTerminal DstTerminal Ppd-Coll ServiceType ShipperName ShipperAddr ShipperZip ConsigneeName ConsigneeAddr ConsigneeZip BillToName BillToAddress BillToZip ExitCity ExitSt ExitZip ExitCountry TenderedByName ShipperRouting TimeCritical OrigCarrierSCAC OrigCarrierMonth OrigCarrierDate OrigCarrierYear OrigCarrierBillNbr OrigCarrierAmount OrigCartageSCAC OrigCartageBillNbr OrigCartageAmount
043-397127


  #12 (permalink)  
Old January 12th, 2007, 12:45 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Okay, where did the loop file come in and what is it for?

Given the first screen, you can capture the data and post it to the table you have.

What is the loop table supposed to do?





mmcdonal




Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing variable to a public variable Hudson40 Access VBA 2 February 25th, 2005 06:23 AM
assign a recordset to a variable biggen55 VB How-To 1 March 26th, 2004 02:26 PM
How to bind text box to recordset fields? cici VB How-To 2 December 1st, 2003 02:10 AM
using fields in recordset to populate textbox stoneman Access 2 October 7th, 2003 11:03 AM





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