Search results for query: *

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

Okay, but how do I create it with the Autonumber property and make it a primary key? Thanks, Rob

Hello, I've created a table and populated all its fields using ADO and now I want to add an auto-increment field to it, fill it up, and make this the primary key, all within ADO. I've found bits of information on these forums but nothing comprehensive. Also, when I'm creating fields using...

gol4, raymondo, thornmastr, Thank you all for that. I've implemented the recommended changes and it worked straight away. I love it when that happens! I'll go and read up on ADO vs DAO today. Cheers, Rob

I think you do understand exactly what I want. Trouble is, when I put your code in, I got a type mismatch error on the currentdb.openrecordset part. This is what I currently have: Dim rs As ADODB.Recordset Dim constr As String constr = "DRIVER={Microsoft Access Driver (*.mdb)}...

I'm new to DAO, and I've been working on recordsets to get myself started. What I want to do is open a recordset from a table within the current db, wherever it may be copied or moved to. This means that instead of using something like: oConn = "DRIVER={Microsoft Access Driver (*.mdb)}...