Recent content by momaw nadon

My problem is I have been over thinking this whole thing. Its hard to put words to it. Sorry I didn't clearly define what I was asking. I have this database, that needs to be updated to include more information now. I need to change a memo field that you were able to just input the data, that...

I'm looking for VBA code to help me get started on and idea. Basically I have a drop down with 3 options on a form (not sure if I will need this information within my table or not), but need it to pull up a window to input depending on which option is selected. One selection of the options if...

I'm still needing help on my edit button. Though can someone tell me why there is a pop up on the report button? I get a pop up asking for site number, but it has no bearing on what number you put into it, as it will report on the one you have selected in the form. Is there a way to have the...

Thank you for help on the report button. It works as needed now. Though I'm not sure I understand what you are asking on my edit/save button. Would you be able to post me an example? Thank you for your time and help. MN

I'm still learning Access 2010 and having issues getting my buttons to work the way I need. I'm working on a simple address database. First issue is with my edit/save button. On form load, my fields are locked and my button will read "edit". After clicking, my fields are unlocked, my search...

Was able to fix my problem, it turns out that I had a misspelling in my code. Though I have found that my button doesn't return to load state of my form like I need it too. So I need a dynamic or duel function button in that I click it to edit and then click it again to save changes and return...

Removing the "Call" didn't change anything still getting the sub or function not defined error. I didn't copy/paste, but I double checked to see if the capital letters were correct, which they are. Thanks again. MN

Using your code from above. Just with the field colors changed. I believe it's in the form, as the function is written in the form code. Thank you again for your time. MN

Thank you for the help as I really like the simplicity of going your route, but keep getting a Compile error: Sub or Function not defined. Am I leaving out something when I call the functions, as to why the error? Error occurs on the first line of this part of my code: Private Sub...

Hi, Novice to Access, working on Access 2010. First problem: looking for code to allow me to do multiple things with one button. I can get part of what I need it to do working, as the button will enable fields, change display text (“edit” to “save” and back again), and disable/enable search...