Search results

I've made a home movie library database and for the most part it's complete but I thought of a handy feature to add last minute but I cant get it to work rite and need some help with it. The main form lists movie details (title, genre, rating, description etc...) depending on which movie the...

I'm new to Access and could use some help figuring this out. It should be a super easy fix for someone with Access experience... I'm just a noob!!! :o I have a DB that I use to keep track of friends and am trying to create a form that makes it easier for me to edit existing friends, or enter...

Need help fixing a form that uses combo boxes to retrieve data. I have a home movies DB and have forms set up for keeping track of loaned movies, but my AddEditLoans form isnt working rite and I dont know why. First, I have a combo box in the main form to select friends names. When you select...

I have a report that draws its info from a home movies database. In the report I'm trying to display the movie title, rating, genre, personal notes about the movie, stars of the movie, and a movie description. All this info just wont fit even on a Landscape report, so I thought I might put the...

I'm trying to make a form for my DB that allows me to select movie names from a combo box, and after choosing the movie, the movie details will be populated into their respective fields in the form. I created a combo box to select the movies, it lists all the movies in the DB, but when I pick...

In my database I have a PK in the Actors table so when I enter a value that already exists in the PK field I get an error message similar to: "The changes you requested were not successfull because... primary key... etc...". Is there a way to use VB code to display a different pop-up message...

I have a DB that allows the user to add data using several forms but am having a problem... In my main form (MovieDetails) I have a command button that opens up another form which let's the user add new actors to the DB but after adding the data, if I go back to the main form (still open), it...

I have a home movies database that I'm creating and am trying to prevent the user from entering duplicate star names. My initial thought was to simply make the star name field a PK, but I cant because if I do it breaks some of the relationships. So, I'm curious if there's a semi-easy way to...

I have a home movies database and a form that allows the user to add actors (for assigning them to movies) by entering the star name into a text box. But without a pop up message, there's no visual confirmation that the data was written to the database. I'd like to add an OnKeyPress event (or...

Access noob, subform help. Error msgs, not allowing edits, & not updating fields...? I'm working on a home movies database and created a form (MovieDetails) that should allow the user to either edit existing movie information, or add new movies to the database, but the subform is giving me...

As the title states, i'm still a noob at Access. I'm trying to build a database with which I can keep track of my home movie collection, track loaned and returned movies, and help to eliminate duplicate movies (in case I've already entered a movie, then later buy it again, and enter it a second...

Does every table in a 3NF DB have to have a PK? I'm an access noob, still learning, please bare with me. When building a database in Third Normal Form, does every table in the DB have to have a primary or composite key? Can a table just have a Foreign key and no Primary key? I should know...

I'm still learning Access, studying normalization now and need some help figuring out if I've successfully converted an un-normalized database into 3NF. This is the un-normalized table: * tblOriginal (ClientNumber, ClientName, ContactName1, ContacPhone1, ContactName2, ContactPhone2...

I'm new to access, still learning, just learned about forms this past week and am practicing building one that lets a user update or add new orders to existing customer orders, but it isnt working rite. The form works for the most part, but there is one field that doesnt populate to a related...

I'm not familiar with the DLookup function, but am trying to accomplish a task that I know should use this function and need some help with the code. My scenario: I have a "Add or Change Customer Orders" form that displays the OrderNumber, OrderDate, CustomerNumber, and CustomerName. This form...

Hi, I'm new to MS Access and have a question about Parameter queries. I have a "Parts" database that contains part numbers, descriptions, and prices and I'm trying to create an Update Query that will prompt the user for a part number, then prompt them for a percentage to increase or decrease a...