Search results

The above query works OK... it's when I add a second criteria and reference a second that the query builder seems to get all messed up. When I look at teh SQL it creates it is all messed up and the form does not work as I would expect. So I would like to build the query with VB so I can make...

Hi Fizzio, thanks for the prompt reply ... An example of the SQL I'm using is: SELECT DVDs.DVDID, DVDs.Title, DVDs.Year FROM DVDs WHERE (([DVDs].[GenreID]) < 90) Or (([Forms]![Browse DVDs]![Adult]) = -1) ORDER BY DVDs.Title, DVDs.Year; I have noticed that building the SQL using the design...

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

Awesome, thanks VERY much. I've been puzzling over this for a while and it's wonderful to see such a simple and straightforward answer.

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

Thanks Tim, the registry entry worked like a champ.

Many thanks guys, this works much, much bettert. I have just one question ... While flipping through the database when it's loading the picture for each DVD a msg box pops up saying that the picture is being imported. This is a not a big deal, but it's a bit distracting. Is there anyway to...

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

Well after some research, I found my own answer. I'm posting here for incase anyone else is looking in the future. Since the data I need was in a combo box (sourced from teh ratings table) it was easy to get the actual rating using: Forms![Browse DVDs]!rating.column(1)

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

That works - sorry before I was running the sample out of the zip file and it was read only! The sample is a bit different from what I'm doing - my subform is shown in form view, not as a table. I tried to add the databse here as an attachment, but it's just a tad too big.... can I email it to...

I tried the sample and clicking on the button it says "Can't go the specified record". I'm using Access 2002 if that would make any difference.

I tried adding setfocus but it didn't help. The error message says the object may be a control on a read only form or on a form that's open in design view or the value may be too large. I know it's not 2 or 3 and I don't see how the form would be read only, but it's a possibility. What's...

The button is on the subform... I tried putting it on the main form and that didn't help... same problem.

Sorry.... Private Sub NewRecord_Click() On Error GoTo Err_NewRecord_Click DoCmd.GoToRecord , , acNewRec Exit_NewRecord_Click: Exit Sub Err_NewRecord_Click: MsgBox Err.Description Resume Exit_NewRecord_Click End Sub This is the code the add wizard button created.

Yes, I have written most of the code that is already in the spreadsheet so I can compfortably add code to the present button....

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