Search results

So I have searched through the forums and tried numerous things to fix this code, but the line I have bolded below continues to be highlighted yellow and I keep getting the Runtime Error 3144. Any suggestions on what is wrong with the code would be greatly appreciated! Thanks in advance...

I was able to figure it out. Thanks anyway.

Good afternoon, I've been searching around and haven't found the exact answer to help me out with my problem. I have a query that has multiple IDs and different information in numerous fields. For example: ID Field1 Field2 Field3 1 x 1 m 1...

Unfortunately, I can't make that type of table. The database has already been created and those tables are tied with an online registration. I'm trying to fix some of the errors made my the developers of this database. Any suggestions on how I can create this report when I can't recreate the...

I had to create queries from the Charges and Payments tables so that I could sum the amounts as each customer will have multiple charges and payments. I just need a sum of each and an overall balance for the report. This is what I currently have which isn't working. I only have the...

I have two queries: 1. a sum of payments by individuals 2. a sum of charges of individuals. I want to combine these queries to create a report that shows the sums for each person of the charges and payments and calculate the balance. However, it is only showing me those individuals that have...

Thanks. I figured I would have to start from scratch, I didn't create the database, but I'm trying to repair it. Hopefully I'll be able to fix it so that it works for what we need!

Hopefully this will give you a better idea of why it needs to be done in this way: We have campers, who each have an CamperID number, each camper can sign up for multiple sessions of camp, thus a separate charge (or ChargeID) is assigned for each session as sessions may have different costs...

Hi plog - I understand what you are saying about the relationships. As far as the payments, they have to be applied to specific charges as each charge is specific to a specific week and each payment is specific to a specific week, thus a specific charge, as well.

plog, I whittled it down, I just did a compact and repair and it decreased the size for me further. Hopefully this will work now.

Hopefully someone will be able to see something that I'm not after two days of trying to solve this problem. I have a shell of my database in the below link for reference. I am trying to create a query for a report that will allow me to track charges and payments per client. Each charge has a...

Thank you for the assistance! Worked perfectly!

I need to build an expression that not only filters out the 9 in a column, but also the number 14. How do I build this expression to make it work for both 9 and 14. Currently it works just for 9. How do I make it work both numbers? RegularPayment...

I have been fighting with this code all day with numerous error messages and not fix. I find a lot of previous questions, but non that really help me. I have a Navigation Form and I have a subform with a subform in it. The code for the control button to add a photo is below. The latest...

I tried the requery and that didn't work. The code below was an attempt from all the searching I did to try and find an answer. It wouldn't be an issue for me to leave it as it is, however the end users of this database need it as user friendly as possible because they are NOT tech savy...

I have a unbound object in a subform call imgPicture. I want the user to be able to click a command button to choose a picture to change the picture in imgPicture. In the code below everything is working except the immediate change to the picture. For the picture to update I either need to...

Thank you! It worked great. I appreciate all of your help on this!

Hi JHB, OK, I'm going to admit I'm being clueless right now. Do I put the entire SQL-String in the query and do I put it in the criteria under the ReportID? I'm trying to figure out where to put the string to make it work! Thanks!

Yes that is exactly what I need! Now how did you do that? Thanks!

JHB, The attached file is some samples of the tables and queries I have in place. I need to find a way to pull the max ReportID per each client who has a completed pre and/or post survey specific to that ReportID. There will only be one active ReportID per client at any given time. Not all...