cheekybuddha's latest activity
-
cheekybuddha replied to the thread Solved File Dialog not Working.@LarryE - why do you loop the FD.SelectItems when you have already set .AllowMultiSelect = False? -
cheekybuddha replied to the thread Solved File Dialog not Working.You haven't displayed the dialog. Your code should be more along the lines of: Dim FileName As String Dim FD As FileDialog Set FD =...
-
cheekybuddha reacted to CJ_London's post in the thread Search while typing Multi Field Search Form in Ms Access with
Like.
In part because the syntax is not correct Since you are using the initial * you are not using indexing which will make this slow with... -
cheekybuddha replied to the thread Win64 version crashing.My statement was missing an 'if' 😖 It should have read: I looked at the code just now - it doesn't use proper subclassing (e.g...
-
cheekybuddha replied to the thread Win64 version crashing.I haven't looked at the Leban's code, but it uses proper subclassing (e.g. GetWindowProc() ) then you can not have the VBA editor open...
-
cheekybuddha replied to the thread Unable to connect to Remote (LAN) SQL Server Instance where both SQL Express and SQL Developer Edition are installed.If you have two different versions of SQLServer being served from the same machine then surely you need to assign one to serve on a...
-
cheekybuddha replied to the thread NumLock.There is some old code here on The Access Web but you will probably have to find update versions of the API declarations for 64bit.
-
cheekybuddha reacted to silentwolf's post in the thread Solved Select Into Query with varible issue with Haha.
Yes I guess so David lol Thanks Gasman !!
-
cheekybuddha replied to the thread Solved Select Into Query with varible issue.No one mentioned a form! :LOL: Time for some new glasses! :geek: (or Ctrl and + to increase the scale of your browser)
-
cheekybuddha replied to the thread Solved Format textbox with special case for "1".Interesting. How many iterations did you require to be able to see a noticeable time difference? Also, did you perform this in VBA? I...
-
cheekybuddha replied to the thread Solved Error on Creating a Query after changing LongTextField to Short Text.I think your SQL is wrong. Try instead: Public Sub UpdateFieldSizeToShort(tableName As String) With CurrentDb .Execute...
-
cheekybuddha replied to the thread Solved Exporting a form as text and then importing.?.It's very hard to miss you, @theBigGreenguy :ROFLMAO:
-
cheekybuddha reacted to Gasman's post in the thread Solved Exporting a form as text and then importing.? with Like.
That did the trick. Thank you. I was going about it the completely wrong way. :(
-
cheekybuddha replied to the thread Solved Exporting a form as text and then importing.?.Can we dial back a second @Gasman - how did you do the Save/Load as/from text? Like: Application.SaveAsText acForm, "frmName"...
-
cheekybuddha replied to the thread Solved Exporting a form as text and then importing.?.Is that a question?