Search results

  1. T

    Link to Outlook Contacts - Add Fields

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

    Link to Outlook Contacts - Add Fields

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

    Link to Outlook Contacts - Add Fields

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

    Link to Outlook Contacts - Add Fields

    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?
  5. T

    Link to Outlook Contacts - Add Fields

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

    Adding a Field value as variable

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

    Adding a Field value as variable

    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)...
  8. T

    Adding a Field value as variable

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

    Adding a Field value as variable

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

    Totals: Group By & Multiply in a Report

    Got it. Thanks. Let me take another look
  11. T

    Totals: Group By & Multiply in a Report

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

    Totals: Group By & Multiply in a Report

    Thank you very much. I really appreciate your time.
  13. T

    Totals: Group By & Multiply in a Report

    I need it, yes. These are unitized values and are all between about +0.5 and +1.9 so I don't worry too much about odd results.
  14. T

    Totals: Group By & Multiply in a Report

    In The Totals function in a report (or a query) you can Group / Sum / Max, Min, etc .... but you can't Multiply. I need Multiply and cant find a work around
  15. T

    Totals: Group By & Multiply in a Report

    OK - so there is no Multiply option in a report for a series of values (same concept as Sum). I have a range of unitized values that need to be multiplied together. Well known issue but I can't find a straight answer out there. Any ideas?
  16. T

    Access front end with mysql back end

    OK - Im new to this so I'll have to read up on it all first. Thanks a lot for the help
  17. T

    Access front end with mysql back end

    DB - thanks - I read that if the queries stay in Access then all the data has to be called from the DB first and then calculated, which would slow down performance. I'll have a lot of data and some complex queries so speed will matter. Is this what you meant by the stored procedure route?
  18. T

    Access front end with mysql back end

    All - i hope you are well. Can anyone send a few good links for a newbie like me to convert my access db to MySQL? I assume the queries should be moved too so access is just the front end. Thoughts and links welcome.
  19. T

    Creating New Rows

    Can I ask one more (and hopefully last) question? I made the change to reference a query instead of table and I'm getting and "Compile Error Expected: End of statement" with the QuantityImpact field highlighted (as below) Here is the new code. All the Query and field names are correct...
  20. T

    Creating New Rows

    Thanks so much... yet again. I appreciate your time
Top Bottom