Search results

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

Cross-post http://www.accessforums.net/programming/export-data-distinct-value-report-header-25332.html#post123107

I have this posted on one other forum so I'm not sure what the big deal is. Nobody has been able to help on the other forum so I thought I would try a different forum.

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

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

good point. I fixed that but still the same error. I'm going to try to re-create the database and keep my fingers crossed.

excel 2010

1. Master_Import currently has 4800 rows 2. It contains 5 columns 3. The spreadsheet has 500 rows 4. It contains 5 columns. 5. No headers 6. Doesn't work without range. It worked yesterday and nothing has changed. Same data. None of my modules are working and I get the same data for...

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

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

That is correct.

Thanks for the help! Really like your idea. However, I just found out that these 50 reps don't have access....ugh. Have you ever used the access email feature in access 2010 to collect data? I want each of their reps to be able to update each of their sales leads each month and add any new...

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

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

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

Thanks for the help!

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