Search results

I don't think he is searching for anything, he is trying to add a new record which involves a new check number in the main form and wondered why the subform data was displaying. That's because of Check# linking to Check# in the subform. The big problem I see is that the main form is based off of...

What about them?

No, you are allowing analytic data to be collected anonymously. Turn it off if you don't like it.

I just made the assumption that was contact info based on the time of the job. If not, by all means do not do it the way I suggested. Anyways, no worries. Everyone have a good weekend.

I'm not pushing any final design on anyone. That's up to the OP's own business rules. If they need something else, that's perfectly fine. Use the shopping cart method and take what you can use and leave the rest. If there is no need to retain the contact names or company names at the time of the...

I guess they never cared about the environment after all.

I didn't mean to derail the thread. Whoops.

And yet we still don't know the guy who planted the bomb in front of the DNC on Jan 6th.

I guess what I meant was drones that go where ever they want (AI) to go to make sure everyone follows the laws. Constant surveillance on another level.

A more scary thought is FSFD, Fully Self Flying Drones.

That may be, but that message can popup for other reasons as well because it happened to me a few years back. This particular reason being discussed is just one of the reasons. Can you make simple replies now, or do you always get that message? How are you able to reply to this thread? Seems...

I did not know that Doc. How many posts does one have to have before that restriction goes away?

It's not wrong if you want to do it that way and it suits your requirements. I do it all time and there is no issue with it at all. I understand your point of course, and that is another way of doing it. Set it up however you desire, but there is nothing inherently wrong with it.

Very interesting. I see what you mean now. This is not an actual switchboard, it's just a form you are using to launch other forms. The click event is not firing when the application window is minimized in the manor you are doing it. All I did was delete the autoexec and use the standard open...

Have you looked at Collin's work on hiding the application interface? Also, is the form that you are trying to launch also a popup form? If it's not, then it will only be visible when the main application window is also visible.

You can put some If Me.NewRecord Then logic in VBA to make it stop doing whatever you are currently doing. Check the On Current event.

Don't do that. To troubleshoot, I would just go straight to code using Alt-F11. From there, open the page code for the form you are opening and see what events are being used. Maybe put a break point at the start of the On Open event or On Load event, whichever is being used. There has to be...

Did you try to do the Shift-Bypass on the database? When you launch the database, hold shift key and then double click the file to open it. This bypasses any startup code that might be affecting things adversely so you can troubleshoot the problem.

In your junction table, you probably want two more fields for the ContactName and CompanyName. Then in the after update of the combo on the subform, those two fields get populated depending on the contact you pick. So your new form looks like this. I updated the backend so you have the many to...

Post your original working code.