Search results for query: *

I believe that I set up the link child and master fields in the subform controls when I created the subforms, but what I am finding is that unless you enter in data into each of the forms, a record is not created in the tables. Did I perhaps do something wrong?

Hi all, I am relatively new to creating Access databases and VBA, so please bear with me. I have a main form with 5 subforms within it. The names are shown below. Main Form: FRMProjectInfo Sub-forms: TBLAsBuiltReports subform TBLDrafting subform TBLMicrostation subform TBLProjects subform...

Is there a way to pass the value entered in a parameter query into a field in a form? I have a form that when opened will ask for a value. If the value is not found, a message box opens up asking if the user would like to add it. If the user clicks on OK, I would like for the value that they...

I have an Equipment Entry continuous subform. The Equipment Entry subform lists all the equipment in a particular room. Within the Equipment Entry subform there is a field called EquipmentType and a button called Maintenance. If "projector" is entered into the EquipmentType field, I would...

I'm a little lost when it comes to Access so please bear with me. I have an Inventory table and an Equipment Type table. Both tables have their own separate forms. If somebody changes the name of an Equipment Type in the Equipment Type form, I would like it to automatically update all the...

Is there a way to display the records found in a form on a report? I have a form which grabs the data from a parameter query. What I want to do is to display the records from the form into a report at the click of a button. Is this possible and if so, how do I do this?

I have a frame on a form and if you select a radio dial it will run the corresponding query and export the data to an excel file when you click on a button. My problem is that I also need it to check the data from the query first and if there aren't any records, show an error message and not...