Hi all,
I have a form with a list of contact names. I would like to add a button
next to each contact name to open another form that contains Only details of
the that contact.
Name
Button John Lerch
Button Ali...
Hi all,
When I open any of my databases I get the following message:
Opening C:\FileName
This file may not be safe if it contains code that was intended to harm your computer.
Do you want to open this file or canceal the operation?
Canceal Open
Does anyone know how to paypass this...
Hi everyone,
My boss wants me to go around the office and check our staff pc's for
programs/software that should not be there like (firewalls, music file etc..).
Anyone have an idea what programs/softwares to look for that my harm the
computers? I have no idea where to start.
Thanks in advance
skip,
I think I know why it's pulling the 0.
In the excel sheet there is more than one computed fee cell.
one in F40 and it equal 0 and the other one is the one I need to pull wich is F57 and it equal 2710.06
I think this is why we're getting the 0.
Hi Skip,
It did not work. Before you add the new line this is what got:
PlanID Participant count Computed asset Computed fee
1231 130 1445365.99
169 27 2388263.51
AAM 27 4067256.32
New Code:
PlanID Participant count Computed asset...
Amazing. You're genuis. My friend is a programmer but He couldn't do it. thank you so much.
I need to ask one more thing.
I need to add another field called computed field. I played with the code little bit but it did not do it. The field Computed Field heading was added to the sheet but...
When you type A4 in the formula you get:
Plan ID: 1231 Artemide, Inc. 401(k) Profit Sharing Plan
G40 returns 130
A54 Returns Computed Assets
F54 Returns $1,445,365.99
A40 returns Participant count
I did not think it was going to be easy. I have never done anything like this before that's why I was asking if anyone knows of a program to help.
When I put G To H I meant G:H, or A to L it means A:L
Key Identifier will be Plan ID
Plan ID is in Cell A4:L4
Participant count is in A40:C40...
Thanks for your quick reply
Plan Id is in Column A to L
Participant count is in Column A to C
The amount (130,..) is in Column G to H
Computed Assets is in A to D
The amount ($1,445,365.99) is in F to H
I am not sure what you mean by these questions:
What is the key identifier?
How will you...
I have an excel sheet that contains random data. this is an example of the excel sheet:
Plan ID: 1231 XXXX, Inc. 401(k) Profit Sharing Plan
Report period: 4/01/2006 to 6/30/2006
Activity fees are paid from plan assets:
Distribution fee amount: $0.00
Count: 1
Amount due: $0.00...
Hi Everyone,
Does anyone know a program to help me export data from excel to Microsoft Access?
The data in excel is not in row/Column format.
Thanks in advance
dean
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.