Search results

Thanks Kevin and Pat. Kevin, you were right, that's what I had to and I figured it out yesterday. What I did was counted the number of records in Me.Recordset, moved to the first record, performed the code, moved to the next record, and looped it all over again: Set rst = Me.Recordset...

Hi, I am trying to perform an action for each record on a form. I have my code in the OnCurrent event, but when the form opens, the oncurrent event only runs for the first record, not the rest. The code is run for the rest only when I click on that record. Where do I have to put my code so that...

I'm trying to use the keyup event to detect that if CTL + Apostrophe were pressed at the same time, to tab the focus to the next control. But when I use the keyup event, the event runs and only one keycode is present, the one for APOSTROPHE. How do I get the keycode to read a combination of...

Does anyone know if there is a way to tell which Delete Confirm box pops up when you delete a record from a form/table. For instance, if you try to delete a record with related records in another table, a Delete Confirm box pops up notifying you that you are trying to delete a record with...

Does anyone know the code behind determining if a form/report is already open? I have a command button that opens a report, and if the report is already open, I would like to stop code behind the button and display a message box. Thanks Rosebud

Can someone help me with this? I have an Unbound Object Frame (chart) in the detail section of a report. The chart's rowsource is a few fields from another query. I would like to filter the results of the chart. In the VB code I typed: Chart1.Report.Filter = sql where sql is the select...

That didn't work either, and I never got it back. Luckily, I backed up the database on disk, so I was able to retrieve most of the code behind the form, and the rest I was able to remember. But thanks for your help.

After I finished adding VB code behind one of my forms, I decided not to save it after all. The thing is, now Access won't let me view the code for the form at all. It won't even let me add whole new code for a whole new control. It's like I deleted VB Editor from that form. Is that possible...