473,796 Members | 2,688 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Diary Schedule Insert

8 New Member
Does anyone know how I could take a weeks entries in a table and copy and insert the same entries into the same table but with the starting date a week on.
class_id class_dte class_start_tim e class_end_time class_name class_def_id
6 21/11/2007 13:25 19/11/2007 11:00 19/11/2007 12:00 Spanish 1
8 21/11/2007 14:44 19/11/2007 12:00 19/11/2007 13:00 French 1
9 21/11/2007 14:48 19/11/2007 16:30 19/11/2007 17:30 Maths 3
10 21/11/2007 15:49 19/11/2007 17:30 19/11/2007 18:30 English 1
11 21/11/2007 15:55 20/11/2007 11:00 20/11/2007 12:00 English Literature 5
12 21/11/2007 15:56 20/11/2007 12:00 20/11/2007 13:00 Metalwork 5
13 21/11/2007 15:57 19/11/2007 18:30 19/11/2007 19:30 Metalwork 5
14 21/11/2007 15:58 20/11/2007 16:30 20/11/2007 17:30 English 9
15 21/11/2007 15:59 20/11/2007 17:30 20/11/2007 18:30 Spanish 9
16 21/11/2007 15:59 20/11/2007 18:30 20/11/2007 19:30 Spanish 12
17 21/11/2007 15:59 21/11/2007 11:00 21/11/2007 12:00 Art 12
18 21/11/2007 15:59 21/11/2007 12:00 21/11/2007 13:00 Art 11
19 21/11/2007 15:59 21/11/2007 16:30 21/11/2007 17:30 Woodwork 11
20 21/11/2007 16:00 21/11/2007 17:30 21/11/2007 18:30 Woodwork 14
21 21/11/2007 16:00 21/11/2007 18:30 21/11/2007 19:30 French 14
22 21/11/2007 16:00 22/11/2007 11:00 22/11/2007 12:00 French 14
So that I could make a carbon copy of one weeks lessons and move them on a week.

Thanks in advance
Nov 21 '07 #1
0 878

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3091
by: JackV | last post by:
Hi All, I have a pure asp (Vbscript) page that manipulates data between MSAccess and SQLServer2000. I'm trying to use the Scheduler app on the IIS server to run this page nightly but there must be a better way of doing this. How can I make my code in to an object and install it on the server and have it schedule to run nightly?
2
10495
by: Mike | last post by:
Hi all, I am writing a database using SQL as the back end and Access as the front end. My project is to create a rota for when people have to work. The problem I have is setting up the tables so I can query them correctly. I currently have a staff table which holds the staff_id and staff_name fields. I have a worktime table that has the staff_id, date, start time, end time as fields. What I would like to do able to do is have a
2
2859
by: groups | last post by:
If you haven't read the book, nor watched the movie, "Harry Potter and the Chamber of Secrets". Harry Potter finds a diary with nothing written in it. When he starts writing in it, the diary erases what he just wrote. Then the diary itself writes a reply back on the same page. I've implemented a magic diary using a chatbot and AJAX and some cool scripting. Link to the magical diary:
1
1817
by: bigfella | last post by:
Hi Everyone, I am using the following code (many thanks for the code folks BTW) to generate 3 schedules in three tables one is a schedule with 7 day intervals and two are daily schedules. The two daily schedules seem to have out of sync dates at the start of each schedule. The dates look as if they may be dates from the preceding loop.
3
8744
by: tstutting | last post by:
Hello, This is my first post and I'd really appreciate any help I can get. Sorry this is so long but it's complicated. I'm a USAF Officer and I'm attempting to make a shared MS Access DB that contains Training, Certification and Scheduling of Crew Members. I've got most of the back-end done (Tables with Relationships) and I'm happy with the Training and Certification sections. I'm having trouble with the Scheduling Part. The Table is...
1
3348
by: jobs | last post by:
I have a growning list of stored procedures that accept a single string as a parameter. The list and parameters are maintained in a table with two columns. Some of the Stored procedures take hours to complete. procedures and the page come right back and recording infomation about the stored procedure (like a job number) that can later be used to report what stored procedures are still running.
1
1626
by: SandipAdhikary | last post by:
hello sir, I have faced a prob.how can i make a diary control using .net with c#. exactly microsoft diary control. explanation=: there is one calender control ,u have to click a cell of calender control, at that time a grid is open and and u have take some input on the grid ,this input save the database as well as show this input on the calender cell at the same time. just maintain the diary. just like microsoft diary. please help...
3
1906
by: assgar | last post by:
Hi I am having problem with my loping. I don't know if I have chosen the correct approach. GOAL: I need to insert into a table event types for a specific date range. The calendar the event type is displayed on is divided into 15 minutes time intervals
2
2041
by: ramdil | last post by:
Hi All I have a doubt regarding the scheduling a task in msaccess.I want to write a query which will insert into a temporary table from a exisiting table.I have written the insert query but i want this query to be executed automatically every midnight..How can i schedule it.I know about windows scheduler,but dont know can i schedule access querys.Should the scheduling job should be in the same machine where access has its querys.Thanks in...
0
9525
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10452
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10169
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10003
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7546
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5440
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4115
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3730
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2924
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.