Search results

That works! Thank you so very much!

No I haven't messed with that form. The form I'm working on is frmProjectViewer

There's no events for any updates on the box or the form. I attached the database so you can see what's going on. I know it's a mess, I took it over to help a co-worker. All I did was make a better looking form and cleared the data she didn't need. **EDIT** Sorry I forgot to specify where...

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

Thank you so much for that!!

I do need to split it, but I don't know how to. Also, I'm trying to wait because I'm currently using my personal laptop to work on this, and the church I'm doing this for does not have a computer that is compatible with this version of Access (they're still on XP). They are working on getting...

It's working now. I finished the steps I could on that link you sent. By time I got done with those, the two buttons acted like they had no events set up, so I deleted them and re-added them and all works great now. Thank you so much for your help!

Ok, that makes sense, thank you for explaining that! I tried following the directions in that post, but my cmd keeps telling me the path could not be located. I've checked several times and my paths are correct. Not sure if it matters that the db I'm working on is saved on a flash...

I did google, all the ones I found were corruptions with a subform, I don't have a subform. **Edit** Also, a lot of the ones I read were corruption in VBA, I do use VBA on some forms, but not this form or any that have to do with this form and the records generated by it. I will check the...

That shouldn't matter. I only have one field that is required to be filled out, and that one is. I've opened the form on the first record and it gives the same error when I click either button. Also, I did add a test visitor to check your theory and even with every single box filled/checked...

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

So I went back to my form in my new database to check for your solution. As I was comparing the working login form against the one I'm working on I noticed the "source" had not been entered. This fixed the problem! Thank you so much!!

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

Thank you so much!!

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

That will help a lot once I get close to being done with this and will set it up for multiple users. Good news! I was able to find a copy from Sep! I had apparently copied the whole database so I could test something. Good thing I hadn't done much since then!! XD

Thanks. I'll have to look into splitting the db. I have no earthly idea what that is or how to do it. Thanks again for the advice and the confidence boost.

Oh ok, I got a little confuse because you said you saw queries and tables. I only see one table (nothing else) and it just has errors on it. Yea I tried that. There was nothing there. I'll just create the directory in it's own db and link the pictures like someone said in an earlier post...