Search results

Thank you!

I think it might be easier to just use two combo boxes, not sure why I didn't think of that. XD Thanks!

It's working! Thank you!

**Edit** I too cannot see the picture, so I'm hopping that when you said "cobbler" you meant the shoe guy. **Edit** So I got some of the previous pictures to show, last one I can see is a broken shoe. I am on the right track! Sorry for all the edits :p

Hello, I have a SS attendance form that is based on a table. The members are added to the table via a query that looks for those who are on the roster (field: On_Roll = True). The query generates every time the form is opened, and the form only shows the records that have an empty date field...

Hello, I have a drop down box with two columns (FirstName, LastName) and currently I start typing in it and the drop down scrolls down the to first name that matches (only looking at the first name). What I would like is to be able to start typing a name and it looks at both the first name...

SELECT SSAttendance.StudentFName, SSAttendance.StudentLName, SSAttendance.AssignedClass, SSAttendance.InAttendance, SSAttendance.DateofAttendance, SSAttendance.ClassAttended, SSClass.SSClass, SSClass.SSTeacher, SSClass.SSAbrev FROM SSClass INNER JOIN SSAttendance ON SSClass.ClassID =...

The source for both the form and the report are "queried" from two tables (one to pull up the date, name and attended class; the other to pull up the name of the class and the teacher). As for the filters, they are just the date and class.

Hello, I have a form that filters my records and then sends everything over to a report (which is basically the form, but just shows the filtered records). How do I count how many records where pulled up on the report? I know it's possible if you base the report on a query, but that's not the...

Darn, I was really hoping for a way to manipulate it to work. I really think this looks nicer than the one date/person/record. Cest La Vie, thanks for the help. :-)

Hello, I have a report based on my church's Sunday School attendance. I am trying to set it up so we can filter by a specific date, but the way I have it set up is so that each Sunday is on the same line for each person. I.E. John Smith 8/2/2015 AD2 8/9/2015 AD2 (etc) Is it possible to make...

Hello, sorry for the late response, my schedule was changed up a bit. I did not add the code as a module, I added it as a code through the Before Update event on the form. I have noticed that if I make any changes to any records, the "Possible Duplicate" text shows in the box and stays there...

Thank you for your opinion/advice, I truly appreciate it! As I've said is some of my other posts, I'm still new to this. In school they cover tables, forms, reports, and queries, but it's all basic stuff. No relationships or macros/expressions/code. The only other thing they cover is how to...

That fixed it! Thank you! I'm still kind of new to all this, I learned the very basics in high school and again in college, but to do a real database like I'm doing now is more than we learn in school. I've been working on this since the beginning of Jan, and this is my second do-over. (The...

The save is automatic, I didn't set that up, it must be a default with the access I'm using and must have stuck with it when I uploaded. The only thing I have set up is when you click a name in the go to field, next record button, new member button, and the close button. Those will tell the db...

Ok, figured that part out ("Not Null" is the correct way). Now my report isn't working. It shows each member several times. Gonna try to re-create the report and see if that doesn't work. Feel free to post any possible solutions. **EDIT** I tried recreating the report, same thing. I looked...

Ok, so I don't know VBA and I tried just putting that in, but it won't let me save. I tried telling it if I click the cancel button, then to make Cancel = True, but that didn't work either (just told CancelButtonPressed = True is not supported).

I figured it out! When it pulls the birthday from the member table, I told it the criteria is "Is Not Null" apparently that is not the correct way to write that, because it still pulled a few null birthdays and that's what's causing the problem. Can someone tell me the correct way to write...

Hello, I need help canceling a new record. I have a form to add a new member and I'm currently getting help to determine if the new member being added is a duplicate or not. I have a cancel button and I want to be able to hit the cancel button and the form is wiped clean and then directed to...

I'm so sorry, I forgot to explain how it all works and point out where I am at. Ok so looking at the form, the top number is their EnvNum (or the key number for their record). Then it shows the name they go by. The "Go to" allows the user to look up a name and open their record. The next...