Search results

  1. E

    Exporting Reports as .pdf with Macro

    I still can't figure this one out. In the attached file, I have a macro that loops through my data and creates a report by unique vendor #. I need to have the macro export each report and save it as a .pdf in my C drive. Anybody know how to do this? Tower_Scorecard3.xlsm This is the macro...
  2. E

    Export First Page of Report for each Unique Header

    ISSUE: Access module is exporting 3 identical pages for each vendor report. WHAT I WOULD LIKE: I would like each vendor report to be exported to pdf with only one page. There are 3 lines of data in the source data (MT_SC_S15_FINAL_TABLE) for each vendor and this is why the report is...
  3. E

    ODBC Call Failed (#208)

    I have created a pass-through query for a very simple query and I'm getting the following error. ODBC-Call Failed [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo_productMonthlyDetails'. (#208) I'm not sure as to why. My query is .... SELECT...
  4. E

    System Error &H80004005

    I have some vba code that was working fine yesterday. When I try to run it today, I am getting the following error "System Error &H80004005 (-2147467259). I've tried searching everywhere on how to fix it but nothing seems to work. The code I am running is below. Option Compare Database...
  5. E

    Qry to Add Data to Table

    I have a query that calculates FTE by month. Each month consists of two pay periods. The worked hours are summed for the two pay periods and divided by the total possible hours to calculate the FTE. The issue I am having is that some employees only have 1 pay period because they may have...
  6. E

    Avoid one Line on Next Page

    I have a report that shows employees by department. With each department, a new page is begun. Therefore, some departments will need 1 page while others will require 2. My problem is that I have a few departments that fit mostly on one page but one or two lines spill to the next page. is...
  7. E

    Mulitple User Issue

    I have a table in a database that I need approximately 50 people to update at any given time. I only want to give them access to update their own records not everybody elses. A rep ID will establish what records they own. They need to be able to modify and add new records. Does anybody have...
  8. E

    Update All Null Values to 0 in a Table

    I have a table that contains a list of employees and their working hours by month. At the end of each month a new column gets added. I would like to have a query update all the null values in the table without having to list each individual column name, since these will change. I can't do it...
  9. E

    Adding Fields that Will Exist in Future to a Report

    Hi there, I have a report that runs off a crosstab. The report displays a list of employees by cost centre with their fte count by month. e.g. Cost Centre 211 Employee Name Jan Feb Mar Apr May Jun Jul Jim Smith 1 1 0.5 1...
Back
Top Bottom