Search results for query: *

I have a form that has a textbox names text42. If the correct value is entered into the box a tab page will appear. What I would like to do is when I am done with a record I would like the text42 field value to automatically clear when I advance to the next record. Here is the code to get the...

I need some help. I have a retail business and I an trying to password protect a few fields on my form. Here is a list of fields I have on my form: ItemNo ProductName WhitePrice YellowPrice OpenhousePrice RetailPrice Units Description Image What I would like to is have The fields WhitePrice...

I have a field in one of my tables named VideoFrmt and I have 60 records with an entry of NTSC in this field. When I run a query it only displays the 20 results of the 60 entries. How do I get the query to display all the results so I would have a total of 60 records displaying NTSC?

I have a form that is used as my search form. This form is referenced to a query. I would like to be able to enter data on the form but not to have any records changed. The problem is that when I enter data on a form the records get changed. I want the form to be a search form with no record...

I have a main form that I display basic information about actors in my dvd collection. My main table has the primary key "ProgramID". My actors table has primary key "ActorID" and my Characters table has primary key "CharacterID". On my main form there is a subform that displays what movies...

How would I do this conditional format? My combo box is named "Status" and my textbox is named "Title".

I have a combo box on my main form with the values: Not in collection, In Collection. If I choose the section "In Collection" from my combo box I would like the font color of that particular record in my text box named "Title" to change to black. if I choose the selection "Not In Collection"...

I have a main form with a subform attached to it. The subform is attached to 2 different tables. What I would like to do is that if a selection (in the subform)is chosen and it is in table 1 then I would like that selection to have a red font. If the subform selection is in table 2 then I would...

I would like to be able to select and item on my subform which is attached to my main form and automatically open up that record on another form. For example I have a dvd collection that has a form named Actors. In the Actors form I have a subform that lists all of the movies that this actor is...

I would like to have a different startup query for each of my users. For example if I have the users: user1,user2, and User3 I would like to have query1 run when user1 loggs in and when user2 loggs in then query2 would run. I have already ran the User-Level Security Wizard on this database. I...

Lets say I have a reord named "Trailer trash" and another record named "Downtown Train". Both of these records have movie trailer clips assigned to them in another table named "tbltrailers". What I want to do is if I advance to the "Downtown Train" record on my main form I would like the subform...

What I am trying to do is take image path data from a cell and have it automatically display the image when the spreadsheet is open. For example, let save the data in cell F2 is "C:\test\image.jpg" I would like to have the image automatically displayed when the spreadsheet is open. I gave it a...

I am trying to build an MP3 database. What I would like to do is allow duplicate entries of a song title based on the artists name. For example lets say i have a song named "Buring Down The City" by XYZ and "Buring Down The City" by ABC. I would like to allow the song name to be duplicated only...

I have a form that has a yes/no check box labeled "Loaned Out" for my dvd collection. I would like to have another form popup if I click on the checkbox and make it a yes answer. The popup form is called "Loaned Out Info" which this data is placed into a table called "Loaned Out".

Is there a way to have an image display in a box automatically without me having to click in the filename in the box. I have tried this but I keep having to click on the filename. Each record will have a different image.

Is there a way to set a default font and size of forms so i don't have to go and set the font and size of each field manually?

It works thanks.

I noticed that in my main form when displayed in form view my subforms also are displayed in form view. Is there a way to display my main form in form view but have my subforms displayed in datasheet view? If this is possible, I am not sure how to do this.

I have a main form with one subform it. I would like to have a form pop up if I double click on an empty row in the subform or if an item is not in the list.

On my main form I have a combo box that I can select the movie I want then click on the control button to open another form to display information about the title of the dvd movie I have selected. Everytime I do this I notice that there is a new record added to the main table. Is there a way to...