Search results for query: *

I am trying to export a query to .xlsx and I have the file in mydocuments and I get cannot find file error. Do I need to not name the file and just allow the end-user to select the file name instead? Here is my code: Private Sub cmdExcel_Click() DoCmd.OutputTo acOutputQuery, "qryA"...

I have a code that adds the new record, and code that gets an attachment, but on clicking the add button, only the records are added and the attachment is not. Can someone help me? Option Compare Database Option Explicit Private Sub Add_Click() Dim yrID As Integer, mthid As Integer, measId...

I have an export code on my report that allows the end-user to select Excel or PDF. The Excel code never finds the file because users put the file anywhere they want in their machine and I want some code that will find that file on their machine. If the template does not actually exist, then...

So there is no way to just open an attachment and view in the screen and then close when done?

I have an unbound listbox that has a few items listed in it from a table. The user can use the filters in the header to narrow down what they want to see displayed within this listbox. Once they see what they want, if there is an attachment, I want them to have the ability to double-click on the...

I have a table called Attachments. This table is only housing a desktop reference and glossary guide. They are very small. My issue is I want to create 2 buttons. 1 that pulls up each from the table in the database so users can read them. I have them on SharePoint right now but they take a...

I have a report with an embedded pivot graph in the header. The report information is in the details with the labels in the header so all details are displayed correctly. My pivot graph does not update within the report. If I create a code that I will post below, both will update properly but...

The tables are normalized. The only fields they are allowed to update are: mbrst, mbrsr, mbrsc, q1update, q2update, q3update, q4update. I have multiple tables that link to a main one. The main table used to just be st_cd but I found that the entry form was not grabbing from the state table I...

I have a database with a form where end-users can go in and update only certain information in the database. Each record is distcint. I have many fields but will provide a few for an example: qid progid prognm stid st measid meas lobid...

My first piece of code ends with disconnect from odbc; quit; and it will write the data I selected from a server and write the final table into my personal libname then i have to take the sys_id from this table I created and saved to my libname and then do a new odbc to the server using the...