Recent content by rchhvol

Thank you, Simon!! I had the Unbound Object Frame confused for the Image Control. I have looked at this for hours! Thank you so much! -Pam

I converted the .wmf file to .jpg and still get the same results; the file name instead of the image. -Pam

I recently upgraded from Access 2003 to 2007 and can't figure out how to display an image on a form. I keep getting the file name displayed instead of the picture. I click on the unbound object frame in design view, click on my form for placement, select Create From File, Browse to navigate to...

Thanks! This code works better for me. I'm intimidated by the VBA editor! -Pam

I was afraid it couldn't be done without vba. Thank you so much for your help!

I just copied the same data and changed the year to create test data. The year is irrelevant. Think of the months as Jan and Feb of any year if that makes it any more clear. My question is not about grouping levels but how to perform calculations between two (or more) different groups of...

Sorry for the confusion. The database holds dollars by day. The query will extract off specific months of data. I did not add the paraments for the selection process for simplicity purposes. The report will compare data for two months regardless of the year. The two months may or may not be...

Hi Trevor and thank you for lookikng at my request. I have attached the database. There are two months of data. I would like to be able to subtract the first month total from the second month total at the end of the report. Thank you for your time. -Pam

Hello all! I have a simple report that shows 2 months worth of data. The report groups by month with totals for each month. I need to subtract the total $$ for month 1 from the total $$ for month 2. Is it possible to perform this calculation without using VBA? Thank you in advance for your...

I have not tried importing to a new DB since the problem has happened in Excel as well but it's certainly something to try! Thank you for your suggestion.

Recently Access has starting dropping records. It will drop all the records entered at one particular time. The data will be there and then the next time I look, the data is gone. It doesn't happen all the time and seems to be random. This has also happened in Excel. I have tried the...

Where do you change the name of the calculated control? In the properties of the control on the report? I'm not quite following. Sorry!

No, I didn't change the name that was assigned by the wizard in the query.

I've read several posts about summing checkboxes as positive numbers but none of the solutions seem to work for what I am doing. I have a query that sums 4 different checkboxes, grouped by Year. This query sums Yes values correctly and displays negative numbers, as expected. nbrYear Group...

I have a form with customer information and a subform with customer detail. I scroll thru the customer info using the scroll keys at the bottom, entering detail for each customer. After about 3 or 4 customers, the detail fields stop accepting entry. I can tab thru the fields and click on the...