Search results

Setfocus selects everything, doesn't it?

SELECT * FROM Table1 ORDER BY Len([Operation]) & [Operation] edit arnelgp's looks like it may do a similar thing more thoroughly.

It thinks InGroup is a field. Just add 'Dim Ingroup' or use a different name. Edit. Sorry brain fade.

ingroup isn't joined on any other field, so you are performing the same lookup for every record for no reason.

Create a new form. Add a list box called 'FileList'. Add a command button called 'btnSearch'. Add a textbox called 'txtClient'. Paste the code into the form's module. Const FOLPATH As String = "\\server3\d\Excel Files CLients\Accounts\" Private Sub btnSearch_Click() With FileList...

1GB is half the maximum size of a database so a filtered recordset shouldn't be a problem.* The problem is the amount of forward planning required before you commit to the final solution. *temporary storage exceeding 2gb could be.

You'd build the result up in a temp table rather than using UNION. Delete * from tmp INSERT INTO tmp SELECT * FROM [2017.accdb].table1 WHERE field1='foo' INSERT INTO tmp SELECT * FROM [2016.accdb].table1 WHERE field1='foo' INSERT INTO tmp SELECT * FROM [2015.accdb].table1 WHERE field1='foo'...

Not really. I had the wrong end of the stick, thought you were appending to Excel. I've never used sharepoint. Maybe it just doesn't send a message back.

You don't change user settings unless you want to be hated. It's easy enough to create your own translator. Sub eg() Debug.Print "today is " & DayName & " which is " & DayName(romanian) & " in romanian and " & DayName(french) & " in french" Debug.Print "tomorrow is " & DayName(...

When creating a linked table to Excel, Access says...

A passthrough query sends SQL directly to the server. Access doesn't process anything. Any valid SQL should work. It's no different than using ADO. You create the connection, send the SQL to the server.

http://www.dbforums.com/showthread.php?1006185-Writing-Pass-Through-Queries-in-VBA ...or just connect with ADO.

Like "*" & [forms]![frmContactHistory]![Text26] & "*"

Your msgbox code looks fine. Add a breakpoint and step through the code. Have you tried requery in place of/as well as refresh? (If the command is aborted you don't need to refresh/requery.) If your query modifies data, you should use docmd.runsql Or better yet currentdb.execute "queryname"...

FROM [Text;Database=path; Doesn't make sense. You haven't provided a table name and the brackets aren't closed. FROM [path].[table] somestring = "... from [" & path & "].[" & table & "]" Edit: kudos for making me Google getrows.

Nope. Works ok here. I didn't use a table called "MessagesReviewed"...

Yes. Use the Dir() functionin a loop Const folder As String = "c:\...\*.txt" dim FileName as string FileName = Dir(folder) Do Until FileName = "" select... ... End Select FileName = Dir Loop

How is £70 better than a bit of work you can do yourself for free?

Well at a glance, the code labels each file with the object type, so when you are loading them back in check the filename and replace the constants accordingly. select case true case left(filename,len("form_")) = "form_" Application.LoadFromText acForm, filenameWithoutType...

Save everything as text and import into a fresh db. https://access-programmers.co.uk/forums/showthread.php?t=99179 Comment out the tabledef export stuff, import them as normal.