Recent content by CJ_London

  1. C

    Help with Instr Function

    if you use sql to connect to the text file (or use transfertext to link to the file) you can do all that in a single query (or one per table you are appending to) using a few functions such has the one we have been discussing and joining to other tables as lookups (such as joining on the...
  2. C

    Help with Instr Function

    are these all the options for what you want returned? It looks like a similar scenario I have with with my accounting apps. To handle this I simply have a table containing the required (in this case) supplier names then using a simple query such as SELECT [Enter SupName], trandetail FROM...
  3. C

    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 This will give default headers of F1, F2, F3 and F4
  4. C

    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 outcome required would help for other like operators, see this link...
  5. C

    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 when required it is resized and populated with the second form - whether you have them side by side or one above the other is up to you. Depends on how much...
  6. C

    What's your best/worst joke?

  7. C

    What's your best/worst joke?

  8. C

    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 complex, interacting with Word, Excel, Powerpoint and Outlook together with some external apps utilising Rest API's. The apps are reasonably well constructed although...
  9. C

    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 large datasets - but a simplified version might be Me.frmlistprod.Form.Filter = "[ItemCode] & [ItemDescription] & [PPU] & [City] Like '*" & Me.txtItemCode.Text...
  10. C

    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 might be a form module) whilst TimerProc would be in a standard module
  11. C

    Win64 version crashing

    Tom is saying timerproc needs to be a sub in a standard module, not in a class module
  12. C

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

    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 determine the control below the cursor in the mouse up event. From this you can determine what action you need to take to update the records
  14. C

    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 display (up to) 3 rows. If text is longer then you also have the scrollbar
  15. C

    sending email via MSaccess not working

    What does ‘blocked’ mean? You get a message? Nothing happens? what is the code that is blocked?
See more
Top Bottom