Search results

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?

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

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

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

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

This is the second database where this has happened to me. I have code to print a report (with several sub-reports) to PDF. When it prints, only the first couple reports appear. The rest of the pages on the PDF are blank. If I try manually saving to PDF (Save As > PDF or XPS), I get the error...

Hello, I'm looking into storing query data in temp tables to help my reports run better. From what I'm reading, it seems best to have the temp tables in a separate db, and to break the links to avoid bloating of the FE database. I'm unsure how to do this with VBA, especially since my temp...

Hello, I have a report that I print to PDF through VBA (docmd.output to...). I have printed this report to PDF with no problems in the past. I changed some of the underlying queries and now I'm having issues with the PDF. The report itself looks fine in print preview. But the PDF shows errors...

I am building a database for a coworker. For one table, he'd like to extract data from different companies' financial reports, specifically a Schedule RC-B (schedule of securities). The format it comes in is PDF, but there are options to download XBRL, SDF and Taxonomy. My computer doesn't...

Hello, I'm trying to open a form with a subform from a separate form. I've never had any issue before, but all of the sudden, the subform doesn't seem to open immediately. I get the error Method 'Form' of object '_SubForm' failed. After that, it opens (subform and all), but some calculated text...

Hello, I have a combobox with a value list as the control source. I have a user who clicks the drop-down, but there are no options. Every other user is able to view these options, and this user has no problem with any other combobox with a value list. Has anyone seen this problem before...

Hello, I have a form that filters a report. Users have the option to filter the report based on text in a certain field (the field is ExceptionName). So the user can type in Index, and any record with Index in the ExceptionName field will appear. The field used to filter the report is a combobox...

Hello, I'm trying to set up an import of an Excel file. One field in Excel, "Sales Tax" has a lead space, so " Sales Tax" is its Excel name. Since I can't name a field in Access starting with a space, the only way I know to import properly is to manually remove the space from the Excel file...

Hello, I'm trying to create a query based on another query. However, my WHERE statement is causing a data type mismatch for a date. My code is: SELECT id, status, updated, [previous renewal] FROM qrynext renewal WHERE status = "active" and [previous renewal] = date() If I remove the " and...

Hello, I'm wondering if it's possible to set up an automatic Outlook mail merge with attachments from Access. We have several account managers, and each one receives a different version of the same report - filtered to his/her accounts. For now, I have set it up for the user to select the...

Hello, I'm trying to create a line chart based on monthly sales over the past year. But the graph doesn't match the crosstab query it's based on. So even though the query reads: month sales jun-13 $1000 jul-13 $2000 aug-13 $3000 ... jan-14 $4000 ... apr-14 $5000 may-14 $6000 But...

Hello, I have two tables, and I'm trying to create a crosstab query...I think. One table is Contracts, one is Contacts. Each contract could have multiple contacts, but they are numbered (1, 2, 3...etc.) based on importance. I want to create a query that keeps each contract on one line, and...

Hello, I'm trying to create a report that has several sub-reports. There are a few line graphs I need to include, but I am having problems creating one. Besides charts being nearly impossible to create in Access, any time I save the report and close out, it is missing. I cannot see it in the...