Data Entry - Not Always Taking In Database

Jul 27, 2006

I am having a problem where I have a form that I enter data into. Sometimes when I enter the information it will add a record to the table and sometimes it doesn't. It doesn't put the information in the table more times than it does.

I have tried to enter the information outside the form and it still does the same thing.

Do you have any suggestions of what I can do to fix this.

Thanks

View Replies


ADVERTISEMENT

Database Design And Data Entry Help..

Nov 29, 2005

Greetings.. I am attempting to teach myself Access but I am having trouble trying to figure out how to implement into my database the features I need my enduser to have.

Basically I am trying to create a Contacts database and I want the "form" that my end user enters data into to look like this (all examples are minimalist because I am looking for specific logical answers to solving my problems, not field suggestions):

Name: [textbox]
Phone: [textbox]
Email: [textbox]

Now I need to have Phone and Email each in their own tables, or in some way seperated so that I can retrieve a list of emails or phones without duplicates.

My initial attempt was to create the tables:

*key

NAMEtable
*Name
Phone (related to PHONEtable.Phone)
Email (related to EMAILtable.Email)

PHONEtable
*Phone


EMAILtable
*Email

Now the problem with that setup is that I cannot create a new entry into NAMEtable unless the specific Phone AND/OR Email are ALREADY listed inside their respective tables.

What I need to be able to do is give my user the ability to use a "form" with 3 fields, that will do the following:

Allow a new Name without a Phone or Email.
Allow a new Name WITH a Phone and/or an Email.
Allow a 2 different Names to have the same Email, but pointing to only 1 instance of that email in a different table.
(which it already does all if the Email and Phone already exist in their tables, I need it to be able to create new entrys into those tables from the form if they don't already exist). I also need to be able to enter in new Emails from a different form2 that dont have any relation to any persons in Name (which isn't a problem either at the moment since I just open the Email table and enter data).

I am unsure how to execute this first forms dilema though, I am assuming my database design is fine and it has something to do with some formality or code that I am missing to be able to do what I want. If so could someone help me out and make some suggestions? Or if my design is way off and there is a better way to be able to enter and store a Name, Email, and Phone from a form that relates back to a single contact and prevents duplicates then please let me know. Thanks

Also here is another post I made in a different forum but wasn't able to get quite the answers or help I was looking for.


"Name [textbox]
Email [textbox]

if the email the user is entering isnt already in the database it will not create a new row in email.email and then link contacts.email to that specific email.email...........

for example if

contacts NAME , EMAIL
row1 = bob , email.email row1
row2 = bobswife, email.email row1

email Email
row1 = bob@bob.com

then I open a form that will have 2 members, both pointing to the same email.

1 of 2
Name: [bob]
Email: [bob@bob.com]

2 of 2
Name: [bobswife]
Email: [bob@bob.com]

Ok, lets say I go to create a new member

I can do this just fine:

Try1
3 of 3
Name: [bobsson]
Email: [bob@bob.com]

What I can't do but need to be able to do is:

Try2
3 of 3
Name: [bobsson]
Email: [bobson@bob.com]

It will return an error stating that the email isnt in the email table. I need to know how to get Try2 to do what I want so that when I enter 3 of 3 my database looks like this:

contacts NAME , EMAIL
row1 = bob , email.email row1
row2 = bobswife, email.email row1
row3 = bobsson , email.email row2

email Email
row1 = bob@bob.com
row2 = bobsson@bob.com"

Anyways.. thanks again for any help.

View 2 Replies View Related

Forms :: Data Entry Into Database Though Form

Jun 18, 2013

I've just finished model of DB and it looks like this ( ERM.png )

Now I would like to insert some data into database though form, but if I for example add New contractor ( first name, last name ) with his location , it doesnt connect in table User-Location ... so it is not matched ...

View 2 Replies View Related

Database Taking Long Time

Mar 4, 2008

Hi there,

I have on MS Access database.which was working fine untill now but suddenly it started this strange behaviour.
When i open it it opens without any error but stays in the frozen state for like 5 mins means i cant do any thing or i cant click anywhere.

and after 5 mins it starts working fine.Does anyone have any clue abt this strange behaviour.

Thanks
Danny

View 5 Replies View Related

Modules & VBA :: Database For Data Entry - Update And Navigation

Oct 28, 2013

I have made a database for data entry, currently i have a challenge of getting it update and navigate.

On the form if the staff name is xyz it should only shows the records filled by xyz in form and navigate that records only. I am attaching the data base also....

View 3 Replies View Related

Taking Ownership Of Database-Access 2007

Dec 12, 2007

Just upgraded to Acccess 2007 and have ownership problem extracting queries from a 2002 db.

When trying to import into a new 2007 or export from the 2002, get "you have no permission" message

Have created a new user tried to change owner of the db, but no permission
File security looks correct in that I am owner of the file with full permissions, but Access doesn't recognize me as the owner

Tried logging in as admin, but it isn't the owner either

This is not critical, just very time consuming, this is a test project, but it would be nice not to have to rewrite about 30-40 queries and equivalent forms

Any guidence appreciated

View 12 Replies View Related

General :: Designate Unique Codes In Database During Data Entry

Jun 21, 2012

I wish to designate unique customer codes in my database during data entry.

For example;
Liz Stimp = LS1
Liz Stamp = LS2
Lyne Small = LS3
Lipo Suction = LS4

I have successfully linked the first and surname using a "Left 1st letter" in the expression but I do not understand how to add a 'unique' number to the code to give me the result I am after.

Expression so far is .....Left([First Name],1)+Left([Surname],1)

View 9 Replies View Related

General :: Taking User Input While Opening Database

Dec 7, 2012

In my database there are fields of type Date/Time, their default value is set to now(). But the problem is that those fields are automatically filled up by English system date. I want my own country's date format, without changing my system date format. So I decided, whenever database is opened it should ask for a date, so the user will give today's date and that date will be used automatically on those fields.

View 6 Replies View Related

Forms :: Data Entry Form To Add New Records To Access Database File

Sep 30, 2013

I have a data entry form to add new records to an Access database file called Claims. An auto-incrementing sequence number (SeqNbr) needs to be kept PER YEAR. If the user enters a date the sequence number pertaining to the year of this date needs to be incremented. The first record within a new year of course takes value 1.Records can be added at random for different years.

A simple SQL-statement can be made to determine the new sequence number:SELECT max(Claims.SeqNbr) + 1 from Claims where year(this.value) = year(Claims.EventDate)...this.value meaning the value of the date control in which the user entered the date.I need to return the new sequence number to another field on the form in which also the COMPANY CODE, YYYY and MM from the EventDate, the new sequence number and the USER INITIALS are concatenated.

View 4 Replies View Related

Taking Data From Another Table

Feb 16, 2007

Hi All

I have a quick query. I have a table with a Account Code and its relavant Account Name.

What im tyring to do is in a query or another table, which has 17000 rows of data and the account code has been used in each entry. What i'm trying to do is to be able to create another column where the relavant Account Name can be next to Account code in the query or table.

Could someone please help.
Thanks
Anna:)

View 2 Replies View Related

Taking Data From Forms Every Month

Nov 21, 2005

I have a database set up with charts which plot information about support for "quality" purposes.
I have reports that work out the percentages but i would like to be able to take the percentage figure (say on the 1st of each month) and add it to a graph which will then be able to show the figures from the last 12 months so i can see how well the support is performing.
Any help would be greatly appreciated

View 3 Replies View Related

Queries :: How To Trigger By Date To Create A New Entry In Database Based On Old Entry

Aug 6, 2014

I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.

Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.

View 1 Replies View Related

Modules & VBA :: Taking Data Form A Web Page

Aug 12, 2013

I am successfully using some code to open a web page and log in for me.

Code:

Dim ieApp As InternetExplorer
Set ieApp = New InternetExplorer
ieApp.visible = True

[Code] ....

The bit I am really stuck on and still after reading various posts and googling I cannot seem to get a bit of code to read a value from the web page.

<tableborder="0"cellpadding="0"cellspacing="0"class="linktable">
<tr><thcolspan="2">Status</th></tr>
<tr><tdvalign="top"style="width: 50%">
<divclass="fieldset"id="general_info">

[code]...

View 4 Replies View Related

Modules & VBA :: Opening New Form And Taking Data From Another

Jul 19, 2013

IThe db has a form called ClientFormNew which logs client details into a table called Clients.Each client has a unique client ID in the table called ClientID. Sometimes Clients call back for further information and we want to log that information into a related table called ClientHistory.Each record in the ClientHistory table has a unique ID called HistoryID which is the same number as the ClientID so these fields are related.

When a client calls back and the telephone adviser opens up the ClientFormNew form and discovers they have called before they need to click on a button called Client History which then opens up the ClientHistoryForm..I am struggling with the code to put on the Client History button as I want the new form to display the details of the clients first contact then allow details of the second contact to be added in a new row. Also the new form needs to show all that client past history which would be in the form of the following fields from the ClientHistory table.HistoryID, ContactDate, Name, ContactMethod, ContactReason, AdviceGiven, Notes.

View 2 Replies View Related

Taking Data From Table1 Modify And Output To Table2

May 25, 2006

hey all,

bit of a head scratcher for me here.

i have a database and i need to be able to read all the records from table1 modify the data and output the data to table2 and I would prefer this to be done via just one button in a form so im guessing VBA need to be used.

table1 consists of an ID field, firstname field, lastname field and date field.

table2 has ID field, full name field, date field

so i want to read the first and last name and date from table1, merge the first and last name and then output the merged names and date to table 2.

ive googled around and all ive come up against is recordsets but im having a hard time actually getting them to even work.

any help is appreciated.

cheers

Matty

View 6 Replies View Related

Forms :: Taking Data From Form And Placing Into Table

Nov 20, 2013

I have a form that I am inputting data into. I have been able to Clear the form. I have created an edit script and it brings the data from the table to populate the form. When I try to change the data in the form and run a VBA update to push the data down to the table I am having no luck. I can add/Delete recordswith no problems but I can't edit them and put them back in the table. I am novice and just learning the formats and scripting.

View 7 Replies View Related

Modules & VBA :: Taking Access Data On Button Click And Putting It Into Excel

Jun 23, 2015

I have a database that had some code that enabled the user to click a button and it would take information from one Access query or table and paste it into specific locations in Excel. This is important because the last worksheet has specific formatting in place.

If it didn't, I'd just use the transfer spreadsheet option and not even bother opening Excel at all with code.

I've got it working well except for the last part. The last query being copied has eight records and only one is being sent to Excel. Same code as the other queries where all of their data is going to the right spot in Excel with the right number of records.

Private Sub AM_Top_25_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "delete_ShortPartItems", acNormal, acEdit
DoCmd.OpenQuery "append_to_Short_Part_Items", acNormal, acEdit

[Code] .....

View 3 Replies View Related

Database With A Main Menu Form Containing A Button That Loads Main Data Entry Form

Jun 24, 2015

I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)

View 5 Replies View Related

Data Entry - Auto Fill Data For Exisitng Accounts In Records

Mar 9, 2006

First I would like to give thanks to all the knowledgeable folks here who have helped me with my DB to date. It is working and every one is very happy and I have learned a lot.

So now I would like to add some more functionality to this existing project.

My DB is for data input of customers for a drawing. It has the following fields: Id, account number, first name, last name, date/time, score1, score2.

I t is taking a great deal of time for the users to enter in hundreds of entries a day. Most of the entries are customers who are already in the DB. I would like to get the fields to auto fill the data for existing customers say after the account number is entered. So after you put in the account the name and any other pertinent data would shows up saving users from typing it in again.

The first problem I am having is that this is still a data entry form and I can’t figure out how to be able to see the account information and still add new data to the record? The new data is a daily score they get.

Second I haven’t figured out how to call up the customers information from just the account field.

I’ve googled this and haven’t found anything terribly helpful.

View 2 Replies View Related

Forms :: Create Data Entry Form To Input Data For Field

Mar 5, 2015

I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)

I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.

I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.

View 1 Replies View Related

Modules & VBA :: Datasheet Mode Form For Both Data Entry And Data Retrieval

Feb 9, 2015

I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.

<code>
DoCmd.OpenForm "PO_Practice Data", , , , acFormEdit, acHidden

Forms![PO_Practice Data]!PO_Name.Enabled = True
Forms![PO_Practice Data]!PO_Name.Locked = False
Forms![PO_Practice Data]!Practice_Name.Enabled = True
Forms![PO_Practice Data]!Practice_Name.Locked = False

[code]...

View 3 Replies View Related

Forms :: Saving Specific Data From Data Entry Form Depending On User Selection

Dec 18, 2014

I am trying to save specific data from a data entry form to a specific depending on what the user selects from a dropdown/combo box.

So if the user selects "test company from the combo box, that data (from that form) will save to the Test company data table.

View 5 Replies View Related

Forms :: Switching Form From Data Entry Only To Data Editing

Feb 18, 2015

My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.

My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....

As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.

View 5 Replies View Related

General :: Updating Table Data With Data From Preceding Entry?

Jan 5, 2013

My question is this: I have a table where I'm entering employees' hours worked. Basically, it's something like this:

ID WorkerNumberDateworkedTimeStartTimeEnded
121/2/201310:00:00 AM3:00:00 PM
221/3/20132:00:00 AM11:00:00 AM
321/4/201312:15:00 AM11:30:00 AM
421/5/201310:25:00 PM11:00:00 AM
531/2/201311:00:00 AM3:30:00 PM
631/3/201312:00:00 PM10:00:00 PM
731/10/20137:00:00 AM4:00:00 PM

I have a query that (easily) determines how many hours an employee has worked on any given day. What I can't figure out at all, is how to write a query that can figure out how much time an employee had off in between shifts.

Thus far I'm able to run a query that separates this main table into individual workers by their id numbers, but can't figure out how to determine time off between shifts - as the last hour worked one day, and the first hour worked the next day are on two different lines (they are two different table entries).

View 4 Replies View Related

Forms :: Display Existing Data On Data Entry Form

Sep 28, 2014

My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated.

i.e., Initial design data is entered first, when drilling is complete more data is added to a linked table, when drilling is surveyed yet more data is added to the second table.

What I want to be able to do is to query for a particular set of existing design data, display this on a form and on the same line enable data entry to other fields from other tables which are linked to the existing design data.

View 7 Replies View Related

Multiple Data Entry Clerks Inputting Data

Mar 5, 2008

I have a shared db where there is a requirement for more than 1 user to enter data in the same form and hence the same table. Up till now there has only been 1 data entry clerk so there has not been a problem.

Would accessing the same form by different users cause a problem, assumming they are inputting different records?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved