Recent content by Overtime

Coming to my rescue again, thank you so much :)

Hello, I need to use a temporary table as recordsource for some of the controls in my subform. I tried to get the main form to create the temp table (run create table SQL OnOpen) but I keep getting an error saying that the recordsource (for the subform) does not exists, then when the form...

No replies, does that mean it can't be done?

Hi, I am working on a warehouse database for a charity that collects and distributes donations. The charity accepts all sorts of donations (food, clothing, furniture etc.) When a donation comes in, an "addition receipt" is created, containing a list of all the items that a donor brought in...

Thank you, I'll consider your suggestions :)

Well, I can't use unbound forms for the reason I explained earlier. Plus, I think you need to be an expert to do that, and I'm barely slugging along. Thank you so much for your suggestions, I really appreciate you taking the time to answer.

I copied the code posted here but it didn't work for combination keys either, although the code is apparently an example published by Microsoft.

Hey, I changed key previews to "yes" like you suggested, but I got stuck on the next step. I've been trying to get the form to do the validation when Ctrl+tab is pressed, but the Keydown event only runs when one key is pressed, for some reason it doesn't read combinations. When I press one...

Hi Spikepl, thanks for replying. I thought about that, but what if the user pressed Ctrl + Tab? That would take him directly to the next page (a blank new record,) even if the first record was still child-less. I don't know which event corresponds this keyboard shortcut. I tried "OnClose" but...

I'm not sure I understood this correctly. I've only been using Access for around 10 days now, and a lot of what you said went completely over my head. How do you control the Insert/update event? By default, Access immediately creates a new record, and saves fields as they are entered, it does...

Hi, Is there a way to prevent users from entering main form data, then exiting (or moving on to a new record) without entering a single line in the subform? I want to prevent the user from creating empty receipts (i.e. entering receipt number and date, and not entering any "items" in the...

That's very handy, Thanks!

How do you do that?

Hey Rain, thanks for replying. I finally figured out what was causing this problem, it wasn't what I expected, I was looking in the wrong place. The reason Access was creating two blank lines is because one of the fields in the subform, let's call it FieldB, has an onFocus event that populates...

Hi Rain, thanks for the response. How would I move the focus form the main form before moving to a new record? This is what I have been trying to do, but nothing has worked so far. I've tried to set the focus to the main form through the subform's OnExit event, but it doesn't work. It's as if...