Only One Button code works on this form - troubleshoot help requested

[Amyfb]

I've been over this numerous times, finding and fixing typos ( - instead of = as ex) . At this point, I'm unable to find any thing else that is causing the code for this form to fail.

The Close button works. so does setting the focus on the last name field. otherwise it's dead in the water.

The code comes from a book i'm studying. I'm accomplished the earlier examples of sample code for different parts of this package and now it's time to put all those little bits together.



No doubt there are eagle eyes in this group who will see the problem before I've come back with a fresh cup of coffee.

Thanks in advance for taking a look and tossing ideas over to me. I've got 22 more chapters to go before I can get to work on my real project!


cheerios
amy

[June7]

Did you run Debug Compile?
Right off I get error "Can't assign to read-only property."

Why is there no table? How would you expect procedures to add/update/delete data to work when there is none?

I have never used Class Modules.

I don't use macros, only VBA (only exception is AutoExec macro).

Also never used UNBOUND form for data manipulation.

[Micron]

I took a look. You're using embedded macros. That's what the book is suggesting you do? I suppose that's one way to begin learning but I haven't used any macro save for AutoExec in so long that I no longer know how to create or edit them beyond what an AutoExec usually does. Most of us only use code as macros are too limiting. You may not be too eager to learn code, but consider that eventually you will likely migrate to code and all the time you spend learning macros might be a waste.

You can turn on single step option, open form again and click, then you'll step through and can review the conditions. I did that and added a couple of parameters (form name and object type) to no avail. Hopefully we have a macro savvy person lurking here. Seems to me that the error condition (<> 0) is false but I don't know why.

[Welshgasman]

You are using macroes, I do not use those, except for batch operations.
I'd start using VBA if I was you.

You form is also unbound, most use bound forms I believe, something you have to get used to in Access.?
All this Add/Save not particularly needed, if doing it the Access way. You can still roll your own with Add and Save, but more work I believe.

I just got used to bound forms for most of my forms.

If you use unbound forms, you have to insert the data yourself, before you can go to a new record, which in reality is just clearing the current form each time?

[orange]

Most/many developers do not use macros.

When showing some sample code that isn't "working", best to provide some description of what you are trying to accomplish. And what you expected as a result.

[Micron]

You form is also unbound

That is the key.
I altered the first setting to "Fail" and the error that I couldn't seem to raise is 2046 (GoToRecord not being available).
Makes sense that you can't go to a record when there isn't any. The error response setting was basically ignoring the error, much like "Resume Next" would in vba, I guess.

[Amyfb]

I don't understand the reference to macros - i've typed out every scrap of code in the modules using VBA code as written out in the book i have.

i did not use the macro builder, i used the code builder.

as for not having a table - now that is an interesting point that I can't argue with.

I'm ready to toss this book in the trash - it's been a headache from page one. It's as if every other example is missing some little bit.
Does anyone have a recommendation for a solid workbook?

i'm also working my way through steve bishops youtube classes, but I like paper for reference also.

thanks
Amy

[Micron]

i did not use the macro builder, i used the code builder.

Are you absolutely sure? Look at the OnClick event property setting for your button. It definitely shows [embedded macro].

[Welshgasman]

ALL your buttons are using Embedded Macro ?
I can see you do have VBA code for various events, but you still need to tell Access which method you are using.?

There is a setting to always use VBA, someone else here will likely know it. I will have to search for it.

Found it.
Options/Object Designers/Forms
Always use event procedures

[Bob Fitz]

i did not use the macro builder, i used the code builder.

But all the "Click" events are set to [Embedded Macro] rather than [Event Procedure] which would need to be the case if you want the code to fire.

[Micron]

Options>Object Designers>Form/Report design view>always use event procedures (checkbox).
I too now see that there is code.

[Welshgasman]

Christ!, you are using Collections.

Talk about jumping in at the deep end.

I have never used a Collection

Not saying it's wrong, but I'd learn to trot before trying to gallop.

That book seems somewhat advanced to me.
I have a Dummies Guide to Access 2007, given to me by my last bosses.

[davegri]

Your book is instructing you to use custom classes. I would estimate that over 98% of Access developers do not ever code custom class modules. It's a very specialized niche, and in my opinion is never required, as the desired result can be accomplished via normal VBA code. Your book seems heavy on theory, with not enough emphasis on practical common actual coding solutions.
I don't have an alternate suggestion for a book, but perhaps in the review or "Who this book is for" look for phrases like "practical", "everyday", "common", "beginner", "intermediate". AVOID "advanced" and such.

[Amyfb]

Christ!, you are using Collections.

Talk about jumping in at the deep end.

I have never used a Collection

Not saying it's wrong, but I'd learn to trot before trying to gallop.

That book seems somewhat advanced to me.
I have a Dummies Guide to Access 2007, given to me by my last bosses.

Hah, that's me ! running before i can walk.

I did start at lesson one, and each one has been building on the previous one, so, even running it seemed like i could get through ok.

but, i take the point about it being an advanced topic.

i'll dial back and slow down a little......hard as it is for me who wants it all now.

thanks

[Welshgasman]

Something more along these lines perhaps?

https://www.amazon.co.uk/Access-2010-Bible-Michael-Groh/dp/047047534X/ref=pd_bxgy_img_1/261-6515281-8625936?pd_rd_w=BJsZw&pf_rd_p=c7ea61ca-7168-47e3-9c8b-d84748f5b23c&pf_rd_r=VQ6TGADGJVDZQN0QJ730&pd_rd_r= 01790dad-6eb0-4c4a-bb42-c3af2cc2ddb9&pd_rd_wg=vM4Jl&pd_rd_i=047047534X&psc =1

See what your local library has as well?