Search results

I had the same issue. From an internet search found there is a bug where the buttons on a form loose link to their vba code. At least that is how I understood it. In any event its intermittent. Here is the way to "fix" it until it happens again the next time ... Opened the addcb file...

You are correct. Should have done that here. Makes code more compact. Thank you.

That works great. Thanks. Nice. Let the Query do all the heavy lifting. That works great. Thank you very much.

I have a Report that displays students (first name, last name, class list, and if they have a car or not). I want the report to show each student on a line, and display a Label ("CAR") if said student has access to a car. I tried Report -- Current Event, but that seems to do nothing, so tried...

Ah, thank you, missed that.

Oh. I get it now. Thanks. I didn't see the double/single quotes until KitaYama pointed it out to me. So thanks to you for the initial post; and to KitaYama for pointing out what I overlooked.

True, tblOrders is what you are looking for. In my environment Jobs isn't used. Not sure how clicking on an item in a list is not that intuitive? Reports do lists well, and since there is an 'On Click' Event, thought it better then a button. But I can see where a continuous form would do...

I ride a bike to and from work, so I get out at least twice a day for about an hour. Nice weather makes the ride very enjoyable, and almost everyday is nice weather here (especially since there is no snow!). I should go to the beach and swim more, but on the weekends I usually just sleep...

I have a database that uses a report to show all open jobs, the idea is to click on a job and have a form open so the user can edit that order. All the work is done in the Event 'On Click' where the OrderNumber is passed to the form so it knows which record to open. Unfortunately this doesn't...

I'm Bobby, live in Hawaii, USA. Work at a warehouse, write a lot of excel and access stuff to keep things straight. Spend too much time at work.