the problem is that the queries dont sort
i orinily had this who code in a single query which i told to orderby sortnum
but sometimes with about 5% chance the table would come out unsorted
its the craziest thing
i fixed it by saving the table in the recordset line by line to another table, its definitely not the best solution but it works 100% so far
i have a quick question, should i have used adodb there? is dao...
Bob Laubla
Last Activity: Jun 24 '08, 04:16 PM
Joined: Mar 3 '08
Location:
-
The form does not have a record source, this is a small chunk of the code that I have. I work for a survey firm, and this program generates a comparison between different surveys and it groups them in a very complicated way. All of that is done during the generation of SortNum. At the end of this procedure I have a table. I need this table to be sorted. Immediately after this code I export the table to Word and run a series of Word VB functions to...Leave a comment:
-
Sorting
I have a possibly silly question. I taught access to myself by using it so I might have spotty knowledge in certain areas. I have access 2003.
This is my code:
...Code:runSQL "SELECT DISTINCT TopicLabel, ContentLabel, First(Section) AS firstSection INTO TMP_tblLabels FROM TMP_tblMain GROUP BY TopicLabel, ContentLabel HAVING ContentLabel<>'__Heading__'" Dim rstLabels As New ADODB.Recordset rstLabels.Open
-
Well, the thing is that I don't have that much records. The table usually has about 300-400 rows. It's just that per row, the last few cells have 10-60 lines of text in them.
Hmm, this gives me an idea. I will create a unique id for each row, then create 2 tables, first one with the sorting number and the id and the second one with the id and the rest of the row. Then sort the first simple one, and then link on id to the rest of the...Leave a comment:
-
Odd Key Violation Errors
Hello
I'm working on a database which contains surveys.
Currently I'm having issues with a form that allows users to renumber the survey by dragging questions from one place to another, and also decide weather a question is stand alone or has subquestions. I have actually completed this form and it works perfectly on our database, but a co-worker of mine is working on a different project and said that she would like to use this form... -
MS Access Sorting
Hello
I have a very complex maketable query with many records and involving multiple VB functions which call other functions.
I need this table to be sorted by the first field.
But no matter what I do, there is a small chance of the table coming out unsorted.
I have tried sorting it with the 'make table' query.
I have tried sorting it with Word during output (my current configuration runs 4 of these).
I have...
No activity results to display
Leave a comment: