CJ_London's latest activity
-
CCJ_London replied to the thread DoCmd.TransferSpreadsheet no longer trims trailing spaces from field names after conversion to Office 365.other way is to specify the range without headers. So if headers are on row 1 and there are 4 columns A:D, specify the range as A2:D...
-
CCJ_London replied to the thread Help with Instr Function.Any reason you can't use? If strText Like "Überweisung:AT*DE*" or If strText Like "Überweisung:*AT*DE*" Some example data with the...
-
CCJ_London replied to the thread Passing forms from one subform to another....There are two techniques I use. One is simply to have two subform controls, one hidden or at least sized to zero width or height and...
-
CCJ_London replied to the thread What's your best/worst joke?.
-
-
CCJ_London replied to the thread What's your best/worst joke?.
-
-
CCJ_London replied to the thread Assessing Project Size.I have a client with a similar situation- a number of access apps written by an employee who has now retired. The apps are quite...
-
CCJ_London replied to the thread Search while typing Multi Field Search Form in Ms Access.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...
-
CI put my money on the index?
-
CCJ_London replied to the thread Win64 version crashing.So far as I am aware the call to the ‘address of’ needs to be in a class module. So your autoshutdown sub is in a class module (which...
-
CCJ_London replied to the thread Win64 version crashing.Tom is saying timerproc needs to be a sub in a standard module, not in a class module
-
CCJ_London replied to the thread Query slow on split database on network.This negates the use of indexing. Instead try Pend1Date<date()-14 and if pend1date in not indexed, index it
-
CCJ_London replied to the thread Drag and Drop interface is it possible.Short answer is yes - you would probably need to use the mouse down and up events. Also review the undocumented acchittest function to...
-
CCJ_London replied to the thread Text boxes - Grow and shrink.You can resize a text box but that will impact all rows in a continuous form. Alternative is to hit F2 I usually size a text box to...
-
CCJ_London replied to the thread sending email via MSaccess not working.What does ‘blocked’ mean? You get a message? Nothing happens? what is the code that is blocked?
-
CCJ_London replied to the thread Delete a record after inform user.Don’t allow them to select them in the first place - presume you are using a combo to select an item - so exclude them in the combo...
