Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RobJDB

    CSV problem....

    Ok, thanks for the explanation! Rob
  2. RobJDB

    CSV problem....

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

    CSV problem....

    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...
  4. RobJDB

    Identifying a file format

    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
  5. RobJDB

    Why do I lose the sort order?

    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...
  6. RobJDB

    Why do I lose the sort order?

    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...
  7. RobJDB

    Update Formfields from dropdown

    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...
  8. RobJDB

    Query Error

    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
  9. RobJDB

    keep user informed as code runs

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

    keep user informed as code runs

    Nice one Dave - good help! Rob
  11. RobJDB

    keep user informed as code runs

    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.?
  12. RobJDB

    keep user informed as code runs

    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
  13. RobJDB

    Primary Key Function

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

    Recordset order

    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...
  15. RobJDB

    Recordset order

    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
  16. RobJDB

    Create and populate an auto-increment Primary Key field with ADO

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

    Create and populate an auto-increment Primary Key field with ADO

    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...
  18. RobJDB

    Open recordset from current database

    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
  19. RobJDB

    Open recordset from current database

    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)}...
  20. RobJDB

    Open recordset from current database

    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)}...

Part and Inventory Search

Back
Top