Search results

Can Anyone help???? Please???

I tried that. It works but there are a few problems. If I fill out the main form and not the sub form, It will allow me to close out and save. There will be no corresponding record in table two. How can I prevent it from not saving when both forms are not filled in completely?

Hello I really need some help here. I have a New Records form which includes a MainForm and a SubForm. The main form has data from table1 and the subForm has data from table2. I need to make sure All fields in the MainForm and SubForm is Entered in before closing/Saving. Can Anyone help? Thanks.

I have it set up by main form has table one information. I have a subform embedded in the mainform with table two info. I want to have all fields filled in mainform and subform or it cannot save.

Thank you sooo much. That is exactly what I am looking for. I am sorry I am new to access you you be able to help me further by showing me how to do this in detail? Thanks again.

Bascically what is going is this: For one table if a record is entered in... it needs a corresponding record in the other table. Vice versa. It cannot exist unless it you enter in records in both tables. I don't want it to save unless it has data in both tables.

All I really need some help. I have two tables: Table 1 Table 2 There is a one to many relationship here. One in table 1 and many in table 2. When I add in a record in table 1, I need a validation script/key that won't allow adding a record to table 1 without a corresponding record in...

How do I use this code? where do I enter it in?

I have five fields in a single form. I want to be able to allow no deletes to all of them, the ability to edit only one of them and the ability to add records to all of them. is there a way to do this? Thanks.

Could you show me or go in more depth as to how I would capture the time and user? Same thing you did?

How would I go about making a macro to create a date/time of the time a record was last modified? I would want to record this date/time within the same table in its own field. Thanks.

I set the form source to the query mentioned above. Works great. However, I have two different search boxes for two separate criteria. (I will probably have to use two different queries) Is there a way to get around this. Thanks Again

Thank you all!

With this code. How do you make the data open in a pre-made form?