Search results

Greetings all. My movie database continues to evolve, and now I'm building a report that displays a brief bio of a given actor/actress, followed by a filmography made up of titles in my current collection. Pretty straightforward report, but I am running into a problem with layout space on my...

Greetings All. I have one query that retrieves a list of all movie titles whose ID is between A and B. Currently, this query retrieves exactly 525 records. I want to write another query that retrieves every 75th record from the above. So want record 75, record 150, record 225, etc. Is there...

Report Not Same As Design View (sometimes) Greetings all. My movie database has benefited from the many tips and tricks from these forums. I am hoping to pick your brains once more for a report issue... One of my reports is designed to basically output the details of a movie title, one movie...

Greetings all. I am trying to write a query much like this: select [title] from [want list] where [title] not in (select [title] from [available movies]); When I run it, I find it runs SO slow. Is there a better way to find the same results? Any input would be much appreciated. Hope to hear...

Greetings all. I have a created a useful recorded movie database in Access. One of the columns in my tables is a memo field, containing a description of the movie. I have a three main tables: a want list, scheduled recordings, and my current collection. When I use an append/insert query to...

Greetings!! This is a general question to all. My movie database is just over 270MB. I have some very basic info on about 1000+ titles -- title, tape#, position on tape, genre, and (this is probably the kicker) an object column to hold a small jpg of the movie cover, and a memo field to hold a...

Greetings to all. I need to pick your brains, please. I have a movie database. I am adding an enhancement that keeps track of the ID of the last movie that was printed off in a given category, and current max ID found in that same category. If the IDs are the same, then you don't have new...

Greetings all. When you build a query in MS Access, you can usually rename a field name to something more meaningful, if need be. Say the column in the table is called column1, but you want it to be a column named "title" for your query, you can say: title: column1 What I want to do is make...

We have a couple of end-users that are running into an error when closing the data view of links to Oracle tables, indicating the following (or something similar): "This action will reset the current code in break mode... Do you want to continue?" If you hit Yes, the window just pops up again...

If someone can help me out on this one, that would be GREAT. I have a report that consists of an object field which displays a picture and a text field underneath it as a description. I use the column settings in the page setup to display 8 columns. When I try to export the report to an RTF or...