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?
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.
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...
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.
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...
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...
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
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
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...
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??
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...
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...
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...