in
All Tags » VBA » date (RSS)

Browse by Tags

  • Saving a filename with the week number of the last sunday

    I'm using this snippet to determine the last sundays date, based on today but I need to save the week as part of filename i.e. that Sunday (22/06/08) lies in the 4th week. so saving it as Junewk4.xls Code Snippet: 1: 2: P = Weekday(Now(), vbMonday) P = Int(Now()) - P --> Open in New Window Select...
    Posted to Access Coding/Macros (Forum) by microsoft on 02-17-2010

  • Need to use VBA to check for NULL Date in a Recordset

    I am using VBA to compare two recordsets, and I am having trouble working with the Date Values in the recordset. I have been all over the net looking for some sort of solution, but I haven't been able to find one yet, so I now turn to the Experts. The code is essentially: Set rs = Currentdb.OpenRecordset...
    Posted to Access (Forum) by microsoft on 08-27-2009

  • Excel DateTime-  VBA to Concatenate and convert strings for date Comparison

    I have some data on an Excel Spreadsheet that is cut and pasted from another app: 1. a cell with the year as a string, for example "2004" 2. a cell with a Month as string, for example "June" 3. a cell with the hours and minutes in 24 hour format, ie "23:30" (this is recognized...
    Posted to Excel (Forum) by microsoft on 08-19-2009

  • Excel VBA - Date Functions

    Hey, I have a problem. I have a function which allows me to exclude weekends froma date calculation routine. I have been trying to filter in set holidays to it but there seems to be a problem. Whenever my program runs the line to calculate christmas it goes into my If statement even though today is not...
    Posted to Excel (Forum) by microsoft on 08-08-2009

  • finding the latest date in record and it's name using VBA?

    I have 10 fields in my table, each corresponding to a date that a department got this particular job. What I want to find out is the latest date field (last department that had this job), and the name of the field. Finding the name of the field is the hard part for me. finding the latest date itself...
    Posted to Access (Forum) by microsoft on 07-27-2009

  • CHANGE VBA DATE FORMAT TO DD/MM/YYYY

    VBA seems to think in 'American' when dealing with dates. Is there any sort of a 'regional setting' to default to dd/mm/yyyy? John
    Posted to Access (Forum) by microsoft on 07-19-2009

  • Date Functions in VBA

    Im new to Access 2000 and VBA and am trying to work out how to use various date functions, yet apart from using very basic ones such as Date. I would like to use the month function but i cannot get it to work. Even cutting and pasting in the example code from the help file does not work when i run the...
    Posted to Access (Forum) by microsoft on 07-17-2009

  • Access Database, VBA: Need to capture last update date of Access databases

    My project is to determine the Date Modified date of several hundred Access databases. This is the date which appears in detail view of files and folders in Windows Explorer, as well as in the Database Properties window. How could I determine and capture this date to append to a table using VBA code...
    Posted to Access (Forum) by microsoft on 07-10-2009

  • Access 2003 - VBA code for date criteria

    Hi Experts I am busy creating a Access 2003 DB. With a lot of help from The Experts off this site. We have manage to create a report section in my DB. With that said, we also manage to setup a date criteria for my reports using VBA. Which by the way, I dont know anything about, still in the process...
    Posted to Access Coding/Macros (Forum) by microsoft on 07-06-2009

  • Excel VBA - Date Field To String Cell.Value and Cell.Value2 not working

    I have a cell field on a workseet that contains a date value. When I use the .Value property of the cell to return a string I get: ######### and if I use the .Value2 property I get a number like 38076 or 38351. How can I return the date value of the cell as a string? bd
    Posted to Excel (Forum) by microsoft on 07-05-2009
Page 1 of 2 (16 items) 1 2 Next >