Search results

I am using the following event code to open a database from another. Everything works fine but, I would like add a mxgbox letting the user know the database does not exists and to contact me for assistance. Any ideas? Private Sub cmdOpenTime_Click() Dim accapp As Access.Application Set...

I believe separating the entire overtime reporting process is the best way to go. Thank you again!

I have a subform which users log their daily working hours (Mon - Fri) for 2 weeks. The subform is limiting the number of records to 10 or less. I would like to begin including the weekend in the form but don't want to include them as part of the 10. Any ideas? :banghead: Here is my code which...

The report begins to Output fine to the shared folder than I get an "Run-time weeor '2501' The outputTo action was cancelled. Here is the code I am using: sFPath = "\\mo7400svr01\cw_database\PILOT\Data_Reports\EnergyStudy\EnergyReports\Campus Reports\Campus Energy Summary" & " " &...

I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an “On Click” event procedure?

I am using the “period ending date” on a utility invoice as the factor to determine the month, quarter and year the period usage (kWh) falls under. But, when a period ending date is for example equal or less than the 15th day of each month; I want to consider the energy usage to be for the...

CJ_London, I solved the problem after I posted my thread last night “long day”. For this piece we just need to total the kWh. I need to validate the data but, it seems to be working. Thank you again for your quick response.

Is it possible to capture the sum of [Total kWh] and [Total Amount] for a PY and CY period for each location without the prorated factor?

CJ_London, We need to compare the [Total kWh] and [Total Amount] instead of the [Billing kW] and [Delivery Amount]. Therefore, I am using the qryPortfolioEnergyDetail query to capture the data. I changed the QPY and QCY expressions accordingly. But, when I run the QCYPY query the CY looks good...

A few little adjustments in our data and we are good to go. Thank you for all your help.

My first thought was to create two separate queries; the 1st would capture the data for the current year i.e. “2013”. The 2nd query would capture the same data for the previous year “2012”. Then, create a 3rd query to join the two tables together. Is this possible?

Thank you for the quick response. · Yes. I do want to use the period start/ending dates to divine the reporting period. · In this case the utilities start/end dates are the “period start/end dates”. A number of locations are new to the portfolio in 2013. I assumed any location with no billing...

Sorry. Let me start over. I have a table used to record electricity usages each month when the energy invoices are paid. I have attached a sample database with a copy of the actual table, and a simple query that calculates the various total usages and costs. I would like to create a report...

I have a table which is used to record electric billing period dates, total kWh and costs for a list of locations each month. I would like to compare the quarter total kWh and costs for this year "2013" against same quarter last year "2012". I have created two queries, the 1st is capturing data...

I have a simple query between two tables joined together by common fields. In my first table (Table 1 - tblLocations) I have information about a building i.e. Location Code, address and total sqft. . In my second table (Table 2 - tblAllocatedSpace), this contains details (Location Code, Room ID...

a.sharma, Thank you again for your test sample database. I can't tell you how much time you have saved me. I have been able to use your scanning codes as part of my form request. Everything I need it to do work great. However, currently the folders where scanned images and PDF’s are...

I am running Access 2007 - On a form I have a text field which contains the path "strFilePath" to where my associated PDF file is located (stored in a shared network drive). I have added Adobe PDF Reader Activex controls “AcroPDF6” to my form. I would like the PDF controller to link and display...

The users would scan documents to produce a pdf/image files.

:banghead: Hello everyone, I need your help. I have been asked to create a database very quickly for a small group that needs to scan multiple pages into an Access 2007 form. They they would like all scanned documents to be converted to PDF and stored on a shared network folder which can be...

A Sharman, Thank you for the test database. I am finally back on this project. I receive a compatibility warning between Access 2010 and 2007 when I open your test database. Would it be possible for you to save a copy compatible with Access 2007? When I try to create a new Access 2007 database...