Search results

Thanks for the link, but not quite the solution Hi, Thanks for the link, but it didn't quite do the trick. I had used this link before I wrote to try and fix this . I am guessing I've set this up "wrong", but I think I'll leave it for now. I am trying to add a new person in the Membership...

Hello, I've cobbled together some code to do the following: 1. Look for a member in the combo box 2. If not found, go to a data entry form and add new member 3. Manually close data entry form with a button 4. Return to main form 5. The new name is now in the combo box But when...

Hi, I have a membership data base and I need to change the member's status from member to lapsed if they have not sent in their annual dues. There are two tables - tblPeople and tblMembership - involved. Each person may have many membership records if they have been members for more than one...

Good Morning, > Does your MsgBox open saying that the name does not exist and do you want to add it? Yes, it does do this. And when I click on Yes. I get the error that the name does not exist on the list and to choose from the list. The first part of the article you recommended said...

stillneed some help Hello Jack, Thanks for your suggestion. I did try it - first without the code attached. As you can imagine we had a bit of trouble. Now I've found a spare minute to try the code. I am not all that familiar with doing code, but tried to follow the article that you...

Hi, I am trying to set up a datasheet as the first entry point to the data base. I want the users to do a find in the datasheet and if they find the person, doubleclick on the record and have it open a form - already created with multiple pages and tabs. I've tried setting up a macro on the...

Hello, I've puzzled with this for a few days and looked it up on the Web and in a couple of books and still can't find the solution. I have a People table and Event table. They are a M:M so I have a PeopleEvent table that I am able to put in attendance and donation amount for each person and...

Solution Found Hi, I actually got this to work several days ago but we were hit by malicious gremlins and lost our Internet service until today. I couldn't use the Long Date choice in the format until I went to the Control Panels and change Regional Settings to MMMM DD, YYYY to get rid of the...

not there yet Hi, I tried putting in the syntax you suggested instead of mine and it doesn't work. It just prints: Format(DateAdd("d",7,Date()),"mmmm d, yyyy") I tried adding a leading "=" and that didn't help either. I tried this both as a text box and as an unbound control. What part...

Hi, I have created letters in Access that are printed several days before they are due to be mailed. We need this lag time to get signatures and processing done. I want the date on the letters to be closer to the date we mail them then the date we printed them. I've come up with...

Thanks! Hi, Your suggestion worked just fine. Thank you very much for translating English into Access for me. If you ever need help with a knitting problem I'll be glad to reciprocate for your help! Susan

Hello, I've been working with this problem for the last two days and unable to come up with the solution myself. I am hoping it is very simple (and then I'll be very embarrassed to have bothered you!). I am converting a File Maker Pro database to Access. Everything is great except I need to...

thanks Hello, Switching from + to & solved my problem. I hadn't realized there was a difference between the two. I looked them up in a reference book and now it makes sense. My form combo box works like a charm now. Thank you. Susan

Hello, I'm trying to put a function in my query to concatenate a date field and text field. I looked high and low and can't seem to get this to work. Is it because concatenation is just for text fields? Obviously I am rather new at this, so I do apologize if this is too basic a question. I...