Question about Microsoft Office Standard for PC

1 Answer

Restict closing the main form when some controls on the subform are empty

I have made a Form in Access 2000 which has Main Form & Sub Form. Main Form has (Header File) and Sub-Form has (Detailed File). Relationship between the primary key field of Header Table and Detailed Table is established with Casecade Update Related Fields and Casecade Delete Related Records. I want that whenever User entered all the inputs in Header file, he must enter necessary records in Detailed file also & if he fails to do so, an alert message is appear to ensure the same & focus is set to controls of sub-form. The main form (against Header File) has following fields: 1. Issued To: (Combo box, which has Departments name, to whom, material issues). 2. Issue Slip No. (Numeric Primary key field, which has relation to Sub-Form also). 3. Issue Slip Date 4. Remarks (if any) My main form name is : Issue Main Form My Subform name is : Issue SubForm Subform has following fields : ItemID & Quantity issued Now, please let me know to set focus on controls of sub-form, how we can write the syntex & at which event whether in main form or sub-form. The sub-form (against Detail File) has following fields: 1. ItemID (Combo box, parts from part master table which are in stock i.e. (Total Receipt ? Total Issues). 2. Quantity Issued (which has following SQL to run in the event of After Update). UPDATE Item SET Item.IssueQty = NZ(DSum("[Quantity]","Issue_Dtl","[ItemId]=" & [ItemId]),0); 3. Issue Slip No. (Hidden)

Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.


    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Posted on May 05, 2008


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

Error code 21

That particular error code is for a defrost overheat. The thing about that error code is that most of the time there is nothing wrong. The reason for this is there is a sensor that is located in the freezer and is connected to the control board located in the refrigerator. They are connected by three sections of wire that connect together instead of one continous wire. Over time these connections lose good connection, mainly because of exposure and in doing so the main control board thinks of it as a failure in the defrost system because thats the only purpose of that line. In the past sub zero would have us access the sensor, and folling the wire,cut each connection out and tie the line together with wire nuts to form a more solid connection. I want to say the wire is yellow but its been a while so don't quote me on the color.

May 17, 2012 | Sub-Zero 650 / O Bottom Freezer...

1 Answer

Pro form 995 motor won't turn on

Dear Sir:

You must do the following:

1) You must check the receptacle wall, for 115volts AC,60hz

2) If Not voltage 115 Vac, check breaker or fuse from the Panel( Main) or Sub-Panel for that circuit.

3) If there are 115 Vac, so proceed with the wires of the plugs, retigh conection and see if the contact of the plug is clean or oxide, ( clean with ethilic alcohol 100%) .

4) Check the Main button if there Voltage use the VOM( Voltimeter) , after check the push button Start , clean this .

5) If not work, check the relais and clean with ethilic alcohol 100% in the Board Controller, after check the Breaker.

6) If everything is o.k now proceed to Start the Motor.

7) In short proceed Step by Step with the logic for Troubleshooting.

Please reply is everything is o.k or you need more assistance, Sincerely . God bless you.

E. Cuadra

Sep 05, 2011 | Proform Exercise & Fitness

1 Answer

Module not found in Access 2003

Is it used as a subform in another form? Also does it have any events which are referenced by other forms?

Jul 08, 2009 | Microsoft Computers & Internet

1 Answer

Want to populate a form with data from a table, the Id number is keyed into the form and once it's matches with the Id in the table I want the other fields on the form to be populated with the data from...

Create a Form from the main table with a subform based on the other data you will want populated. You put the fields in the subform that you want populated from the main form. Go to the properties for the subform and select the data tab, In the data tab, select the Link Master Fields and choose the field you want linked. When you type the ID number in the main form, the other firlds you have in hte subform should populate from the data inthe table.

May 14, 2009 | Microsoft Access 2003 for PC

1 Answer

Tabs/sub-form in access 2007 form will not scroll down?

open the form in design view open the properties dialog box by right clicking in the general form area not in the gray area of the detail section. In the properties click on the format tab. In the format tab goto the default view and select continuous form. This should create a virtical scroll bar once a record in the data base.

Dec 30, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

How to compare a value in a subform with parent form's value in Dcount

Assuming that Process id is an integer, this should do the trick:

DCount("[stageid]", "Process Stages", "[Process id] = " & Me.Parent! [Process id])

Regards -- Joe (Access VBA samples)

May 01, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Access 2003 HELP PLEASE!

Sharon King:

Did you get this problem solved? I realize it is quite old, but I am willing to help if it is not solved. If it is, I would be interested to know what happened...


Feb 18, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

View Reports

Hi, There a couple of different way you could do this and I have put two lots of VB code below that you can modify and use. Firstly you create the Combobox list by choosing the option that you will type the values yourself, you then type in all your report names on each line. After that you can then go to the VB code editor and paste my code in and modify it by changing my report names, (Customers) etc to your report names. Make sure you choose the Combobox and the On_Click option in the VB editor to paste the code into.  I like the first method better which checks the value of the Combobox and then opens the corrosponding report in the maximised form. The second method does the value check before running an assigned macro to open each report. With this you must first assign macros to each report in Access.  Remember each of these bits of code must be placed between the "Private Sub" heading and the "End Sub" ending, and change the "Combo23" name to reflect your combobox too. If you need a hand just email me.

First Method
If Combo23.Value = "Customers" Then
    DoCmd.OpenReport "Customers", acViewPreview, acWindowNormal
ElseIf Combo23.Value = "Customers 1" Then
    DoCmd.OpenReport "Customers1", acViewPreview, acWindowNormal
ElseIf Combo23.Value = "Customers 2" Then
    DoCmd.OpenReport "Customers2", acViewPreview, acWindowNormal
End If

Second Method
If Combo23.Value = "Customers" Then
   DoCmd.RunMacro "Macro1"
ElseIf Combo23.Value = "Customers 1" Then
    DoCmd.RunMacro "Macro2"
ElseIf Combo23.Value = "Customers 2" Then
    DoCmd.RunMacro "Macro3"
End If

Oct 28, 2007 | Computers & Internet

1 Answer

Linking Calculated Totals from subforms to the main form.

Hi Raul from your description it is very unclear what you are trying to do. First we need to know what information is on the first form, second unless you are trying to do a subtotal of all orders in the subform there is no real need for you to create a subform. Now if you are trying to create a subtotal form for all records, you will have to set it up in the record source of that subform with group by: 1. Right click on an empty space on the subform 2. Click on properties 3. Choose your table(or query) which is the record source of the main form. 4. Select Payment and items(or what ever you are trying to calculate). 5. Press the group by button 6. In totals instead of group by choose sum. 7. Exit and save 8. Now when you will select the control source you will see "sumofpayment" etc... just select them for each textbox. 9. To create the third text box you will have to use the Expression builder and just do [textbox1]-[textbox2] * for some reason the nz function does not work in this case. I hope that helped you I will be able to give you a better answer if you give me more details... Let me know what happend Good luck Daniel

Sep 02, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

434 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18417 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides