Recent content by jsic1210

I've done it before, I know it's simple. My issue is that I like to temporarily like to rename objects with an X before the name before officially deleting them. Since I'll be doing this with a lot of objects, I was just going to delete objects as I go. But I think I will take everyone's advice...

Any other suggestions? I'm going through a major restructure of my database and will be deleting a lot of objects. It helps me to rename them with an "X" in front first to make sure I don't need them before I finally delete them.

Hi, I'm trying to rename/delete a form. When I do either, the VBA project for that form doesn't delete. It's causing problems when I open my database. How does one go about deleting an object and its VBA project? Side note: Why does this website log me out so quickly?

Okay, thanks for the all the replies! I used Frothingslosh's advice, created a new database and pasted all the objects. I also created a way out as suggested (a password protected command that shows the ribbon). That seemed to have worked. Jeff

Because I disabled special keys, this doesn't work.

Hello, When saving my accdb as an accde, I disabled Special Access keys. I also have the toolbar hidden for the front end users. Normally, I leave the vba code open, so I can type "DoCmd.ShowToolbar 'Ribbon'" but forgot to do so this time. I can't figure out how (if there's a way) to get back...

More on the stepping through: it worked when I stepped through. Not sure where it's breaking. But even if I have the default setting to disabled, it ends up enabled. So it would seem somewhere in my code, there is [CODE]FeeIncreaseNotice.Enabled = True[\CODE] But again, I've stepped through...

I've already tried stepping through the code. It's definitely on the right object.

I considered this, because it's the only thing that makes sense. Originally, the control name was FeeNotice, but the control source was FeeIncreaseNotice. I thought that's what was causing the problem, so I changed the control name to FeeIncreaseNotice to match the control source. Still no luck.

It's in my On Current, PricePlan AfterUpdate, and Agreement AfterUpdate.

Okay, I am losing my mind here. I have a control that I want enabled/disabled based on other fields' values, both on Form_Current and [control]_AfterUpdate. In some instances, it works. It seems to be when the subform field Status = "Terminated" that it doesn't. My code: ' enable/disable fee...

Okay, figured it out. If anyone has a similar problem, make sure you set your default printer. So setting up my default printer (on the Control Panel: Devices and Printers) fixed it.

Hi, I'm trying to save a report to PDF. I have vba to do so, and until now, have never encountered a problem. Now when I try, the PDF is zoomed in and this causes the right and bottom of each page to be cut off. I tried clicking the fit to page button in Adobe, thinking it was just Adobe zoomed...

Hi, I'm trying to create a connection to SQL Server 2012 upon opening my FE Access DB. I put the code in my VBA upon loading my main form. My error message is "Invalid connection string attribute." My code is: Dim strCon As String Dim cn As ADODB.Connection ' create connection Set cn = New...

I recently updated to Office 2010. After editing an Access database (originally created in 2007), I saved it as an .accde for the users. However, my users all have 2007. They are unable to open the database. I suspect the problem might be in the VBA Reference Library. My references changed from...