Search results

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

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

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

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

I’ve been coding up Access databases for my own personal needs for some time but I get confused easily around queries and I wondered if someone could suggest the best way to accomplish the following: I have a large list box that contains a list of DVD movies I own Title & year). I would like...

I have several List boxes populated with queries in my DVD database. These list boxes allow the selection of a particular DVD. I’d like to initialize the list box to the first record in the query so that particular DVD comes up automatically when the database opens (like when I click on the...

I have created a DVD database that includes graphics files of the DVD case covers. Each cover is about 300K in size. The databse performed well when I only had 50 DVDs, but now I'm up to 200 DVDs and flipping through the database is getting slower and slower as it pulls up each record. The DB...

I am printing a one page report based on one record of a database. In the record is athe rating of the movie, but it's stored as an index into a table of movie ratings. I need to print the movie rating on the report but all I can get is the index into the movie rating table. How do I get at...

I’m having problems adding a new record on a subform. I used the “command button wizard” to add a new record on the form that’s used as a subform.. When the form is opened by itself the add record works fine. But when I try and add a record when the form is a subform I get an error as soon as...