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 on

1 Answer

  • 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

1 Suggested Answer

6ya6ya
  • 2 Answers

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

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

Tip

How to create a system folder in My Computer System folder like My Document...


How to create a system folder in My Computer System folder like My Document which appears in My computer are special folders which appear can not be deleted. Now if you want to create something like that, a folder which cannot be deleted!!!! . Here is how you do it to create a folder which cannot be deleted!!. It should work both in XP and VISTA.However a word of caution, If you don’t know about registry, either back up or don’t try this. I am not sure how to create a direct script for this so be cautious.
Step 1: Create a Unique Key
Open registry with “regedit” command on run window.
Navigate to HKEY_CLASSES_ROOT\CLSID\. Then right click and create a new key with value as {FD4DF9E0-E3DE-11CE-BFCF-ABCD1DE12345}
Now set the default value of this key to the folder name you want to use. Now your path will look like ( I will call this as parent key throughout the discussion) HKEY_CLASSES_ROOT\CLSID\{FD4DF9E0-E3DE-11CE-BFCF-ABCD1DE12345}

 
Step 2: Add Custom Icon to the folder
Now create a sub key under parent key.
Name it as “DefaultIcon”.
Set the default value of this to the path of the icon image you want to use.
If you dont specify your icon, system will take default icon.
Step 3: Adding attributes
Under parent key create another key with name as “InprocServer32′
Set the default value as “shell32.dll”
Again at the same level create another folder as “ThreadingModel” and set its value as “Apartment”
Same way create another key (under parent level) at the same level with structure as \Shell\My Folder\Command
Set the default value here as “explorer /root,c:\Blog Data”
This has to be same which you gave when you created the first key.
Step 4 Adding Handlers
Under parent key, create another key as \ShellEx\PropertySheetHandlers\ {FD4DF9E0-E3DE-11CE-BFCF-ABCD1DE12345}
Similar way another key is to added to parent key as “Shell Folder”
In this right click and create new binary value called as “Attributes” with value as 00 00 00 00.
Step 5: Settings to place in My Computer
Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows
Then to \CurrentVersion\Explorer\MyComputer\NameSpace\
Add the parent key which in this case is {FD4DF9E0-E3DE-11CE-BFCF-ABCD1DE12345}
 
Thats it, You are done. Try this carefully and I am sure there wont be any problem


on Dec 07, 2009 | Computers & Internet

4 Answers

I can not set up the parent control


Found this from my own research this appears to work (Either way epic failure by Toys R Us who had better issue an apology and provide some sort of compensation for this let down!!).......

I was just able to register and setup parental control from desktop browser after more than 2 hours trying different approaches. I then used that account info to login into tablet and activate controls. Here is what I did step by step.

1. When you try to activate your tablet it open page at this URL: (you might have to restart process couple times - site seems to loose info enetered in previous step)

http://mpf.profiltechnology.fr/wzdinit.aspx?guid=0099FXFX7X00-0&model=TABEO%208&app=darkcafe

You will have to replace guid value 0099FXFX7X00-0 with the actual value of your tabled ID - you should be able to see it in browser address bar.

2. Complete 4 step account setup wizard - in last step when it asks for "Child's firstname" enter unique Id there something like JoeDoe2009 - there seems to be some issues with unique names for app because when I enter my sons name it said it was already taken.

3. After Child's name was registered you will be redirected to payment page - you will have to enter Credit card payment info for $1 transaction (text says that you will be reimbursed for that later).

4. You should see page saying tablet was registered and You should receive email with your Id and password in clear text to email you used for registration.

5. Go back to tabled and tap on MobileParentalFilter icon (one that looks like flower) -- you will see registration wizard again -- on the bottom there is a link saying "ALREADY GOT ACCOUNT" - enter your email ID and password there - you will be taken to parental filter activation on tablet and all should be set.

That's it. Again be ready to restart this process from any point all over again because site is very slow and seems to loose your session.

Dec 25, 2013 | Toys R Us Tabeo

1 Answer

The radio link between parent and baby unit has been lost and even after going through the registration process detailed in the user's manual link is not being establsihed. I have also removed the bat


Hi there, i have the same problem and its just over a year old now, i got a new battery but it still wont link, and keeps beeping. Did you solve this problem yet?

Nov 15, 2011 | Motorola Mobility Mbp30l Digital Video...

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

2 Answers

The parent unit does not recognize that the nursery unit is on. all the correct lights are displayed on the nursery unit for normal function, but the parent unit display indicates that the nursery unit is...


Sounds like the units need to be paired. Start with all units off. Then turn on one of the parent units. Press and hold the menu button until it beeps. Quickly turn on the nursery unit and press and hold the button on the nursery unit that has the parent unit icon below it. After a couple of seconds the units will pair. Repeat this process with the other parent unit.

Oct 10, 2009 | Bebesounds Ac401 2p Angelcare Deluxe...

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

2 Answers

I need the code to remove parent contorl


id try calling your cable company and see if they can fix it.

Jan 22, 2009 | Home Security

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

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 Access 2003 (077-02871) for PC Logo

Related Topics:

218 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

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

Answer questions

Manuals & User Guides

Loading...