Page 2 of 2 FirstFirst 12
Results 16 to 27 of 27
  1. #16
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954

    Agree with Bob. Please upload a copy of your database to the forum.
    Remove any irrelevant items and remove/replace any confidential data
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  2. #17
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    i cant upload this file

    its 25 mb after ziping

    can i please send it to some email ?

  3. #18
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    i cant upload the file

    is it possible to send it to some email?

    the file is 25 MB
    AFTER ZIPPING

    POSSIBLE?

  4. #19
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    try compacting before zipping - and have you removed irrelevant data before compacting?

  5. #20
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by nahum abramovich View Post
    i cant upload this file

    its 25 mb after ziping

    can i please send it to some email ?
    Did you do a Compact and Repair before zipping it.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #21
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    yessss i did

  7. #22
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by nahum abramovich View Post
    yessss i did
    Then you will need to remove irrelevant data and other objects (like tables,queries, forms and reports that are not required to illustrate the problem) before compacting.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  8. #23
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62

    problem with running 5 records inside one text box

    hope you understand what is the problem thank you
    Attached Files Attached Files

  9. #24
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You have a large number of buttons with embedded macros.
    The error message is I think related to one of them as the timer event isn't looping through the records at all
    Due to the language issue, I'm unable to advise what exactly is causing the problem

    I suggest you temporarily disable all the buttons so the macros don't run. Does the timer event work in that case?
    If it then works, re-enable your buttons one at a time and re-test. This will hopefully allow you to identify & fix your issue.

    Alternatively, move your textbox and timer code to a separate form and use it as a subform of your main form.
    I've not tested that but I think it should work without error.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #25
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I agree with Colin, it is either one or more of the macros or one or more of your control sources which make extensive use of domain functions. However I was able to get it to work by creating a frmRemarks which just displays the remark (you have a field name the same as the table name which adds to the confusion - so change one or the other) include the ontimer code and save.

    Then on your main form unbind the form from your Remarks table (i.e. no recordsource) and delete the text box. In it's place, drag your new remark form onto the main form. Ensure the subform linkchild and linkmaster properties are unpopulated. That works for me.

    I would send the file back but due to unrecognised fonts etc, I cannot save the form

    Edit - see Colin has already suggested using a subform - but I can confirm it works

  11. #26
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Here is an amended version using a subform
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #27
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    thank you all. Really appreciate it!


    I will probably move forward with the floating form.

    thanks again

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-24-2018, 07:58 AM
  2. Formula and Text inside a Text box
    By trident in forum Forms
    Replies: 1
    Last Post: 04-18-2015, 02:38 AM
  3. Can I use a DLOOKUP inside of a text box?
    By Access_Novice in forum Forms
    Replies: 5
    Last Post: 01-26-2014, 03:56 PM
  4. How to vertically align text inside a text box ?
    By alexcalgary in forum Forms
    Replies: 2
    Last Post: 10-06-2010, 08:44 AM
  5. Replies: 2
    Last Post: 09-30-2009, 09:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums