Recent content by MossleyMike

Don't get me wrong - I'm with you all the way - it's just that the majority of users "at our place" believe spreadsheets to be the answer to life, the universe and everything, and regularly worship at the Church of St Excel. I just spend too much time using Access as a "staging post" , writing...

Twa always a shame with TransferSpreadsheet - it can handle a row of headers but not a column of row numbers ! Must have a word with Bill.....:-)

Running the sort after the "import" seems the most sensible way - but maybe the "sort sequence" required is not a logical sort (numeric, alphabetic etc). I've just tried this today - run the "TransferSpreadsheet" routine but use acLink rather than acImport. I set up a table in the database...

Tend to avoid Macros, so "AutoKeys" appears to have passed me by :) It works a treat though - many thanks.

I have an database that is secured to keep those pesky users out (disabling <F11> and all the other "stuff" - however there is an Admin option (passwords etc) - and I wondered if anyone knew of a way to open the database window via some fancy code behind a button. Having looked at...

Unbound Memo The Code certainly worked for me too :) Tried the Query/Parameters route - but then it fell over as the number of characters in the query was > 1024.

I don't have a problem with the security on the particular database in question - although I never underestimate the "power of the user" ! The original question, therefore still remains unanswered ...

Password Protect a Form Looking at this thread, I've used the same kind of code, input mask etc. What would interest me is a way of hiding/encrypting the actual password within the event code, i.e. rather than: If str = "Password" then open database etc to have If str = "&^%@@" then open...

VBA or Queries Thanks for the advice ...:)

VBA or Queries I think the point I was trying to get over was which is better - a query as in: "Select A,B,C from Table_Z" or a bit of vba as in: Dim dbs as Database Dim rst as RecordSet Set dbs = Currentdb Dim strSQL strSQL = "Select A,B,C from Table_Z" Set rst = dbs.OpenRecordSet(strSQL)...

In a number of the database applications I've written I tend to "mix and match", using both vba code and ordinary queries. What does the team think is the most efficient way of writing applications - vba or queries or a mix ??? Which is more efficient ?? Are there any space considerations ...