Recent content by jmckeone

So, I took another stab at it and it seems Forms!MyForm was not recognized. When replaced with Me it does not fail but still does not return to the correct record but kicks back to beginning again. Before spikepl gives me a verbal bitch slap again a little reminder this is my first venture into...

Forgive me if I'm thick. I've tried applying this procedure and it still goes back to the first record in the form. Here's the code with the last 3 commented sections being where I attempted to apply the process. Private Sub butnRemove_Click() Dim strUpdate As String, strDelete As String...

I'm thinking my issue may be the under 10 posts situation as that option does not appear for me. I'd post a couple more things pointlessly but suppose I'll wait until I have legitimate questions to make up what I lack in the 10 count. Just rechecked and my post count is at 10 and still no...

Clicked it and where it takes me does not have the word picture anywhere to be found. Would be shown below but seems my post count must exceed 10 to share an image. www[dot]bild[dot]me/bild.php?file=9553809cp.png

I'm setting up my user profile and notice others with photos but I cannot locate the option to add one to my profile. Where do I go?

Thought that was too simple. Advice on how to store record location to return to next after requery?

Thank you very much. That worked beautifully.

I'd found that command via a google search and though I included it in my code, shown below, it did not seem to do the trick. Private Sub butnRemove_Click() Dim strUpdate As String, strDelete As String Dim ctl As Control Dim strSet As String Dim bFirst As Boolean Dim...

I've been using VB in excel for years but new to it in Access. I'm working with a form someone else created and am adding a delete button. I've managed to add the button and get some code working which will delete a record from a table. The problem I'm having is that after the delete operation...

Seems I'm used to the terminology of Excel where VB code is referred to as a macro and it seems that is a another thing in Access. Did say I was an Access newb The result of the debug is UPDATE tblMaster where ID = 949 As I'm revising existing code that is one place there is a disconnect...

I've been tasked with modifying an existing form to add a button allowing for the deletion of a record. The existing code below seemed a good place to start. So far I've only changed the name of the code which the Remove button points to. The aim is to delete the record currently displayed and...

Hello, I'm Jon. While I've worked with Excel and used VB to automate tasks there I've recently been thrown into access 2010 and am finding it a very different animal to use VB with. Hoping to learn and grow through my membership here.