Search results

I have yet to test but on initial run all looks good thanks. I am going to add if keycode = vbKeyUp & List3.ItemsSelected.Item(0) then txtSearchCode.setfocus end if to see if that works as well. thanks for the push in the right direction.

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...

Never mind I had a keycode = 0 outside of an if then thus nullifying whatever key was selected. Thanks.

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...

Here is the code I am using now Me.Requery DoCmd.GotoRecord acDataForm, "frmVendorList", acgoto, lcate run-time error 2489 The object "frmVendorList" isnt open is what is returned. Since this is the subform in frmNameSearch I have also tried "frmNameSearch!frmVendorList" same error and I...

The part that apparently does not work is DoCmd.GoToRecord acDataForm, "forms!frmNameSearch!frmVendorList", acGoTo, lcate And yes frmVendorList is a subform of frmNameSearch. when the form reopens(requerys) it needs to go to the record whose number is in the lcate variable.

Here is the code I am using and it tells me the object is not open but it is because i just did a requery on it. If KeyCode = vbKeyDelete Then Me.txtVendorKey.Visible = True lcate = Me.CurrentRecord DoCmd.RunSQL "Delete From tblVendorList where [VendorKey] = " &...

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...

Thank you very much. I will do extensive testng tomorrow but initially it looks like this did the trick.

Thank you for the response. the parent form has a textbox which when onleave a search is done on the subform to find the certain record. No master/child link needed. so when I search and find two records with BFI I delete one and then the form should appear with record selector next to the...

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...

Thanks for your expertise. It turns out that the above code needed to be the first line of the event.

When I run this KeyCode is 17 which is passed to the KeyDown method. That is the problem how do I make key combinations work. because the first key pressed is ctrl key which is 17:banghead:

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...