Recent content by jguscs

...OK? I'm not quite sure what you said has anything to do with "random" sorting during a text import (but I'm sure it does...). Are you saying that it's a bad idea to delete the default index settings?

I believe what you want to take a look at is an option called "AutoIndex on Import/Create." It is located in the "Tables/Queries" tab in Options. There is a default AutoIndex filled in for you. Delete the default entry and importing will no longer change the order of your rows.

I've done searches on the forum for this issue, but no one has gotten this specific. I built a database with some VBA coding in Access 2000. Then, I tried to run the database on Access 2002 and unfortunately, it does not work in two respects. I will try to be as detailed as I can. By the way...

GumbyD: I'm sure you're right (I'm sure Pat's right, too, but I'm much closer to understanding transfer queries than ADO/DAO/DLL). I'm going to have to ask you for some assistance, however. I intend to set up a "template" table with certain fields designated as type Date. The template table...

Right, the datatype at the table level is TEXT. That's precisely what I want to change to Date. The reason why it's text is because I began trying to solve the problem of importing an XLS file to Access and Access mis-designating the type of each field. (Example: Access would designate a type...

I'm trying to overcome some problems I'm experiencing with my SQL statement that's supposed to update the field type of every cell of a particular column from a text value to a date value. The contents of each cell are in the format x/xx/20xx, so there shouldn't be a problem converting, should...

The_Doc_Man: Thanks for the tips. I am having trouble with the first generic pitfall you mentioned. Could you please help me out with the syntax/code for the method you suggested as a workaround for importing spreadsheets with text in fields of other data types? I would think the process to be...

I'm having the same problem you did, Dugantrain. I tried your solution (importspreadsheet, transfertext, transfertext), but that did not work. The part that didn't work for me was when Access tries to import the .TXT with column names (=TRUE), but Access just ignores that and uses F1..F23 for...

It's a good point, ghudson, and you'd think that AfterUpdate would handle changes made by the user. And it does handle mouse-click changes correctly. But it does not handle up-arrow and down-arrow selection changes correctly: It handles these events in a KeyDown-style method. IE: text fields...

ghudson: 31 is supposed to be ASCII for the arrow down key and 30 is supposed to be for the arrow up key. I was trying to figure out if I could use the KeyUp procedure based on certain cases.

OK, dcx693: I've got a list box that, when an entry is CLICKED, will automatically update some text boxes with data from the clicked entry. This works with the ListBox_Click() Procedure. The problem is that if the user presses an up or down arrow to change from entry to entry, the text boxes...

How can I use the KeyCode of the KeyDown event from within the event? Private Sub ListBox_KeyDown(KeyCode As Integer, Shift As Integer) If ____.KeyCode = 30 Then MsgBox "Up" If ____.KeyCode = 31 Then MsgBox "Down" End Sub

OK, what you suggested did work. I'm checking the table one column at a time with a DLookup and if there is an error (because DLookup can't find the column that it was supposed to be able to find), I have some error-checking code that sets the control that was SUPPOSED to be linked to the...

I was going to copy the code when Access crashed. It'll take a sec. The user can select the table to use for the report's source from a list box in the Switchboard form. Then, when the Report opens the following code is run: Private Sub Report_Open(Cancel As Integer) Dim varItem As Variant...

I don't know, SforSoftware, maybe Access thinks the control source for the control IS being left blank, but in fact it's not blank-- it's just pointing to a field that's not available in the table.