Search results

lol not enough coffee? sorry to bother u with such n00b questions but.....ive been able to click the "..." at "onClick" for the button ive also been able to put in the vb code in the vb code builder but now....how do i "save" the damn thing?

i suppose i could run the macro from the module if i need to but the issue is still executing the module from my "cmdUndo" button on the form

yeah the thing is...after i "build event" and change the code...it's no longer a macro it turns into a module the problem now is i dont know how to execute a module in access regardless of the version :(

thanks soulium.....i've managed to edit the vb code after converting but its no longer a macro...but a module in access...im guessing thats what's supposed to happen..... so how do i execute this module when i click the "undo" button? i swear i saw a "runmodule" action in macros before having...

Hi all, I've got a macro that has the following 3 actions. 1. SetWarnings = No (to turn off the annoying messages in the first place) 2. RunCommand = Undo 3. SetWarnings = Yes (to turn annoying messages back to default) When there is nothing to "undo" on my form, there is the annoying...

ill definitely be having a look at this feature thanks

Hi all, I'm putting together a timesheet database for a small company. There will be so far two types of users. 1, the boss and 2, the employees. There will be various forms also, such as 1, the timesheet 2, entering new employee 3, editing employee details etc I was thinking, in order to keep...

Cheers. You've got me doing what I needed.

For the first, I'll look into VBA help. I thought there would be an undo action in the list of macro actions. Couldn't find any. For the second, I've come up with something nicer. I've made a macro with actions... 1. save (just in case it decides to work) 2. setvalue (cboEmployeeID = "") 3...

You're right. So that also saves me time with my "Save & Close" button. All I have to do is have that button close the form and the changes will update the table. How about my other "Close" button? Where I don't want the changes updated, but just the form closed? And my other "Save" button...

hi all i have a form (frmEditEmployee) used to edit employee details. the record source being SELECT tblEmployee.* FROM tblEmployee WHERE (((tblEmployee.[Employee ID])=Forms!frmEditEmployee!cboEmployeeID)); when an employee is chosen from the top combo box "cboEmployeeID," the rest of the text...

Well the problem with using just SELECT tblEmployee.* FROM tblEmployee is that the rest of the text boxes will not be populated with the employee I select with the combo box. Actually I get an error message too. I think my mistake is one of the following two... 1. The "save button macro" has...

You know this is really weird. Don't worry about coming back to this post again. For another one of my forms "frmEditEmployee" (just now we were on frmNewEmployee), I had the same "on dirty" events and buttons. I tested it out, works fine. Make a change to the macro, change it back to how it...

You know what, now it doesn't work at all! Even if I try just the ONE button. I'm going to rip out my hair soon. I've made sure the form has "mcrNewEmployeeIsDirty" on the "on dirty" event. I've made sure the save button on the form is called "cmdNewEmpSave" and that it's disabled. I've made...

Yeah my macro had two separate "set values." One to each button. I've never used vba code before. Any good sites where I can quickly pick up some basics? Cheers

Hi all, I've tried the search but no luck. I have a form with TWO save buttons (one's just to save, the other to save then close). Each have been "disabled" and EACH have a macro to "enable" them when the form "is dirty." Problem is, I don't know whether the "on dirty" event of the form can...

Hi all, My simple "Edit Employee Form" has not been made with the wizard, instead it's been done in design view. This has helped me learn more about how forms work with queries etc...but not enough obviously. When you select from the combo box (showing employee ID AND name) the employee, the...