Hi, I'm using a vba procedure to load data from a text file into an access 2007 database. One of the fields in the text file is a representation of a date as 20070829 (29th august 2007). I need to know how, within my VBA code, I can convert this to a date type in order to insert into an access field...

Hey I need to run a query to show all orders that will be collected in the next 7 days, i have the dates in when the customer wants to collect but i need to show them in a simple query so I know whos comming. I have a query and just need the criteria, but i dont know it and really need to do it asap...

Hello: This should be simple. I have a table like this: myTable (PkDate, myInt1, myInt2, myInt3) PkDate: Primary key of type datetime myInt[1-3]: Int types Some sample entries to the table can be: 10/1/2007, 8, 12, 20 10/3/2007, 9, 24, 28 10/5/2007, 4, 8, 24 Now, I want the latest date for ANY number...

Hi, Perhaps you can help me. I am currently using a macro to export data into a spreadsheet, (using transferspreadhseet). When the data is exported the date field appears on the spreadsheet in short date format and I would like it to be in Medium. Is there a way around this please?

Newbie to NT: I would like to set up a MS DOS script that will check the contents of a TXT file and compare it to today's date. If the dates are different, then send out a email. Is there an easy way to do it without downloading software, i.e. blat? Thank you.

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

Please could someone tell me how to perform a comparison in the Visual Studio (2008 ) Query Designer against a Visual Foxpro Date field via OLEDB. I am trying to get a list of today's transactions from a visual foxpro 9 table into an ASP.NET (c#) web page. I have created a connection to the associated...

Hi, I’ve searched and found broadly similar questions to this, but none close enough for me to figure it out (rusty on Access these days). I have an MS Access database with a form in which the user selects a file through a dialog box and then clicks an ‘Export’ button. When they press the button qryABC...

How do you date stamp a calculated field and not use a form? Is it possible? Here is my dillema. There are two fields which a user can input ReviewStatus and ReviewStatusApp. If either field is = "Final", then overall status (calcualted field) will equal "Final". If both fields =...

I have a pivot table that has months going down the rows and salesperson across it. The data is the sum of sales for that month. How do I get another pivot table or within the same table that shows the year-to-date totals for each month? My data comes from a Access 2000 query. Thanks.