Search results

Hello, I have a form with two combo boxes, one for State and one for County. I currently have the county combo using a query to filter only the counties in the selected state. My problem is that I cannot select which county I want, it automatically goes to the one at the top of the list, even...

Hello, I have a form that I use to enter visitors and normally it works great, but today when I hit my button to enter a new visitor or to close the form, I get an error "Return without GoSub". I have googled this, but everyone else with this problem has a subform in their form, which is not...

So now that I've got my login form working and what not, I want to be able to disable shortcut menus (when you right click on the title of the form/table/etc and the little menu drops down). I've got the following lines to disable the Ribbon, and the Navigation Pane. DoCmd.ShowToolbar "Ribbon"...

Hello, I watched a series of youtube videos last year on making a login system for my db that I was working on at the time. I wanted to add it to the one I'm working on now, so I copied everything over (forms, tables, code, etc) and made a couple minor mods (renamed a field, removed a table...

Hello, I have a letter setup in Word that I use for mail merge via my VisitorTable. Currently I have to close my db and open up the word file to merge and print the letters. I'm wondering if there's a way I can set up a button to run the mail merge and print the letters. I'm using the newest...

Hello, I have a form that I use to track our Sunday School Attendance. I have it set up with two "temp" fields in my main table (Members), then use an append query to save all the data (date, class, name, present, & on roster) in another table (SSAttendance). I'm wondering if there's a way...

I've been working from scratch on a database for my church. For the last couple weeks I've been working on a directory via a series of subreports (just so it will all print together. I was working on some collages for the events that have happened this year when all of a sudden my laptop told...

Hello, So I have a report that shows our staff w/ their pictures. I have it sorted as well (1- Pastor, 2- Youth Minister, etc). Is it possible to show only the title (i.e. "Pastor", "Youth Minister") and still keep the number so it can sort properly? Or do I need to create a table for staff...

Hello, I created a directory via a series of subreports. On the first page is the logo, which I cannot for the life of me get to show in print preview or when I print; but all the pictures in the subreports show just fine and print as well. How can I get this to show/print with out creating a...

Hello, I have a members detail form that shows all our information for a member of our church. In one field I have it update (only when the form opens) to show the member's current age. Is it possible to make it continue to update, until the pass away, then stop at the age they passed away...

Hello, I have a form that we can select the family ID, a member of the family, set the month, year and the actual tithing date, how much they gave, and what category they gave in. (The month and year are just for now till I figure out/remember how to pull specific data, ie month/year, from the...

Hello, A created a directory via a series of report. The directory shows the member's phone number & birthday, but some members are requesting that the year is not shown. How can I hide the year just for this report?

Hello, I have a form with some tabs and one is for tithing. On the tithing tab I have the member's tithing history set up (via subform), but I want to be able to view the member's total giving for a specific month and year. I can select what month/year via a drop down and then the system will...

Hello, I'm working on a database for my church (they're currently using Alpha 6 and want a more modern db.) I'm trying to figure out the best way to set up the tithing portion. It's suppose to track what was given to each area, who gave what & where, the collective amount of checks/each...

Hello, I've got a attendance roster that we generate at the beginning of each month, and I filter by class. My pastor wants to display those who have a birthday during the current month. How would I show the birthday ONLY if it occurs during the current month? I tried making it a criteria in...

Hello, I have a report that I will print and use as a Sunday School attendance sheet. Currently the roster is generated and filtered based on a tempvars. I was wondering if it's possible (and how) to set the title based on the same tempvars. Ex: TempVars = 1 Title = Steve's Adult One Class...

Hello, I have a member detail form and just starting today, it's been giving me an error (picture attached). I've checked to make sure both tables are assigning a primary key. I don't really know why I'm getting this nor can I understand what it's trying to tell me. This happens when I try to...

Hello, I have a form for our church members and each member is assigned to a family ID. I had already put in most of the family ID's and I have a button to add a new family, but after I add the new family the drop down list doesn't show to new family, not unless I close the form and reopen it...

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...