Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mayhem11

    MS export, cannot find file

    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"...
  2. mayhem11

    My attachment code is not working correctly. I does not add the attachment.

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

    How to alter the code to find the file on users machine

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

    Listbox Double Click Event

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

    Listbox Double Click Event

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

    Point to attachment in table

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

    Embedded pivot graph not updating within report

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

    Problem and help needed with update form

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

    Problem and help needed with update form

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

    SAS code help

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

Part and Inventory Search

Back
Top