Search results for query: *

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

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

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

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

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

Am I correct in thinking that, in an Access module, I can open a recordset and then use such commands as rs.fieldname.value = "..." to update the contents of the table on the fly, whereas in ASP, all I will change is the contents of the recordset, not the table itself? Basically, I...

Is it possible to open a popup window that has a form in it, and then, from the parent window, change the values of the form fields in the popup and then submit it and close it? I know about passing values and picking them up in the popup, but the trouble is I cannot edit the code of the popup...

Is it possible to populate a drop-down list on a form with the names of all the tables in the current database? (Access 2000) Basically, I want a user to choose a table, and then I'm going to run a load of code on that table to compress it to half the number of records with twice the number of...

Does anyone know why I'm getting a 'type mismatch' error on the last line of this code? I'm using Access 2000. Dim myDB As Database, myTB As TableDef Dim myFD As Field Set myDB = DBEngine(0)(0) Set myTB = myDB.TableDefs("scores") ' scores is the name of the table I want to add a...

I have a memo field in my Access db, and it contains the <% ... %> tags within a load of other text. If I display the field within a text box, the tags show just like they should, but if I display it straight on a page, the <% ... %> bits are ignored (or processed?). Does anyone know how to...

How would I populate a text box on an Access 2k form with a list of field names from a table?

Hi, When I use Dim myDB As Database I get the error message 'User-defined type not defined'. I also get it if I use Dim myDB As DAO.Database I'm using Access 2000. Does anyone know what I should do? I'm aware that Access 2k uses ADO by default, not DAO (although I don't really know what...

I have an Access DB with over 40 tables, and in each table, any field may contain a particular character code which I need to replace with the character itself. What I effectively need is a Find & Replace that'll sweep across every field in every table in one go, or a query perhaps. Does...

If I set my monitor to 16 bit colour, then try to set the background colour of movie in Flash to, say, #ffcc00, Flash sets it instead to #ffcf00. This is just one example of it messing the colours up. It doesn't happen when my monitor is set to 32 bit colour. I don't understand why there...