Search results for query: *

as always thanks a lot PHV!! :)

Hi all, I'm generating an excel report from my access application with VBA, using: DoCmd.OutputTo acReport... I currently place the files in My Documents. My question is, how can I tell the application to generate the files in the same directory where the aplication's files are located? This...

Thanks a lot PHV!! That's what I needed!

Hi, I have a form with a calendar, the calendar control 11.0. When a date is selected, certain data from a databse is showed. When the user clicks on a date this works fine (with the on_click event). The problem is this user move on to calendar with the arrow keys. So when changing to another...

Thanks PHV! that definitely solved the problem. However, it still doesn't go to the recently created record. Maybe there's another way of doing it? like going to the last updated record? I've seen there's a LastUpdate property in the rs recordset... Thanks a lot for your help

Maybe a better explanation here, would help. Form B is embedded in Form A. I open FormC and create a new item. Then upon closing Form C, FormA and its sub form (FormB) should be refreshed, and Form B should show the new item recentrly created from FormC. Thanks Remou!

FormB is embedded in FormA. Here's the code I added on FormC close. Here FormC is another Form, from where I create the new record, to be shown in Form B. 'on FormC close Private Sub Form_Close() Forms![FormA].Recalc Set rs = Forms![FormA]!FormB.Form.RecordsetClone rs.FindFirst...

I forgot to say that, as FormB is a subform, what I tried to do was: Forms!FormA!FormB.Form.Bookmark=rs.Bookmark instead of Forms!FormA.Bookmark=rs.Bookmark Thanks a lot!

Thanks very much for getting back to me Remou! When I tried this, the line Forms!FormA.Bookmark=rs.Bookmark" gave me an error "not a valid marker". Form B is a subform -- might that be the problem? Do you know what I can do about this? Thanks a lot!

Upon closing one form, I'd need a specific item in another form's list to be selected. Basically: Form A: main form, lists all records in db Form B: new record creation form Upon saving/closing Form B (thus returning to form A), is there a way for the newly created record to be selected in...