Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

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

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

if I run this from the subform, I get the message "object does not contain the autamation object "Me.Parent![process id]"
but i can get value of Me.Parent![Process id] in the watch table

Posted by pushjil on

Ad

1 Answer

Anonymous

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 39 Answers

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)

Posted on Feb 07, 2009

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

The 2 units are not pairing, the parent unit just continues to flash, despite running through the re-pair process


there is a very important step missing from the previous instructions.

--------------------------------

turn both the nursery and parent units off.
turn on the parent unit.
hold menu for 5 secs until it beeps.
turn on the nursery unit.
press the 'clear' button at the very top of the nursery unit that is part of the halo where it meets the white plastic of the unit.
the parent unit waits for the signal then pairs.

--------------------------------


every other guide i've found misses out this critical part of the process for some reason and i was just about to give up until i saw a guide on the angelcare facebook page linking to youtube showing 'extra features' of the angelcare monitor.

Sep 05, 2011 | Angelcare Ac401 Single Baby Movement Sound...

Tip

Windows error messages


"Operation has been cancelled due to restrictions in effect on this computer"

start >run>regedit
go to: REGEDIT - registry editor
When in registry editor: HKEY_CURRENT_USER – right click for permissions
Advanced Security Settings under 1st tab permissions
You will probably get this error message, "You can't remove restricted because this object is inheriting permissions from its parent.
To remove restricted, you must prevent this object from inheriting permissions. Turn off the option for inheriting permissions, and then try removing RESTRICTED again.
· Unclick: include inheritable permissions from this object’s parent
· Windows security warning: options to add/ remove/ cancel
· Click Remove inherited parent permissions
Denied all access
Continue – delete restricted
Once removed,
Follow this path in registry editor:
HKEY_CURRENT_USERS\software\classes\.html
Right click (Default)
Change value data from (in my case Chrome – it could be Firefox as well):
From: ChromeHTML To: htmlfile
From: FirefoxHTML To: htmlfile
Repeat steps for .htm, .shtml, .xht if they exist
RESTART COMPUTER





on Feb 07, 2010 | Computers & Internet

1 Answer

I have Windows Vista and I cannot load Facebook now. I get the following error message. Also, I have tried installing Internet Explorer 9 three times and when I do, it does not work (will not bring up...


You need to update your plugins Adobe Flash player, Java, Quicktime, Shockwave flash player, and Microsoft Siverlight then it should work. I have attached the link for Adobe. Let me know if can help any further, Thanks for using FixYa



http://www.adobe.com/support/flashplayer/downloads.html

May 16, 2011 | Microsoft Internet Explorer 8

1 Answer

Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0) Timestamp:...


restart pc,Have any toolbars or new sofware been added recently? If so and you are using Win XP you may want to try a system restore to a previous point before the changes were made or uninstall the toolbars completely. Also disabled all Pop-Up blockers to see if that has any effect.clean up ur registry using reginout

Dec 18, 2010 | Microsoft Internet Explorer 8

2 Answers

Webpage error details


100% working IDM fake key block problem
http://atips4pc.blogspot.com/2012/02/how-to-solve-idm-fake-key-serial-number.html

Mar 16, 2010 | Microsoft Internet Explorer 8

2 Answers

Process oil accumlation on the last stages of a centrifugal Comp.


hi when the compressor is not running the levels should/must be the same when it is running the stages push the levels up in the last stages hope this helps merlin v12

Jun 02, 2009 | Air Tools & Compressors

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

3 Answers

I CANNOT INSTALL ADOBE READER 9.1 ERROR MESSAGE 1402 APPEARS


Do the following solutions first of all please remove all previous versions of Acrobat, and then reinstall.
1. Choose Start > Control Panel (Windows XP)
2. Double-click Add Or Remove Programs.
3. Select Adobe Acrobat [version] and click Remove.
4. When prompted, confirm that you want to remove Acrobat.
5. Repeat the above procedure for all installed versions of Acrobat.
6. Restart the computer, and then reinstall Acrobat.
Now, perform the steps below during Acrobat Reader installation. The Administrators group listed below is the default local administrative group for Windows XP.
  1. Write down the path to the key referred to in the error message and leave the installation running. For example: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.pdf\PersistentHandler.
  2. Choose Start > Run, type regedit in the Open text field of the Run dialog box, and then click OK.
  3. Navigate to the parent of the key referenced in the error message. For example, for the key HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.pdf\PersistentHandler, open (double-click) HKEY_LOCAL_MACHINE >SOFTWARE > Classes > .pdf.
    Note: These steps may vary slightly depending on the path in the error message
  4. Right-click on the parent key and select Permissions (HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.pdf).
  5. Verify that the Administrators and SYSTEM is present and that Full Control is selected under the Allow column.
  6. In the Permissions dialog box, click Advanced.
    cid:1f55f5d78f3846839533f8a85e395973@joanne
  7. Select the Administrators group (1) and "Replace owner on subcontainers and objects" (2). Note: Select the current administrator account if the Administrators group is unavailable.
    cid:3ce74f38956e4dfcae487444ce8f86c9@joanne
  8. Select both "Allow inheritable permissions from parent to propagate to this object" and "Reset permissions on all child objects and enable propagation of inheritable permissions," (1) and then click the Owner tab (2).
    cid:be8ff9254ad94f29bec91706f67dc76b@joanne
  9. Click OK (3) in the "Advanced Security Settings" dialog box. Windows will now reset the permissions for each child object to correspond with its parent.
  10. Minimize the Registry Editor and click Retry.
    • If the error reoccurs with the same key proceed to Solution 4.
    • If the error occurs with another registry key repeat Steps 1-10 using the new registry key.
    • If the error does not occur finish the installation following the on screen instructions and exit the Registry Editor.
Please let us know how it goes.

May 06, 2009 | Computers & Internet

1 Answer

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


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!

Oct 03, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

Related Topics:

240 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Lee Hodgson
Lee Hodgson

Level 3 Expert

4810 Answers

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

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

Answer questions

Manuals & User Guides

Loading...