Search results

Sorry it's taken me so long to get back to you all on this! I've been plugging away at it while managing a few other projects. I also hit a few roadblocks that took some time to overcome. Done now, though! Thanks jdraw. The page you linked to led me here, which almost did the trick for me...

Yes I left them out (there's a comment to that effect), as I expect there to be a degree of similarity between the methods in that regard. If you need the full code, here it is: 'Transfer data from emails (form responses) to an Excel sheet. Option Explicit Option Compare Text 'Constants, to...

Neat! Thanks! Any insight on the Outlook-to-Access problem?

Hi all. Hopefully I'm not duplicating a topic here, but I haven't been able to find what I've been looking for elsewhere so here goes: I've built an HTML web form that sends an email to me upon submission with all the field inputs. I have previously found success using VBA in Outlook to parse...

Mind = Blown. Thanks man! I ended being able to drastically simplify the whole thing, and the code is now done! Woot! Thanks again for the help. Real life savers you two :)

Genius. Thanks for the idea! It wouldn't work in all cases, but since I want to perform the same action for both instances where foundState evaluates to -3, this should suit my purposes perfectly! Will try it out and check back.

Hi all. I have a boolean array, foundState(3), whose 4 elements correspond to 4 variables describing conditions that will dictate what action is taken upon closing a form. There are only 6 possible outcomes for the array, and they can be divided into just 4 cases: Case {T,T,T,T} Case...

Solved. I used DoCmd.GoToRecord ,,acNewRec. There ended up being some kind of issue with the interaction between that and btnClear_Click, which, as was implicit in the name, simply set all the controls to be empty. Textboxes were set to "", comboboxes received the focus and had their .Text...

Solved. I was right about the issue being a byproduct of the problem described in the link. Check over there for the solution :)

Well, it means that "#Deleted" still appears as described. After some further investigation, though, I'm seeing that Private Sub Form_AfterDelConfirm(Status As Integer) isn't actually firing... EDIT: It would be worth noting that "#Deleted" only appears in certain circumstances: If I open the...

Thanks for the reply. Unfortunately, no luck :(

On a data entry form bound to a single table, there is a subform displaying all the records in the source table. If the user accidentally adds a record that they didn't mean to add (or if I add a record to test the form's functionality), and then right-click and delete the record, "#Deleted"...

Sorry. Meant to provide that. I've added it to the original post.

I've got a data entry form bound to one table. The form has four buttons: - Clear Fields - Cancel - Save and exit - Save and add another (which should save the user input to the subform/table, clear the input fields, and allow the user to add another record) I can't quite seem to get the "Save...

Holy scat-monkeys... I totally forgot about that feature!

On a form (default view: Single), I have a bunch of bound controls that display one record at a time from tblMain. I have a bunch of unbound controls as well (buttons). If the user tabs through all the controls, reaches the last one (btnLast), and presses tab again, the focus is set to the...

Maybe it's the fact that I didn't sleep last night, but I'm still not able to get this working properly. I've commented out the public sub that was being called from the general module, as well as the code in the subform's Current event that did the calling. I set the main form's Record Source...

Sounds wonderfully simple. But I can't get the form to let me make the recordsource anything but a table or query...

The reason lies in the fact that I want the subform and main form to reflect one another, as in a split form. I found split forms to be wildly unrobust, so I set out to emulate their behaviour. Now, if the user selects a record in the subform, the bound controls in the main form display that...

But then why wouldn't it stop at the Load event when I had a breakpoint there? And why would it then run again?