Fixed Format by Starting Characters

[vbaInet]

At this point, it would be worth sending some sample data as you initially offered

10 distinct records will do. Post it here.

 

[JDeezy]

Ok, It wont be til tomorrow. But I will get that posted around 9am. Thanks for all your help os far. Hopefully tomorrow we can figure this mess out.

 

[ChrisO]

I guess it will be 9:00AM somewhere tomorrow.

 

[vbaInet]

I guess it will be 9:00AM somewhere tomorrow.

You would have to wait another 14 hours Chris

 

[vbaInet]

Ok, It wont be til tomorrow. But I will get that posted around 9am. Thanks for all your help os far. Hopefully tomorrow we can figure this mess out.

You could check your outbox and post some bits from what you posted to Allan.

For all we know, Allan might even be here tomorrow with a fix haha!

 

[ChrisO]

I’m already at 9:00AM tomorrow; so where’s the data?

 

[vbaInet]

I’m already at 9:00AM tomorrow; so where’s the data?

Haha! It's a few minutes past already so if you're lucky it would be another 24 hours (minus the few minutes) before JDeezy gets it to you (if he/she is in Australia)

 

[ChrisO]

I think it’s around Houston time (GMT-6) because the OP was leaving work at 5:00 PM Thursday and would be posting at 9:00AM the following day.
So I was at Friday 9:00AM and that is tomorrow 9:00AM (GMT-6).

 

[vbaInet]

I think it’s around Houston time (GMT-6) because the OP was leaving work at 5:00 PM Thursday and would be posting at 9:00AM the following day.
So I was at Friday 9:00AM and that is tomorrow 9:00AM (GMT-6).

I see you've been doing some googling Chris hehe! Or did you write some quick VBScript to get the closest matching GMT to 5.00 p.m.?

 

[ChrisO]

For a lot of years I’ve wanted posters to show a location but some web masters say it’s a violation of privacy.
So I tend to look at the probability of a posting time and then use this link: -

http://www.timeanddate.com/worldclock/

Edit to add.
And it can sometimes indicate the Regional Settings that an OP might be using.

 

[vbaInet]

I had already used that site to check the time in Brisbane

 

[ChrisO]

Yes but in all probability it would not be in Australia unless the OP does shift work.
However, Australian shift work generally runs 11:00 to 7:00 not 1:00 to 9:00.
And if we put together the times of the replies, RuralGuy (Colorado Rockies), the probability seems to narrow itself to US central time.

It's just a probability but it's better than nothing.

 

[vbaInet]

Interesting deduction Chris

We better not clogg this thread so the OP doesn't think we've taken over haha!!

 

[JDeezy]

Attached are the specs and test file that I sent to allan.

 

[RuralGuy]

I apologize JD but I've been buried in meetings all week. It would have been nice if you could have included what you had so far in a db as a reference.

 

[JDeezy]

I'm sorry I really didnt have much in a DB other than what you already gave me. I can compile what I have from you and vbaInet into a DB if you would like.

 

[RuralGuy]

Not necessary now. I'm cobbling something together.

 

[RuralGuy]

What version on Access do you use?

 

[vbaInet]

Allan is back.

Function SetFieldVal(fieldID As String)
Select Case fieldID
Case "PC01"
'-- Name Field
fieldName = "NameField"
fieldLen = 95
Case "FI01"
'-- Address field
fieldName = "AddressField"
fieldLen = 23
Case "NM01"
'-- Shipping Address
fieldName = "ShippAddField"
fieldLen = 70
Case "PR01"
'-- Bankruptcy Info
fieldName = "BankField"
fieldLen = 168
Case Else
'-- Unknown field identity
fieldName = ""
fieldLen = 0
End Select
End Function

By the way JDeezy, I've just noticed that you have one less field than what it was coded for. It was coded for 5 fields, not 4. Notice the 5s in the code as well? Also the number of characters that identifies each ID is 4, but you mentioned 5 . All these things were not handled in the code.

 

[JDeezy]

Allan, I use 2002. And yeah i noticed that which I changed in the code in my DB but still no progress. Originally I was just going to use this forum as guideline but it turns out this is a little too advanced for me. I just posted an example off the top of my head instead of looking at the exact spec. I learned my lesson.