473,545 Members | 2,358 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

add data to different table in access database

1 New Member
I have a 3 tables in access database which is day-morning, swing-afternoon and grave-night. I want to save data based on the shift time for example I input 3:00 pm it will be save on the swing-afternoon table. is it possible? can anyone show me how to do it in vb?
Jun 16 '15 #1
2 1072
32,564 Recognized Expert Moderator MVP
Let me advise strongly that diving into this without having any idea of how databases work first is a very bad idea. What you suggest is a very bad approach that will lead you into deep trouble. I'm sure someone will be along to give you some good tutorial links - or you may be able to find some using Google.

The first main point is that this data should never be split across multiple tables. That's just a big request for problems.

PS. I removed the shouting for you. It's not polite and doesn't make you come across too well. It's also against the site rules of course.
Jun 16 '15 #2
1,107 Recognized Expert Top Contributor
Hey There,

Let me be the first to introduce you to Database Normalization: http://bytes.com/topic/access/insigh...ble-structures

The above is one of the Links NeoPa was referring to. In short it will explain to you why you should move the data you have in your three separate Shift Tables into one Table and include a column to record which shift the record belongs to. This will provide you a much easier way to write your Forms, Queries and Reports since you will only have to write them once instead of three times.

Not only that, the question that you are asking about will go away as you will only be adding data to one Table. The question will most likely be replaced by, how do I Filter the Form to only show one shift?
Jun 16 '15 #3

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

Similar topics

by: Norman Fritag | last post by:
Hi there, The Problem: I can't write data to an access database in a webfolder of a windows Prof 2000 machine, whereas the same web application runs fine under Windows XP. I looked into the windows security setting for the database and found that is set to deny write access! The deny setting applies only to the Windows Security Web...
by: jh | last post by:
The situation: A database is wanted. It's purpose is to show some co-workers' skills. Therefore I will need to make a database that contains names and the posts "skill1", "skill2", "skill3" etc. (YES/NO-posts) This should be easy; one table in a simple database, but... In the company we already have another database containing the...
by: choknut | last post by:
guys i am a newbie in vb.net programming and want to seek help regarding my current program..i have an existing access database and want to use vb.net as to generate a report.question is how can i access a certain data(say "account") in a table named "customers" so that when i click the "search" button on the main form, all of the data in...
by: handsomejay | last post by:
Good day, I have been trying to add a new record to the Access Database that has already been connected to the Visual Basic Application (Using Visual Studio 2005) that I have been developing, using the DataSource and the DataAdapter objects, though I'm able to add an Insert query and run it, but the record is not saved in the related database at...
by: 1064871 | last post by:
Hi How to insert Data in Microsoft Access database using VB.net regards adil
by: handsomejay | last post by:
Good day, I am learning C# and someone has given me a certain software to write for him. I have been trying to add a new record to the Access Database that has already been added to the a Visual C# Application that i created, After adding the datasource to the form, i tried to add a new record to the database. but when i click on the save icon to...
by: rajaaryan44 | last post by:
how can we transfer data from one access database to another databse . the table name is same for both the database . in one table some records are there (rs say e.g.) now another table has say rs+10 records . now i have to pass there 10 values to another table with same name . can anyone help me with this. i m usinf DAO . i wrote some codes in...
by: thludwig | last post by:
Hi all, im totaly new to forums and this is my first post ever to please excuse if the form isn't correct. I have big problems to understand the complete correlation of dataset, dataadapter and so on. My Exact problem: I have an access Database from where I want to read some data, give the user the possibility to change and write back to...
by: mousewonders | last post by:
Hi Guys, I am very new to VB. I am working on a project for class that will let people sign in to a fitness center and sign out. I have no clue what I am doing. I have searched and read and read and I can't seem to figure out how to insert data that I collect on a form I created into an Access database. I know I can do it if I drag and...
by: arianule | last post by:
Good morning i have been struggling to insert data into my access data base via textboxes on a webpage. The error is INSERT INTO syntax error but I am struggeling to pinpoint where the syntax error lies. this is the code I used string connString = @"Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + ...
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...
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. ...
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...
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...
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...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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
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...

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.