Search results

  1. D

    Splitting text box text into sentences

    Just to test it myself, I created a blank database with just a table, a replace query, a simple report, and a form with a command button to pass the replace query to the report. Surprisingly, this is working fine with no truncation. So now I have to go back to my original database which has a...
  2. D

    Splitting text box text into sentences

    I'd really like to try to see if this code works but have no idea how or where to put it. The Form with the cmd button opens a report with the record based on a primary field. Do I put this code in the click event of the cmd button? The Open event of the report? Should it be a function in...
  3. D

    Splitting text box text into sentences

    Can't find a way of using Replace(AnyText, ".", "." & Chr(13) & Chr(10)) In combination with AnyText => Left(AnyText, 65535) To get around the truncation issue with calculated fields.
  4. D

    Parsing plain text box in report

    I have a simple text box in a report which can contain several sentences. It could look confusing bunched up altogether. Is there a way to parse the sentences with a line breaks at end each period?
  5. D

    Resizing the Main Access Window without repositioning it

    WOW - that's perfect!! I had just about given up on this one. Thank you so much for dedicating your time to this request. Of all the posts I've seen on the web asking for this functionality of wrapping the access window around the form, your code is the only one that actually works. I'm...
  6. D

    Resizing the Main Access Window without repositioning it

    Using tabbed documents display wouldn't work for me as there are multiple forms and sub-forms being displayed. And the request hadn't really shifted, I just tried using different examples in order to try to provide a better picture of what I was trying to do. But that obviously didn't work...
  7. D

    Resizing the Main Access Window without repositioning it

    Hi isladogs, There isn’t anything wrong with what you wrote in post #12. But that only gets me halfway. More importantly, I’m trying to wrap the access window around the form (not the other way around) to make it appear like a popup. Plus, there are quite a few web sites where users have asked...
  8. D

    Resizing the Main Access Window without repositioning it

    I suppose the answer to that question is esthetics - trying to make it look better. Using a button in this example was an attempt in simplifying my request. In any case and regardless of the reasons, the real question is, can it be done.
  9. D

    Resizing the Main Access Window without repositioning it

    That was an example. I'd like to press the button to resize without it moving.
  10. D

    Resizing the Main Access Window without repositioning it

    Yes I looked at the examples provided and found the one in post #7 to do just about everything that I want. But, it's not "exactly" what I'd like it to do. I also looked at your Control Application Interface, but I'm not using pop up forms. So rather than a screenshot, I made a simple...
  11. D

    Resizing the Main Access Window without repositioning it

    Yes - I'm actually using the SizeAccess() code in post #7 to resize the access window and it's working very well. But this code requires that the access window be set to some location (cx and cy). It can't be set to wherever the access window is currently located. I thought maybe of...
  12. D

    Resizing the Main Access Window without repositioning it

    What I'm trying to do is very well explained in all the post links in this thread regarding "Access Main Window Resize" and "Hiding access window faster". In fact govuser1 never received a response to the question on modifying the code to "...the access window size but allow the window to open...
  13. D

    Resizing the Main Access Window without repositioning it

    Hello Doc I'm trying to do exactly what the DoCmd.MoveSize for a form does, but for the Access Window. If you use DoCmd.MoveSize , , 800, 1000 The form will not reposition itself from the top LH corner but just change its size to 800 by 1000. So I'd like to be able to do that same thing to...
  14. D

    Resizing the Main Access Window without repositioning it

    There are a lot of examples of resizing the Main Access window using the Application object, Application.hWndAccessApp But I can not find a way to use this property without repositioning it. It would be great if it could be made to work like DoCmd.MoveSize for a form. Basically, I'm trying...
  15. D

    Error 31602 when using IMEX Data Tasks with isladogs frmManagingTasks Form

    Hello @isladogs, I couldn't get IMEX to work on that one file and then when it failed on another SAP import, I figured I had to find another way. So thinking outside the box, I went the other way and just imported all my forms, tables, modules, queries, etc into your IMEX database just to see...
  16. D

    Error 31602 when using IMEX Data Tasks with isladogs frmManagingTasks Form

    Hello ebs17 Please understand that the discrepancy in this thread are ONLY related to the task in the IMEX form. There are no other issues importing the files once the path is set.
  17. D

    Error 31602 when using IMEX Data Tasks with isladogs frmManagingTasks Form

    Hello @isladogs. Yes I saw your post 12 which is why I uploaded just the one spreadsheet (export1.xlsx) for others to try. Forget about the first spreadsheet (export.xlsx) with the name errors. I am able to get (export1.xlsx) to fail by itself using the IMEX form on two separate computers...
  18. D

    Error 31602 when using IMEX Data Tasks with isladogs frmManagingTasks Form

    Just to alleviate the possibility of the problem being a computer issue, I copied the database onto my home computer for testing. My work computer uses Office 365 while my home computer has a older standalone version of Office 2016. However I'm still getting the error 31602 in line 20 when...
  19. D

    Error 31602 when using IMEX Data Tasks with isladogs frmManagingTasks Form

    Hello @isladogs. Yes the spreadsheets are totally different but that's because they are going to two different tables. And there is a common field [order] between the two that links them. My database has two separate import DoCmd.RunSavedImportExport buttons. One for each and both work...
  20. D

    Error 31602 when using IMEX Data Tasks with isladogs frmManagingTasks Form

    Hello @isladogs. I couldn't find anything that would make one spreadsheet work and the other fail. I've even tried to just recreate a blank database with only one spreadsheet but that didn't help either. So I've sent you a couple of sanitized SAP downloads to your email for testing. The one...
Back
Top Bottom