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

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

DX38BT motherboard wirer hook up.


http://www.intel.com/support/motherboards/desktop/dx38bt/sb/CS-028327.htm

Click on the blue - English Product Guide [ PDF ]

After you click on the above file name it may take up to 30 seconds, before the first page comes up.

Connecting to the Internal Headers
Page 50 for the PDF file page number. Figure 27. Internal Headers

The front of your computer is the Front panel.
The area of contact pins on the motherboard, that the main wires from the Front Panel go to, is the Front Panel header.

Item I in Figure 27.

Detailed connections on Page 54.

For additional questions please post in a Comment.

Regards,
joecoolvette

Sep 23, 2012 | Systemax Venture PC Desktop

3 Answers

Hi, I have a large video file which is an .MP4 format but i think it is is corrupt in some way, is there someone who can help me recover the data? rob


Hi There, Usually, file becomes corrupted may due to a glitch in the operating system, improper file saving procedure, system crash or some dangerous computer virus. So, it can not be access as normal. However, Digital Media Recovery could solve all these similar problems, help you to repair the corrupt/damage MP4, AVI, MPG, MOV files.
You Can Disk Doctor Recovery. It could repair the corrupted MP4, AVI, MPG, MOV as well as other image, RAW photo and audio files. thanks

Apr 28, 2011 | Televison & Video

1 Answer

Can u plz mail me tha easiest way to use Ms Access, like Creating relationship, with the table, creating form, query etc.


In general you initiate this process by pressing the "Relationships" button on the MS Access toolbar. It is the button with three small boxes arranged in a triangle shape.
rowell_randy_0.jpg

When it first comes up it will give you the option to add tables. You can add any set of tables including the possibility of adding one table more than once (you would do this if you wanted to create a relationship between fields in the same table).

Once you see the tables you're interested in, you simply drag the field from one table over a field in another table. The fields should be those that will define the relationship. Once done, you should see an Edit Relationships window. You can get back to the Edit Relationships window later by double clicking the line in the relationships window.
rowell_randy_1.jpg

MS Access does a good job of figuring out the relationship type. For example, if you match a field in one table, that is not a key, with a primary key in another table, Access will make this a Many-to-One relationship.

This can become a very deep subject. Hope this at least gets you in the right direction.

Dec 18, 2010 | Microsoft Computers & Internet

1 Answer

Trying to find interal connectors 2-1 pin audio spdif on a emachine 1831-05. motherboard is mcp73vt-pm


It has been stated from my sources, that the ECS GF7050VT-M5 mobo, is the same as the ECS MCP73VT-PM, with a slight difference.

The difference being that the MCP73VT-PM mobo is based on the Micro-ATX form factor, and the GF7050VT-M5 is based on the ATX form factor.

[ Micro-ATX form factor size is 9.6 inches by 9.6 inches. 9.6 inches is approximately 9 and 9/16ths inches. It's also 244mm by 244mm.
ATX form factor is 12 inches by 9.6 inches. 305mm by 244mm ]

ECS MCP73VT-PM,

http://www.e4allupgraders.info/dir1/motherboards/socket775/ecsMCP73VT-PM.shtml

ECS GF7050VT-M5,

http://www.ecs.com.tw/ECSWebSite/Products/ProductsDetail.aspx?detailid=858&CategoryID=1&DetailName=Manual&MenuID=1&LanID=0

To the right of the subheading - Download, left-click on the server location nearest you.
[Taiwan, USA, Europe, China ]

This is a PDF file download. (Motherboard Manual) May take a few seconds before you see the first page, and additional time for the file to fully download.
Suggest you let the file download all the way, before looking through it.

I'm also looking at an ECS MCP73VT-PM on Ebay, as well as the PDF motherboard manual for the ECS GF7050VT-M5.

Motherboard oriented so that the Processor is to the top, ram memory slots to the right, and the orange PCI Express x16 slot to the bottom, the SP/DIF header on the GF7050VT-M5 is located to the left of the PCI Express slot.

From the poor view on the Ebay link, the MCP73VT-PM also seems to have the SP/DIF header in the same location, but clocked differently.

The header is clocked perpendicular to the orange PCI Express x16 slot, while on the GF7050VT-M5 the SP/DIF header is parallel to the PCI Express x16 slot.

The header is 4 pins long, with 1 pin not installed.
Pin 1 is marked on the motherboard.

Pin 1 is SP/DIF Digital Output
Pin 2 is +5VA ( 5 Volt analog power)
Pin 4 is Ground

There is no Pin 3.


Apr 06, 2010 | Computers & Internet

1 Answer

Error occur during compiling,unable to open a header file


The compiler is attempting to access the iostream header file and it either cannot find the file (not in the default location or it has been told to look in another location where it doesn't exist), or the file security is set so the current user does not have read access to the file.

Apr 15, 2009 | Computers & Internet

1 Answer

Data From Table Auto Fill


You need to create 2 tables. Create one table with just the Center Number, County and Center fields, using the Center Number as the primary key, lets call this table Center. Then create the other table with all the other fields you need, lets just call it the Main table for now.
Then create a relationship between the Center table and the Main table using the Center Number for the relationship. The relationship should be a One-to-Many from the Main to teh Center table. When creating the form, you take the fields from both tables. When you input the Center Number, the County and Center should be automatically filled in.

Apr 08, 2009 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Storage of MS-Access 2007


(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 default.aspx?assetid=za100776681033 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

Jan 16, 2009 | Microsoft Computers & Internet

2 Answers

Wizard unable to create form


i had this problem and it was because a computer class was installing multiple kinds of access on one computer. they wanted to teach all of them, but are now screwing them all up. ha.

Nov 10, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Header file use


hi
briefly defining header files are those files which contains the declearations of all the pre-defined functions you use in a C program, like printf,scanf, and all that.

Various header files in C are:
stdio.h
conio.h
math.h
and many more.
to get a detailed information go to the following link: http://en.wikipedia.org/wiki/Header_files

Jul 21, 2008 | Computers & Internet

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...

smartsolve

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

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

445 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

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

Answer questions

Manuals & User Guides

Loading...