473,327 Members | 2,069 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Date stamp on tables

Can anybody help to create code which would
create new table from linked table and additionally will add date
stamp for the name of new table? For example tblHello is linked table
and the code would create a table tblHello311204 at the 31st december
of 2004.

Be well,
Ivars
Nov 13 '05 #1
1 2418
You could run a Make Table query.

strSQL = "SELECT Table1.* INTO tblHello" & Format(Date, "ddmmyy") & " FROM
tblHello;"
CurrentDb.Execute strSQL, dbFailOnError

For sorting purposes, you may prefer "yymmdd". This will sort these tables
chronologically in the database window. Since you said this would be run on
the 31st, I used the Date function. You could also specify a particular date
if you wished. This will also include the data from the linked table.

Now, for the real question. Why are you doing this? If you're just wanting
to segregate items performed during certain months, then it would be better
to have a date field in each record that tells you what date it was
performed and use a query to limit your results to the desired date or date
range.

--
Wayne Morgan
MS Access MVP
"alpha_male" <al********@inbox.lv> wrote in message
news:64**************************@posting.google.c om...
Can anybody help to create code which would
create new table from linked table and additionally will add date
stamp for the name of new table? For example tblHello is linked table
and the code would create a table tblHello311204 at the 31st december
of 2004.

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Don | last post by:
Hi all, With regards to the following, how do I append the datetimestamp to the filenames in the form? The files are processed using the PHP script that follows below. Thanks in advance,...
0
by: alpha_male | last post by:
Thank you, Wayne, for your answer. That was exactly what I needed. There was tiny mistake strSQL statement (Table1.* should be tblHello.* ). To answer your question why I need this. I have table...
6
by: Mike Charney | last post by:
Is there a way to check a files date and time stamp from VBA in access. I have a need check a date stamp on a file that I am importing. Thanks in advance, Mike m charney at dunlap hospital...
5
by: Des | last post by:
I have to do an events calender for a church. The events display will be limited to that week. If someone went in today Wed 24th I want to display 21st to 27th. I dont want any code samples, just...
3
by: phried1 | last post by:
I have created a form and inserted the following tables: Date Entered Time Entered Date Modified Time Modified Essentially how and where can I have these dates and times recorded so when the...
1
MitchR
by: MitchR | last post by:
I have created a text box and scripted it to receive a line of text and current date upon completion of a scripted event. My question is this. I need to script this text box and date stamp to...
4
by: SilentThunderer | last post by:
Hey folks, Let me start out by letting you know what I'm working with. I'm building an application in VB 2005 that is basically a userform that employees can use to "Clock in". The form...
1
omerbutt
by: omerbutt | last post by:
hi there i am making a page where customer can edit his current order, the tools i am using are mysql and php i am using 2 tables for this 1.rage_uk_bulk_order 2.rage_uk_bulk_order_products i...
5
by: Lewe22 | last post by:
I have a table with a date stamp on it. unique_id dist_created_date 1 01/06/2008 2 01/06/2008 3 05/06/2008 4 22/06/2008And a table with...
16
by: W. eWatson | last post by:
Are there some date and time comparison functions that would compare, say, Is 10/05/05 later than 09/22/02? (or 02/09/22 format, yy/mm/dd) Is 02/11/07 the same as 02/11/07? Is 14:05:18 after...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.