Search results

I have a list box that my client goes through with vbKeyDown and vbKeyUp. When he finds the correct record he wants to do vbKeyReturn and capture the checktype code and description and have them placed in a check which is another form that is open. The following code does not work but gives an...

I have a form which has a subform that holds records from a table. When in the table i can move through the records with my up and down arrows but when I am in the subform i can not move in the same manner with up and down arrows. What needs to be done on subform to allow user to move through...

I am aware that access 2007 has keyDown event for reports but access 2003 does not. My client's system is written in 2003 and he is not willing to invest in 2007. Is there a way to have the report print by selecting F6 after the customer views the reports contents to see if they are correct...

I have a subform that when the user deletes a record from it he would like it to return to a similar location. Code I have used is lcate = me.currentrecord delete query close form reopen form forms!parentform!subform!txtbox.gotorecord lcate this is not the actual code but gives the idea as to...

I have a subform which holds data in a datasheet mode. when i delete a record i close the parent form and then reopen it because i am not having luck making the requery work. the user wants the position to be at the location the form was before deletion although it will be a different record...

I am running delete and update queries using docmd.runsql. I am finding that particularly after the update query is ran the record is locked and other field in that record can not be updated via a form without a warning saying another user has made changes to the record. To be more specific -- I...

I have used: Select Case KeyCode Case vbKeyEnter and Shift = acCtrlMask some code and when I run the program KeyCode = 17 or vbKeyCtrl thus not entering the case statement I have done: if KeyCode = vbKeyEnter then if Shift = acCtrlMask then some code end if end if with the...