Recent content by rjp99

Thanks isladogs! I'll give it a try tomorrow

'This looks like a single form....' I think the "this" you were referring to was the object (picture) I posted; if so, its one tables in the database; not a form. That said, when I create a form using the 'Form' button, the problematic record selector formatting 'flows through' to the form...

I had not considered this option isladogs... it looks promising but I have to admit, I have no idea of how to do this. Can you direct me to a website (or some other reference material) recommendation I can read to figure out how to do this?

Most definitely not, Isaac! From the end-user's perspective, the problem is the record bar problem 'flows through' to forms I've built (to allow access to the underlying data tables); at least when I use the 'Forms' button to create the form...

Thanks Pat!

Thanks Pat! I think this is some sort of Windows/Office issue because whenever the record navigation bar is visible (tables, query and forms), it's presented like this. I was hoping there was some sort of setting that could be adjusted but I didn't see anything so I wasn't hopeful. By the way...

Thanks Isaac! I just tried turning off totals and it had no impact....

Thanks Pat! I think this is some sort of Windows/Office issue because whenever the record navigation bar is visible (tables, query and forms), it's presented like this. I was hoping there was some sort of setting that could be adjusted but I didn't see anything so I wasn't hopeful. By the way...

The record information toolbar on my copy of Access is obscured (see attached screen shot). Does anyone know if there is some sort of global setting I can adjust to fix these issues? Thanks in advance for help.

I put cboAFGND.requery statement in cboPC2_afterupdate sub and in cboAFGND_afterupdate sub and got an 'Object Required' error (424) . Is there anything else I need to do when I use this statement.

I have three combo boxes PC2, AGFND and PCA. · PC2 drop down list is independent; · AGFND drop down list depends on the user's PC2 selection and · PCA drop down list depends on the user's PC2 and AGFND I have selection queries as row sources behind AGFND and PCA. The query behind...

Thank you, The Doc Man!! I was totally overlooking the invisible object. Moving it did the trick.

I'm trying to change the height of form using code and nothing I've tried works. Rather than have you read a lot of words to get an understanding of my problem, please open the attached dB and: · open the '01_EventDates_MF' form · click the 'Go To Time Period Entry' button (at the...

Hi, When I try to use the TransferSpreadsheet command, I get the following runtime error (3051): "Microsoft Access database engine cannot open or write to “XXXX”. It is already open or exclusively used by another or you need permission to view or write its data." I've used this in...

Thanks for all your help, GinaWhipp! Would've taken me a month of Sundays to figure it out without your help.