Replies

Is there any way you can simplify this code for us? It’s a lot to read.

Scott – I’ve been busy writing the proposal as I’m sure now that I’ll be able to fulfill. I haven’t reviewed your code yet, but will start later in the week. Thank you!

I’m looking forward to seeing the code … does it use an ITC contol inside Access VBA to connect to the web site?

Hi Scott – Yes the Access database is on a website which can handle .asp.

Please let me know how you accomplish the feat of getting the data from the database on the website and populating local tables. I will be forever grateful.
I have a meeting with the web administrator on Friday and I’m sure s/he will set up anything I need to make it easier for me to get the data out of the web-hosted db — but right now I’m not sure what to ask for.

Help

hawksway … yes, but *how* did you get the data off the website so you could parse it? Can you tell me about the 3rd party object that does this?

Thanks John – I’m checking with the client to see where they host their site.

“a piece of cake”? – I am fascinated. What is this 3rd party object? Did you buy it somewhere?

I’ll be ever grateful for screenshots and any other info you can give me

Hi Jerry – Thanks – I need ideas.

Yes I could split the database into frontend/backend, but are you saying its possible to have the front end on a desktop and the backend hosted at an ISP?

I have never used the Data Access pages in Access – could this be part of the answer?

Post deleted by gwenda

brilliant!

Hi Howard – although i really like this book I have to say its not a great reference book for nitty-gritty syntax and stuff like that. There’s no CD. After using C# for 6 months I like it better than VB because I find it easier to use and understand.

Hi Howard,
I love “Visual C#.Net: A Guide for VB6 Developers”, although I never wrote VB6, just VBA. Wrox ISBN 1-86100-717-5

Hi Mark and Charlotte,
I talked to the legacy programmer and confirmed that the ASCII delimiter was 01 (that was a good idea Mark). Then investigating Regular Expressions a bit more, I found that I needed to include an “x” after the “” escape code to indicate that an ASCII character follows. So this now works:

string [] HoursWorkedFields = System.Text.RegularExpressions.Regex.Split(line,”x01″);

Regular Expressions are wicked!

Thanks MarkJ and Charlotte, I’ll try these ideas and let you know how it works.

Many thanks Jan … I will be trying it this week.