Recent content by SyntaxSocialist

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!