473,383 Members | 1,801 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,383 software developers and data experts.

Keep form from adding new record in table

I have a simple DB that calculates number of hours to use as a lookup for license requirements. It consists of an EmployeeInfo table and a calculation query to generate the hours based on workload proportions. I have a form to enter an employeeID and it runs the calculations fine. However, if you enter an employeeID that doesn't exist on that form, it creates a new entry in the EmployeeInfo table. I have tried adjusting the form properties to not allow for editing the table, but I haven't found the right place to dis-allow edits from the form or query.
Jul 30 '19 #1

✓ answered by ADezii

It adds the New Record because the Record Source for the Form is HrCalcQry and the Control Source for the Text Box Employee_TBD is the [EmployeeID] Field in HrCalcQry. Since this Form is only used for Calculation purposes, it need not be Bound and neither does the Text Box. See the Upload for reference.

3 909
I have attached a copy of the DB for reference
Attached Files
File Type: zip LicenseCalculator.zip (162.9 KB, 23 views)
Jul 30 '19 #2
ADezii
8,834 Expert 8TB
It adds the New Record because the Record Source for the Form is HrCalcQry and the Control Source for the Text Box Employee_TBD is the [EmployeeID] Field in HrCalcQry. Since this Form is only used for Calculation purposes, it need not be Bound and neither does the Text Box. See the Upload for reference.
Attached Files
File Type: zip LicenseCalculator_Revised.zip (147.5 KB, 39 views)
Jul 30 '19 #3
Thank you for your assistance. I figured it had to be something along those lines. I was too far in the weeds!
Jul 30 '19 #4

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

Similar topics

5
by: Sue | last post by:
On code-behind page: (attributes set programatically for each of these elements) linkbutton added to tablecell textbox added to tablecell tablecells added to tablerow tablerow added to table...
3
by: Ptbrady | last post by:
"Order By" fails in form for linked table. -------------- My A2K database has worked well for several years, but now has been split into front-end/back-end and has the following problem. I have a...
2
by: Oliver Gabriel | last post by:
hello, i have a form with a table on its back. The primary key is an autonumber field called "ID". I have a textfield displaying the value of this field (just for my info, data is sure entered...
9
by: Greg | last post by:
Binding Manager & dataset - won't add record I've got an untyped dataset with controls bound through code. The user can select a question number from a bound combobox, and the question number and...
0
by: Doru Roman | last post by:
Hi, I try to keep the current record in a datagrid in the visible part when for example I click on the header to change the sorting column. Thanks, Doru
3
by: mbatestblrock | last post by:
Perhaps this is a no brainer...I have a database that is comprised of just one form and one table. This was made quite a while ago for someone, and now they want to do some more with it. Now they...
1
by: Steve | last post by:
This may be a dumb questions please forgive I have a form that shows a list box that links to a table with 7 employee names The form does not show employee key. When adding record to master...
7
by: chrismaliszewski | last post by:
Hi. I created code which makes dynamically form with bounded controls for all columns. I show it to you below. My problem is, how I have to change this code to create form which record source...
15
RockKandee
by: RockKandee | last post by:
I have tried to search for answers that already exist, but I lack the proper vocabulary. I am using Windows 8 - Access 2013 I need to add existing and new customers to events. I am looking...
4
by: markiemark | last post by:
Hi there I'm trying to add several fields to a form from a table that has criteria towards obtaining a specific risk index. In the lookup table, there is: (the first column is the heading and the...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.