Search results
-
S
After_Update not working after Add
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... -
S
Update Query problem
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... -
S
datasheet to form
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... -
S
total donations, then add variable
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... -
S
Change date format when using future dates
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... -
S
Copy from one field to another
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... -
S
Concatenating date field to text field
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...