Search results

I was afraid that would be the answer. I will go that way. Thanks for the input

In a form bound to a table, I have a list box from which i populate several of the text boxes on the form. No problem. The rest of the form has static fields to be completed by hand after printed. How can i print only what is on the current form, not the whole record set with out creating a...

Thanks guys, I think I have it squared away.

A form used to updating is bound to a table. When the form is loaded all text boxes are populated with information from the first record in the table. I will select the record i wish to update from a list box. is there a way to not populate the text boxes with the first record or a way to blank...

Great Suggestion, I think that will solve my problem. Thanks

I have created form with too little space to display three necessary list boxes used for populating text boxes on the main form. Is there a way programatically to display the single list box at the time it is needed. Perhaps a sub form instead of the list box. I am at a loss as to how to make...

Thanks I figured it out fro one of your FAQs

I have a simple Form to delete a single record from a table. I have a listbox displaying all records in the table, small number of records. I want to select a record to delete and populate the text boxes in the form. No problem this works. However when I click the delete button only the first...

I am in a form updating table records with different dates per record. I started with a validation rule on the text box >#01/01/2010# thinking that null was not greater than this date, and was successful if the entered date was less than this date. However it let a null date in this field pass...

A form with a text box expecting a date has the validation property as, >#1/1/2010# And Is Not Null. If a date is entered older that this the error is caught however if the field is left null it is not caught as an error. I have tried several modifications of this statement with the same...

Other forms queries and reports are using the table this way make a change such as this timely and difficult. Is there a way to save the record in question?

There is a course table with course number and name only. There is a volunteer table with badge number and other data. The table I am attempting to update has a relationship of many course records to a single badge or volunteer. That is why the primary key in this table is both badge and course...

I have a table which has 4 fields, 2 of which are populated when the record is created. These two fields combined are the primary key. The first field is BadgeNbr and the second CourseNbr. There will be multiple course records for each BadgeNbr. I have created a form which is bound to this...

Not entirely new to Access but still a novice. I'm working on my second database and have encountered some interesting challenges. I am a volunteer at our local hospital and have taken on the challenge of developing a database to track the training courses that our volunteers are required to...