Recent content by rmarquez5

Wow... 4 years later... ;) ... and my movie database question generates another reply post! :D My movie database is not very complex really. Every record has a set of columns that match very closely to the info at allmovie.com. Specifically, the "Cast" column is of type Memo so that it can...

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

Thanks for all the input, peoples. :) The MOD function was my saving grace. I ended up making another table with an AutoNumber field and movie title field, inserting the records into that table, and running a query to find all ID MOD 75 = 0. Works like a charm. Once again, the Access World...

That's a great idea... but my AutoNumber field has gaps in the numbers. Is there any way to renumber an AutoNumber field??

Hi Wayne. The first query is ordered by title. I need every 75th title. I'll try "TOP" to see what I can generate though. Thanks.

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

Actually... I think that was it!! I redesigned the report, making the fields large enough to display enough information cleanly, but also not allowing them to shrink or grow. Now my detail pages fit perfectly! Thanks so much. :D Funny how MS Access 2000 behaves though. I wonder if that is...

Just as an update... I've figured out in better detail what the problem appears to be. Here's a rough layout of my report... title title picture synopsis cast other details1 ---------...

I've done that. Still no luck. (And it was preventing my memo field from showing all the data in its field. Its a synopsis of the plot of that movie record. So its quite descriptive. :P)

Actually... the text boxes have a little space between them. (One "grid dot" to spare.) Would text fields bound to memo columns cause problems? (I'm reaching here... I'm running out of ideas...) R.

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

Nope. There isn't any duplication of data. There is a duplication in structure though, and data moves from one table to another (usually from the scheduled recordings to the current collection, for example.)

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