Search results

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

What really doesn't make sense is that if I make a copy of the source table, calling it tblNotices1 (and set tbl = "tblNotices1"), nothing deletes. Is it possibly because tblNotices is linked from another database? This is a front end database, so all the tables are.

Actually, I copied the table into a new database, and it worked fine. I'm not sure why that would happen. I will have to look a little more into it.

Hello, I'm trying to copy the structure of a table to make a temp table. I'm using CopyObject (which also copies the data). So when I delete the data from the temp table, it also deletes data from the source table. Is the data linked? It should just be deleted from the temp table. Below is the...

It's actually not exporting thousands of records to the report. I just meant the queries that are the datasources have that many records. The reports at most output 25 or 30 records. Some of the subreports have that many records (could that be the problem?), but the detail is hidden. I haven't...

Yes, some have 2 or 3 outer joins (max maybe 5). Most derive from 2 tables. One table has about 3,500 records, the other has about 24,000 records. The queries are returning 1,000-3,500 and a few to 24,000 records, respectively. My queries need to be complex to display the report.