Search results

Many thanks to all That solved the scroll problem completely for me ... and finding out what "current" is for solved a couple of other work-arounds that I've been using. I loveAccess when it's working ... but gee it's sometimes very frustrating getting it there!

Thanks Ansentry, that worked great when the form loads the first time ... but when I change the customer on the main form and the subform updates to show the comments relevant to that customer, it doesn't go to the last record on the subform. I tried adding the same code in the "after-update"...

It's the sub-form that I need to scroll to the last record. I tried the following code in the "on-load" for the sub-form, but it doesn't scroll down ... Me.Comment.SetFocus DoCmd.RunCommand acCmdRecordsGoToLast I thought I was getting better at Access, but then it throws something like this...

Thanks Ruralguy ... I tried it but I'm a little confused ... is it theon-open property of the subform or the main form? Mike

Is there a way to automatically scroll a subform on opening so the subform is filled with the last few records along with the new record data entry line? Thanks for any help, Mike

Has anyone actually implemented a solution using the two sub-form overlay technique? I havn't been able to quite manage it; How do I get the dataentry form to just show the data entry line? What we are trying to achieve here seems so basic that I'm amazed Access doesn't have an option to...

............ but that didn't help. Despite pointing to the Canon printer, it still prints the report on the Magicolor 2200..... !!!!!

Thanks for the hint ... on Access 2002, It's File/Page Setup where one can choose a specific printer (or the default).

I've searched the forums for an answer to this question and surpassingly didn't find an answer ... Some time ago I set up my Access 2002 DVD database to print covers on a color laser printer, though this printer is NOT the default system printer. I use the simple print command...

I'm removing the toolbars manually, should I be doing it with VB?

Thanks hayley. Does this work on "memo" fields?

I want to have my form open at the top left of the Database window so I'm using Movesize 0,0 in the "form open" event. This works great until you try and eliminate the default tool bar to save space (I want to keep only the menu items). After movesize 0,0 the form ends up below where the...

To use paint I would have to manually create each upside-down text string which isn't practical and turning the page would slow production a great deal. For now I guess I'll have to cut the page in two and glue... :( I can't believe no one has ever needed this capability before. :confused:

It's not an image, it's text I need to print upside down.

How do I print some text upside down within an Access report? Thi seems like an obvious request, but I've searched to no avail for a solution. (I need this as I'm printing inserts for CD jewel cases that need to be folded. To get teh text on the backside the right way up when folded, I need...

Thanks Mile-O-Phile for the great news! :( However, there is a silver lining to this cloud. I started the process of re-building the form by copying elements from the bad form... checking all was good every few elements. As luck would have it the third element I transferred was the cause of...

I tried the repair and no luck. When I transfer all the to a new DB I get the error when I try and paste the troubled form into the new DB. I've gone back to old versions of the DB and they all have this error - trying to open a now non-existant file. I'd hate to have to try and re-create the...

I have just made some changes to my DVD database to make the reference to the cover images relative instead of a fully qualified pathname. The change went smoothly, but for some weird reason when the form initially opens it tries to reference a file from teh old directory. This reference...

I have a DVD database that uses a seperate directory to contain the DVD over images. The user chooses the image for a particular DVD using the following code: Private Sub imgPicture_DblClick(Cancel As Integer) Dim OFN As OPENFILENAME On Error GoTo Err_cmdInsertPic_Click ' Set options...

Thanks for the help Fizzio. I'm not sure why the Query builder messes up with several criteria and references to forms, but anyway I got it nailed using VB and the rowsource. Just incase anyone else finds this thread while searching what to do: View2 is the name of the list box ... Criteria1...