Search results for query: *

[code] ' The following lines move a field to the Leftmost part of the table if it is in the last column. cols = tbl2.Fields.Count p = tbl2.Fields(cols - 1).Name tbl2.Fields(0).OrdinalPosition = 1 ' This line may not be necessary tbl2.Fields(cols - 1).OrdinalPosition = 0...

That worked like a charm Chaz! Thank you so much, what a difference one word makes in SQL!

I actually solved this by using the .OrdinalPosition property. It workwed well and moved the field columns into any order required.

Hello all, I was wondering if I was to make a query def with this SQL statement, how would I do it correctly? SELECT * FROM sampletable WHERE (SELECT FORMAT([Rows],0000) FROM sampletable) < 800 I would like to format the 'rows' column as all numbers but it is currently a text column and too...

AccessGuruCarl, Is there a way to do that with a table? I just pasted the examples in msdn for the Column Order property. I should've typed: Tables!CurrentTable!ColumnSpec.ColumnOrder = 1 If there is a way to do this, how or where in the code should this statement be put in?

In my last post I was looking for a way to set an autonumber field for new tables automatically in code. Now I need to find a way to move the column from the last in line to the first in code, and I haven't had much luck getting this to work yet. I've been trying something like...

PHV, you've done it again!! So many times you've helped me. Thanks. One last thing, is it possible to move the column to be the first in the table because it shows up last in the table after being added on by the sql.

I forgot to add that I'm using Access 2000 and I know its easy to create an autonumber field but I was hoping that you can set one up while appending fields to a tabledef

I have VBA code that makes a Tabledef if its name doesn't already exist in the database and adds it to my other tables, but I wish to set its ID field to Autonumber (Long). Any ideas as to how to do this? Thanks

I forgot to mention, I have been trying this by creating the fields, appending the tabledef, then opening the recordset by the same name. The recordset always has trouble with setting index

Hello. I have been trying for the longest time to set up a table of computer folder pathways like "C:\Tmp\bin" and other data columns using TableDef and CreateField lines. That part now works fine but I would like to take this new table and index a field so I can use the Seek function to find if...

I have been trying to find a way to list the records in my recordset that are being deleted when it updates and also list the records that are added new. I wanted to just put in a couple of lines of code so when the file is deleted or added new, the program would record it and output a log. Does...

Thanks PHV, just the thing I was looking for.

Is there a way to take a select query and make it into a possibly column-justified text file (.txt)? I haven't been able to find any instances of outputting text so any help is quite appreciated. Thank you

Thanks for your input. I did find a different way to do it from a MSDN article on Query By Form method and using QueryDef objects. I could possibly use your method in the future though. Thanks

I have gotten tips on how to set up docmd.applyfilter statements but I still need to question the site experts more. Sorry! I do not necessarily need just code tips, but insight into making a form that queries a table and produces results consistent with the query but returns the result records...

The Delete Confirm dialog box isn't displayed if you clear the check in the Record Changes check box under Confirm on the Edit/Find tab of the Options dialog box, available by clicking Options on the Tools menu. J. Handfield Interning Scientist Eastman Kodak Research Labs Rochester, NY 14650

I made a post yesterday about trying to make a DoCmd.ApplyFilter statement with a variable size wherecondition. I'm starting to wonder if thats the right approach to my problem. I really need to filter maximum 7 colums out of 30+ total columns for each tabular record and view all 30+ columns of...

I'm not sure if you're still there PHV, but if you see this, I have a last question for you or anyone else with form-guided query knowledge. I saw the datasheet view and it only displayed the few columns that I sorted by and the others were ignored. If I didn't use all my sorting colums, for...

Thanks for that PH, I just entered that as: Forms!RunDicomQuery.RecordSource = "Sample Table" The results are then kept on the form though. Is it possible to make the results show up in a table with all their columns of info like a simple query done with a wizard? J. Handfield Interning...