Go Back   Access World Forums > Members List

 
pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about

pr2-eugin pr2-eugin is offline

Super Moderator

Visitor Messages

Showing Visitor Messages 21 to 27 of 27
  1. BrotherBook
    02-26-2013 02:19 PM
    BrotherBook
    Paul- I noticed you were able to help out some other people with their Access VBA to Outlook questions and I was hoping you might be able to help me out with this issue. I'm trying to add an attachment (from an access attachment field) to an outlook appointment my VBA creates.

    http://www.access-programmers.co.uk/...40#post1237140

    Thanks again for your help on some of my previous problems!
  2. boknoval
    01-16-2013 01:07 AM
    boknoval
    ((Hi paul, I may need your help once more.. I have put up a new thread. You may read it here: How to pull out data based on a search made

    I hope you could help me on this one. Thanks!)) -- PROBLEM SOLVED

    Awesome Paul! As always, you are a life saver!
  3. nur annie
    10-31-2012 05:48 PM
    nur annie
    Here is the problem:
    I have a form called "Search" that i want to display information with the control "Month". In my main datavase (info TBL) i have set a field name DOB which is set as Date/Time Data Type. In the Form Search the information will be displayed through a subform called as info TBL Query subform.
    I use a query in my Search form because the need to derived month value from the DOB field. In the query I set a expression as MONTH:FORMAT([DOB],"M"). The query return the value as i expected but it didn't show the value when I use it as a subform. The result i'm getting for the field MONTH in my info TBL Query subform is #Name?

    I know that I can declare a calculated field in my main table using Access 2010, but now i'm using Access 2007. Is there any method that i can use to manipulate the calculated filed in the query. u can check the attachment in the forum at the queries section.

    I really appreciate this
    Annie
  4. nur annie
    10-31-2012 05:48 PM
    nur annie
    Hi Paul.

    I really need you help, some opinion maybe, I've attached the database that i use as "try& error" tools. The previous attempt to upload my database failed so using this clone database will give u some ideas. The last time i tried to search value between the range for " Date From" & " Date To". i'm still didn't get the exact result for my search range and i try another method that is to use a query as to calculated value for month.

    I really appreciate this
    Annie
  5. RainLover
    10-14-2012 03:26 AM
    RainLover
    Paul

    I did not want to say anything in an open Forum so I decided to PM you.

    I started off explaining that input masks and formats really don't affect the storage of the data. There are exceptions to this especially when the input mask forced the entry of certain patterns. Telephone number can be forced to display as (02) 3456 8765 as each character is required and it must be a number. But dates are dates and are only stored as I mentioned in the post. Dates are simple once you understand the concept. If you want more info please ask.

    Now to your problem, and that is one of Normalisation. You have repeating Data with Mon, Tue, Wed, etc. This is said without seeing your actual database and is therefore just an educated guess. So reask your question in a new thread and see what others may say.
  6. nur annie
    10-05-2012 05:07 PM
    nur annie
    Hi Paul,

    i've tried to reduce the size of my file.. & still the file is too big to attach with this msg. any idea how i can deliver it to u? thanks

    Annie
  7. gmatriix
    06-11-2012 07:41 AM
    gmatriix
    Hey buddy,

    Do you think you can help me with this one?

    http://www.access-programmers.co.uk/...d.php?t=228015

    Thanks

About Me

  • About pr2-eugin
    Biography
    A fun, nerdy, enthusiastic learner & a passionate teacher of what I've learned. If you'd wish to contact me privately or throw a few cents for the help, please check my signature(email is encoded). Please no technical help, they belong to the Forums.
    Location
    Bournemouth, UK
    Occupation
    Database Developer/Admin
  • Signature
    Regards,
    Paul Eugin
    Help me fulfill my Wish List !!
    Windows 7 Professional, MS Access 2010
    ---------------------------------------------------------------------------------------------------------------------
    If the above post has helped you, please click the scales or click the 'Thumbs up'. Cheers.
    ---------------------------------------------------------------------------------------------------------------------



Statistics

Total Posts
Visitor Messages
Total Thanks
General Information
  • Last Activity: 07-16-2018 12:42 AM
  • Join Date: 11-30-2011
  • Referrals: 0

Friends

Showing Friends 1 to 10 of 22



All times are GMT -8. The time now is 12:17 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World