Search results for query: *

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

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

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

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

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

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

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 having a problem using DoCmd.ApplyFilter to retrieve from a dataset. My code is below. Private Sub Execute_Click() Dim WhereClause As String WhereClause = "" 'Each toggle turns off and on a different column to search If Me!ProToggle = True Then WhereClause = WhereClause & "[ViewPosition]...

I have been planning a conditional form to select certain header attributes of medical image files and create a query of the image files in the ~30 column table that meet the requirements. I was thinking that I could make toggle switches to include or disinclude each column information. For...

Hello all, I am new to this site and Access, and I was just wondering if anyone knows the best way to output into a table certain drive pathways for image files, for example: c:\programs\images\fun.img I also saw this solution on a different site this command but do not understand how to...