Search results

  1. F

    Form has no active record on opening

    I had those locked and disabled on purpose, I wanted them to be "Read-Only" Am I not able to have locked and disabled controls on my form?
  2. F

    Form has no active record on opening

    Here is a cut-down version of my DB with only the Problem Form/tables/query included
  3. F

    Form has no active record on opening

    I applied Minty's tips, and Isladog's tips. They were both great ideas. And following the steps in IslaDogs's tips found quite a few glitches in my code. So, overall it was good. However, those steps have not fixed the original problem. Any other thoughts?
  4. F

    Form has no active record on opening

    Here are my form settings. Also, Once the form is opened, if I manually select a record from the splitform datasheet, the main form goes to that record, and everything works fine after that.
  5. F

    Form has no active record on opening

    I have a split form that recently developed a problem. when the form first opens, the active record is record #0 , I have no record 0 in my database. However, on the displayed form it shows the data for my first real record. and in the split (datasheet) portion of the split it shows all...
  6. F

    Form button to add new row to two tables

    I agree with theDBguy. I would think that linking the 2 tables by using a Foreign Key (a field which holds the reference to a row in another table) in one of the tables would be safer, and easier.
  7. F

    Command buttons jump sideways on hover

    I found the source of the problem. bad VBA Programming... There is a Public sub that gets called on the "Form_Current" Event of some of the forms. It is used to set the Read/Write privileges based on user level. Once I commented out the lines with NavigationButtons and RecordSelectors, the...
  8. F

    Command buttons jump sideways on hover

    I emailed it to you.
  9. F

    Command buttons jump sideways on hover

    Yes, I did compact both parts before zipping. Still lots of tables, forms, and queries though.
  10. F

    Command buttons jump sideways on hover

    Update... When I stripped the DB down to just 1 table, 1 form, and 1 query, the problem went away.... So I went to my non-stripped DB and opened the form directly (rather than programmatically). The problem did not occur. I now believe that the problem may be caused by my login form. I still...
  11. F

    Command buttons jump sideways on hover

    It appears that my DB is too large to post. Even with almost all of the data stripped. Backend is 8 MB, frontend is 4MB Maybe I'll strip it even further and post just one of the forms that is giving issues
  12. F

    Command buttons jump sideways on hover

    Here is a screenshot of what the buttons look like after they have been hovered over. (the 2 in the Header, not the Footer) I will upload a sample DB soon. Thanks
  13. F

    Command buttons jump sideways on hover

    theDBguy, Thanks for the pointers. Unfortunately that did not help.:banghead:
  14. F

    Command buttons jump sideways on hover

    Yes the DB originated in 2003, but the most recent form that is demonstrating the issue was made in Access 2016
  15. F

    Command buttons jump sideways on hover

    Hi, I am having a problem with 2 of my forms. I have made many forms in my DB but only 2 have this issue. They are both POPUP and CONTINUOUS. The problem is, when I hover over a button anywhere on the header or footer, the button appears to "jump" sideways about 1/4". It also leaves a...
  16. F

    SendObject Report via acFormatPDF anomaly.

    That suggestion worked. Thank-you. Are you able to tell me why it worked? what mechanism does Office use to form its PDF's.? Obviously must have something to do with the printer??
  17. F

    SendObject Report via acFormatPDF anomaly.

    Hi, I have a split database where many users use a local copy of the front-end. MS Access 2016. All users using the system are using Citrix virtual desktops on a corporate network. One of my users is experiencing a problem when emailing a report as a PDF in Outlook. Except for this one...
  18. F

    Question Has anyone else had all of their fonts spontaneously change?

    Is there a way to reduce text size of all text on a form or report, by the same amount, all at once
  19. F

    Question Has anyone else had all of their fonts spontaneously change?

    The font for all my forms and reports have somehow changed to a different font. Text is now too large to fit into it's boxes and, in some cases, I have no room to accommodate the larger font. It may be connected to an upgrade from Office 2013 to Office 365. Has anybody else experienced this...
  20. F

    Open a Form from VBA with only certain records showing

    Ah...yes.... I forgot that the "where" of the openform cmd uses the regular filter. It turns out that I was using code to clear the filter on the form_open event. Thanks for jogging my memory. :) I used the OpenArgs and an "If" statement to bypass the code that clears the filter. as...
Top Bottom