+ Reply to Thread
Results 1 to 4 of 4

input the date in a cell will show the month and year base in the database from ms access

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    6

    input the date in a cell will show the month and year base in the database from ms access

    hellow everyone !!!! (^__________^)

    plzz help me to my problem i have my ms access and ms excel which is connected each other

    => now in my ms access have a table name (tblMonth) has columns (year,MonthNum,StartDate,EndDate)
    HERE: sample in january(1) and feb(2)

    Year MonthNum StartDate EndDate
    2014 1 30/12/2013 05/01/2014
    2014 1 06/01/2014 12/01/2014
    2014 1 13/01/2014 19/01/2014
    2014 1 20/01/2014 26/01/2014
    2014 1 27/01/2014 02/02/2014
    2014 2 03/02/2014 09/02/2014
    2014 2 10/02/2014 16/02/2014
    2014 2 17/02/2014 23/02/2014
    2014 2 24/02/2014 02/03/2014

    => and for my ms excel has its columns (year,month,date) in this if i input the date that is base in the database range from StartDate TO its EndDate
    will automatically put the month and year which base also in my database (year,MonthNum)
    HERE:

    A1 B1 C1
    Year Month Date
    A2=2014 B2=January C2=01/01/2014

    (THIS PROJECT WILL USE VBA PROGRAMMING )

    ==> how can i do this ? plzzz i'm begging you guyz help me,... (^_______^)

    THANKS IN ADVANCE (^_____^) I REALLY LOVE U ALL
    Last edited by Frangine; 06-01-2014 at 10:50 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,262

    Re: input the date in a cell will show the month and year base in the database from ms acc

    I'm not understanding what you are attempting to achieve. How are your files connected. Is the Excel file a linked table to your database? Are there any queries in Access that are to return results to Excel? What does the term base mean in your explanation. It is not clear.

  3. #3
    Registered User
    Join Date
    05-21-2014
    Posts
    6

    Re: input the date in a cell will show the month and year base in the database from ms acc

    yes, my table in ms excel is linked to my database table(tblMonth) connected through vba ,..

    yes should return queries in my excel i use "select * from tblMonth" this query to my table in my ms excel...

    Year MonthNum SDate EDate
    2014 1 30/12/2013 05/01/2014
    2014 1 06/01/2014 12/01/2014
    2014 1 13/01/2014 19/01/2014
    2014 1 20/01/2014 26/01/2014
    2014 1 27/01/2014 02/02/2014
    2014 2 03/02/2014 09/02/2014
    2014 2 10/02/2014 16/02/2014
    2014 2 17/02/2014 23/02/2014
    2014 2 24/02/2014 02/03/2014

    ->then i use another table in ms excel => in this table were i can input a specific date base in the tblMonth in my database then will return its month and year...

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,262

    Re: input the date in a cell will show the month and year base in the database from ms acc

    This is not making any sense to me. Please upload copies of your spreadsheet (sanitized for any confidential data) and your database (sanitized also). Make sure to run a compact an repair on the database before uploading. You will also have to zip the database as this forum does not allow direct uploads of mdb or accdb files. You only need to have a enough records in both files to allow for showing your issue, not the entire file.

    I think that you may be trying to run a parameter query from Excel against a table in Access, but your explanation is very confusing and lacking enough detail to determine this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro or Formula to create Date range by getting input of month and year
    By indianhp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2013, 11:00 AM
  2. [SOLVED] display cell to show only Month/year to do sumif calc if today()= any day of month
    By fireguy7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 06:55 PM
  3. [SOLVED] Date to show only date w/o month or year
    By jazbath in forum Excel General
    Replies: 4
    Last Post: 01-09-2013, 10:08 PM
  4. [SOLVED] How to show yesterdays date without month year.
    By DKerr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2012, 10:17 AM
  5. [SOLVED] Function to Display Input Box, Retrieve Date, and Return Day, Month And Year
    By Authentik8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2012, 08:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1