Recent content by WKRJ

Thank You Very Much! WKRJ

Hi. I have a ton of scanned pictures on my computer. I was thinking I would build an Access database where I could create 3 or 4 indexed fields to fill in as time goes by. I would like to page thru the pictures and add the index fields a few a day till I'm done. The problem is that I don't...

How do you compare one record to the previous record? I have a query that shows items sold. It is sorted by day with today on top. I would like to create a column that has a 'thumb up' or 'thumb down" if todays was a better day than yesterday. Thank you! WKRJ

Thank You! your code is perfect! Talking about attention to detail, one misplaced " = trouble. Thanks Again

Hi again. that's just it, it does not work. I have read and looked and read and I don't see what I'm doing wrong. If you would, could you take another look Thank You Again WKRJ

Thank you for the response. That's how I'm thinking. I have a directory with 3 images in it, 1.jpg, 2.jpg and 3.jpg. I have a table with an auto number named 'PhotoId' as the PK and a text field named 'Image'. On my form, I have an image box with the control source set to 'Image'. In the...

I have been tasked to scan family pictures in such a way so they are available to older family members to identify people younger family members don’t know. My solution is to scan each photo, name them 1.jpg, 2.jpg…. about 4000 images. Store them in a directory (H:Family). I then want to...

I got it to work, finally but now I have another question. Can I have multiple control sources on one form. I have 2 queries and would like to display the information. Also, is there a site online that list all the commands available within access? Thank You wkrj

Good Idea! Thanks! I hope this is the last question about this. I tried to use =dsum("price", "qryTotaltest") as the control source on a form but get #error. I created a 3rd query using the qryTotaltest query but get the same error. I looked up dsum and I think I'm using it correctly but I...

I have a table with 2 columns named ‘TodaysDate’ and ‘Amount’. I would like to get the average amount for the past 5 workdays and compare that to the average amount for the 5 workday prior to that, so I’m always using the past 10 records. I don’t have a clue as to where to start and would...

Hello My name is William. I live in Las Vegas and I have no programming experience but know the basics of Access. I have been tasked to create a db that is above my pay grade but that how we get to the next pay grade! I will have a lot of questions, so thanks in advance to the people...