Search results

See the highlighted location

Got Compile Error: unexpected variable or procedure, not module. I changed all the Doubles to Variants and got the same thing.

All - Lets try this one step at a time so I am sure to not bother you too much. This is the Module - does this part look OK for a global function? Option Compare Database Public Function ReturnCalc_NetZero(Pos_Market As Double, Pos_Market_PriorDay As Double, _ ReturnImpact_FlowNet As...

thanks for your help guys. DBGuy - sorry I misread your note. I'm very dyslexic so I miss those things sometimes. Im still poking around with this.

It does. I'm still getting hung up somewhere. The Module now has this: PLEASE USE CODE TAGS Option Compare Database Public Function ReturnCalc_NetZero(Pos_Market As Double, Pos_Market_PriorDay As Double, _ ReturnImpact_FlowNet As Double, ReturnImpact_FlowNetTiming As Double) As Double...

Sorry to have to ask this - I'm sure you will shake your head but I'm going to struggle to find the answer. The Function is this: Function ReturnCalc_NetZero() As Double ReturnCalc_NetZero = ([Pos_Market] - [Pos_Market_PriorDay] - [ReturnImpact_FlowNet]) / ([Pos_Market_PriorDay] +...

TY let me give that a try

That's sort of my question. What is the way to do it? If converting it to a function is the right answer, then no, have not tried that yet.

Hey All, Easy one for you. I have one long formula that applies to about 15 different queries. I'd rather give it a Name and then reference the name in each query instead of using the entire formula 15 different times. The formula in each query always references the same field names, so it is...

I need to add fields to the linked database function. The interface does not send all of the outlook contact fields to Access, e.g. Home Phone and Notes. If your code is more of a batch process it may not work for what I need, but obviously I would take a a look. Really appreciate the help.

We have the normal Outlook/Cellphone syncs facilitated by our network. In Access' link to Database you can link directly to OL contacts and the sync is real time, if you update from Access or from outlook. the outlook to phones is through the email client.

Id prefer they were in sync so Outlook and our phones have all the up to date data. Im trying to use Access as a CRM. Some of their tools and DB's are good but I need some tweaks.

Thanks very much Joe. I will try this a bit later today. Does this code keep Outlook and Access in sync real time (both ways) or is it more of a batch pull and load of data?

All, Hope this finds you well. I have a DB linked to Outlook contacts, but not all of the Contact fields are being pulled in. Anyone know how to change the Outlook fields being pushed/pulled? There is a decent Contacts DB template, but the interaction with Outlook is not linked, so the data...

Sorry I could not translate it to what I need. This sort of started with what felt like a simple problem with defining and adding a variable. I really appreciate everyone's time.

Thanks Maj - can I ask a favor - I want to make sure I don't stumble around for 4 hours trying to translate this. Once I can see it done correctly it will help me with other code I need to write. Here is specifically what I need: As example - see the attached spreadsheet Table = Query Test 1)...

Thanks for the quick note back. Sorry for my shortcut post... When I get the variables figured out the values will be multiplied together, not added. I was adding to start, just to learn how this all worked. If there is a function that grabs a group of values in one field and multiplies them...

OK so just learning here... getting past a few early hurdles will really help. Easy one for you pros! In Table [QueryTest] there are 20 rows of data. I want to add each of the 20 values in field [MarketValueImpact] together to get one cumulative value, using a loop. The code breaks at the...

Got it. Thanks. Let me take another look

I just took a look. I don't think that is what I need but I do expect some sort of VBA code is the answer. Unfortunately I'm not a coder. To make this as clear as possible, the attached spreadsheet is what I need the math to do. See the highlighted column.