Recent content by RobJDB

Ok, thanks for the explanation! Rob

Gabe, Would it not be replace(readline, """, "") - three not four in the second argument? Rob

Is it because you've got text qualifiers (") surrounding your strings? The " sign is chr(34), so you could create a string like this: strSeparator = chr(34) & "," & chr(34) and use it as your delimiter: Split(readline,strSeparator) but then you'd still need to strip the...

Phil, I've not come across a .pdb before, but I've used software that generates delimited text files and gives them custom extensions. Have you tried simply renaming it to a .txt? Robert

Thanks HTH, In the end I wrote a little module to go through the table in the required order and set the value of my new field using a simple incremental. It seems to me that when you sort a table, Access doesn't really re-order the records, it just *displays* them in the new order. I'd be...

Hi. I'm importing a tab-delim'd txt file to Access. I then need to sort it by one of its fields. Then, I need to add an autonumber PK, but when I do this, the order reverts to how it was on import. Is it not possible to re-order and then maintain this new order when I add my primary key...

How's your javascript? :o You'll be best off filling a javascript array on-the-fly using asp. This javascript array will contain all possible telephone numbers and departments. Then you use javascript form handling to make the switch when a user selects something. It's not actually as...

Check the security settings on the database (are you using pws/iis?) - you need to have write permissions for the user (all users perhaps - depending on who's going to use your application). If this isn't clear, tell me more about your set-up. Rob

Thanks guys for all your help. I'll probably use a combination of all these suggestions.

Nice one Dave - good help! Rob

Sounds good, but can I update what's shown on this form as the code progresses, eg: Searching field 1... Updating field 1... Searching field 2... Updating field 2... etc.?

Is there any way to let the user know what's happening as a lengthy piece of code is executed, but without requiring the user to interact at all? I don't want to use a message box, because then the user would have to click 'ok' each time. Thanks

Does either of you (or anyone else) know how to create an autonumber primary key field for a new table in ADO? Thanks, Rob

Thanks Bastien. I knew about ORDER BY, but something else is going wrong. Looking more closely, it seems my recordset is actually in the correct order, but as I copy its records one by one into a new table, they go out of order in the new table. Could this be because the new table has no...

I want to open a recordset with ADO. I want to order it by the primary key (called "ID" in this case). Trouble is, another field in the table is indexed, so my rs comes in in a weird order. How can I ignore the index and just order my rs by the ID field? Cheers, Rob