Search results

Yes, commenting both lines of code out still fails (even after closing the form). Also, I don't know why I didn't think to test this earlier, but I just created a brand new form based on a small table and the same code didn't block me from publishing, so it does seem like the form's corrupted...

Hi Pat, Not sure I understand what you mean. Are you saying I was unable to publish because I had a form with no vba code in the project? Because it was actually a specific line of code that seemed to be causing the issue: Private Sub Form_Open(Cancel As Integer) CommandBars("Status...

Figured it out. So apparently, I have to leave the form in design mode when publishing. What I'd been doing (by habit, I suppose?) was to write the code, compile, go back to form view, then publish. By skipping that second-to-last step, I was able to get my accde. Not sure if that's the way...

@jleach: No good, unfortunately. @Pat_Hartman: For some reason, when I try to copy everything over to the new form, it keeps telling me "method or data member not found" for controls that clearly exist and are correctly spelled. Will have to keep trying, but your method seems like it may be the...

Hi all, I'm working with Access 2010, 32-bit on 64-bit Windows 7. So I have an accdb file, which I'm trying to turn into an executable by going into File -> Save & Publish -> Make ACCDE -> Save As. Problem is, when I do that, I get a message saying: "The command or action 'MakeMDEFile' isn't...

Hi all, My name's Gene. My work with Access involves VBA programming with an adp, which is used as the front end for our SQL Server. I am based in the United States (Florida). Hope to give and receive lots of help! Best, Gene