Search results

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.

Great call, GinaWhipp! Works like a charm! I don't really understand what the command is doing but as long as it works, I'm all good!:D

Where should I put the 'DoEvents' command? What does it do?

The more I wrestle with this, the less sense it makes. When the code is in "step through" mode from the beginning, there will be NO error message. To test this: go to the code module and put a 'pause' on the BLOCK 05 code line go to the launch form and click command button when you data...

Gina, I created a 'dummy' situation to provoke the 3211 error. I created a table to delete, attached a form to that table and created a code module with the Docmd.DeleteObject in it. To provoke the 3211 error, I opened the form (attached to the dummy table) and then ran the code. When I got...

Thanks again, Gina. I see you got the database and saw the problem. I think this is an Access problem. To demonstrate why I think this is the case, note the sequence of events: The code gets to the problem line Choose 'Debug' from the error message box Access takes you to the problem line...