Search results

Idk why it's not working. I've tried using CDate([NextBirthday]) and then I applied the criteria Between Date() And DateAdd("d",7,Date()) to it and I get data mismatch error. I've even tried applying the criteria to the normal field. It runs fine if I don't have that criteria, but I need it...

I still need help with this...please?

Oh now I feel dumb! Thanks! (For the help, not for making me feel dumb.) :-)

Hello, So I'm trying to manipulate Access to create a Directory for my church. I'm trying to get a report to show the church staff, which I was able to do, but I was wondering, is it possible to get the records to show side by side instead of one on top of the other? I included a picture of...

Ok so I tried using the CDate in both queries. I set up the NextBirthday field just like normal, then I added a field and put CDate([NextBirthday]). It shows up in both queries, but when I apply the filter for this week: Between Date() And DateAdd("d",7,Date()) and then I get the data...

Couple questions while I try that fix. Why would adding a filter for member type affect the way everything is set up? Before I added the filter, it worked just fine. How would I be able to fix this without just making one field to list all the kids?

So how do I fix it? I'm kinda new... About the normalization, it looks messy here because this is only a snipit the actual database has A LOT more to it. I just included the basics

Ok that worked, for the most part. I have the filter on the first query (figured it would be easier down the road), but now when I try running the second query or open the report, I get "Data type mismatch in criteria expression." In the second query, the only criteria I have is the...

Hello, I have a birthday report that I do every week. This report is based on a birthday query which checks the member's next birthday (generated by a query "NextBdayQuery") and sorts them based on who their deacon is. This works fine until I tell the first query (or either query really) to...

As far as this question goes or for the database as a whole? As far as this question goes: I just want that text box in the top right corner of the Members Detail form to say "Possible Duplicate" or "There is already a member who matches this information", or something to let the user know...

Here ya go! I left some extra stuff because I couldn't remember what was used as a subform and whatnot. The form I'm working on is "Members Details" and the box I'd like the message to appear in is in the top right corner (can't see it unless your in design view, or there's text in the box)...

This is for my church, and we currently have some where around 700-800 people in the database (this includes moved, transferred, deceased, visitors, etc.) I was going to modify it to check if they are Jr., Sr., III, whatever based on a third box. I'm sorry to be difficult but I've only really...

Disregard this! I decided to go with a drop down menu (helps if the member is a III or IV or whatever). If someone would like to answer it in case someone else wants this, I will gladly check to see if the fix works.

Hello, I created a text box on a form to show the member's first and last name. Works great! I now want to add it to show if they are a Jr. or a Sr. I thought I knew enough to make it work, but now instead of the name it just shows "-1". Here's the expression in the box...(if possible I'd...

Ok I tried the Soundex function, but I need to modify it so that it just shows "Possible Duplicate" in the set box if the current record is a possible duplicate. Also, how do I ask it to check for the first name too? Would I add the function to the Form Query again, just with "FName", instead...

Thanks for that, and thanks for explaining it. Quick question. The expression I entered in the OP was entered into a box in the top corner of the form and would show "Possible Duplicate" if the "new" member looked like a duplicate, how do I set this up?

Yay that worked!! Thank you!! I knew it was something easy like that! X-D

Hello, I have a report that filters members by their type. On the form there is a field that shows the member's class they are assigned to, but currently it shows the class ID and I want it to show the actual class name. How do I make the report show the actual name instead of the class ID? I...

Hello, I have a form (MemberDetails) and I want it to check if the member I'm adding has already been added, or at least give me a warning that the member might be a duplicate. I have a FName field and LName field that I would like checked (together). I know it's possible because I've seen it...

Currently I just open it by double clicking the form, but once the database is all set up, it will be opened via form. **EDIT** I just tried to recreate the problem (close everything, take out the flash drive, reinsert flash drive, and reopen everything), and I didn't get the error. So it's...