I am making a Invoice registration DB. In the Form I have made a entry “VAT =” calcultated as “ NetAmount + VAT%”. The result shows in the Form, “NetAmount” and “VAT%” which are manually entries are recorded in the table but “VAT” is not recorded in the Table.
What could I be doing wrong?
Hi all,
I have a problem finding the last date entered in a table..The purpose is to find the record which entered last in a table. Is there any way to find the last record with date ? I am attaching a sample db with this. Please look that if my question is not clear here..
Thanks in advance
thanks
I have an after update event that populates, Date, Time and User into corresponding fields when the record status changes to closed.
However... Whilst the information is recorded on the form it does not record to the underlying table is there any reason for this, or anything that I am not doing correctly?
I've been requested to make a bird count database.
The bird count data has been recorded on monthly papers like this:
[bird name] [week 1][week 2][week 3][week4]
The number of birds sighted for a given week is written in the [week x] columns.
What I need to do is make another column that shows whichever number is highest from columns [week 1], [week 2], [week 3], [week 4].
So for example:
Blackbird: Week1: 4, Week2: 2, Week3: 6, Week4: 2
highest: =6
Hi
I have many records say I would like to view a record by someone's surname and the Most recent date they were entered into the system (I have a field called date).
How would I do the latter (view by last recorded date)?
Can anyone help?
Cheers
Bikeboardsurf
I am trying to create a Special Recorded tracking database where a member of staff will log the tracker number into the database and then at a later date someone can come and update the data, what I want to do is scan the tracker barcode with a scan gun and its details appear for updating, I can do this part but when I make any amendments to the data it doesn't save the new data and I don't know why? I am using a combobox to display the tracker number and me.text1.value = me.combo4.column(1) and so on and so forth to display the data, when I change this data it doesn't save.
View 1 Replies View RelatedI would like to filter data from a table using a query (from an data input form). The objective is to output all results if input form field is empty and to output results higher or equal to the type in the field if field is not Null. The query code is as follows:
IIf(IsNull([Forms]![Form2]![MaxDiffInput]);[Maximum operational pressure (bar)];[Maximum operational pressure (bar)]>=[Forms]![Form2]![MaxDiffInput])
However, is not providing any result when the input field (MaxDiffInput) as a value.
Hi all,
i'm working with Access 2003 in the following scenario:
tblCARS
#####
COD, CARNAME
tblACESSORIES
##########
COD, ACESSORIENAME
tblACESSORIES-CARS
##############
COD, CODCAR, CODACESSORIE
* In this MDB, the Relationships (1-n) are:
tblCARS.COD = tblACESSORIES-CARS.CODCAR
tblACESSORIES.COD = tblACESSORIES-CARS.CODACESSORIE
Table Data's
#########
tblCARS have 2 records in COD and CARNAME fields:
1, Ferrari
2, Hummer
tblACESSORIES have 3 records in COD and ACESSORIENAME fields:
1, Light
2, Mp3 Radio
3, GPS
tblACESSORIES-CARS have only one record in COD, CODCAR and CODACESSORIE fields:
1, 1, 2
* This mean that: Ferrari have a MP3 radio... ok...
Now, i would like to construct a SQL that show me what ACESSORIES still havent found on tblACESSORIES-CAR, in this case would be 'Light' and 'GPS' to FERRARI.
For Hummer, the SQL should show all three acessories: Lighr, GPS and Mp3 Radio because none of these are recorded in tblACESSORIES-CAR for Hummer.
The Microsoft Access 2003 have a query-wizard that search for 'no-coincident', I already try it that only show me WHAT acessories still not recorded at tblACESSORIES-CAR. But this query do not show what acessories are 'missing' for FERRARI for example! If I specify CODCAR it dont show anything more!! Why?
I need (by my asp code) list for the car (can be Ferrari or Hummer, for example) what acessories I still can add! How to 'fix' it??
tks
Renato Jr
jrduetto@yahoo.com.br
:confused: Hi
I have some 100 questions for which user must answer by selecting any of the options provided using option buttons.
As i cant fit all 100 qtns in one form am splitting it into soem 10 forms.
User answers the qtns in 1st form and clicks on next button to goto to nxt form
thn agn he answers the qtns in tht form and clicks on next button to goto nxt form..so on.. until he answers all the qtns in the last form.
I want to transfer the answers selected from 1st form till the last one..where all the answers are stored in one table whn a submit button is clicked.
please let me kno ASAP if thr is anyway i can do it.
thnk in advance
Hi
I have some 100 questions for which user must answer by selecting any of the options provided using option buttons.
As i cant fit all 100 qtns in one form am splitting it into soem 10 forms.
User answers the qtns in 1st form and clicks on next button to goto to nxt form
thn agn he answers the qtns in tht form and clicks on next button to goto nxt form..so on.. until he answers all the qtns in the last form.
I want to transfer the answers selected from 1st form till the last one..where all the answers are stored in one table whn a submit button is clicked.
please let me kno ASAP if thr is anyway i can do it.
thnk in advance
I am new to access (2007), There is a datasheet in the form where we enter our time in/time out. We enter data using the form but that is one data at a time only. So I tried to paste multiple data (records) from excel into the access table. After pasting into the table, the data appears in the query, but not in the form.When I go to the form to check if the data I pasted into the table will appear in the form's datasheet...some data appears but some does not.
View 2 Replies View RelatedHow to make a form open with data from a table based on a date and time in the/a table?
View 7 Replies View RelatedHow to update data from one table to another table using form.
I have data coming from design team in Database 1 and using form i want search data and assign the job to a person and store it in the database with his name. I have to do this because database from design team is read only.
I have three tables: Vehicles; Vehicle Reallocated; and Vehicles Retired. I have a form that runs a query to find all the info in the Vehicles tbl that is not "Retired", not visible in the form. I then have the option to toggle to a Reallocated or Retired form. When i toggle to the reallocated form, i have the like fields in that table (ie Van #, Vin, Make etc) pulling the info from the hidden subform with the vehicle query, so i do not need to fill in repeat data. However, when i add a reallocated date and the new clinic that vehicle is for, i get the record ID for the vehicle reallocated table as expected, but when i save none of the data moved over from the query saves in the record?
How to get all the data on the reallocated form to save?
New to Access! I am creating a quotation database where a new company name will be entered. In 1 form a pick list of products which I then want to go into another table associated to the company name which can then be queried and displayed in a report for printing the quotation.
I have created
QuotesTbl
QuoteID (PK)
QuotedItemsTbl(PK)
QuoteID (FK) (1-Many Relationship w/above)
I will create a form to generate a new quote, enter the company name with a display of quoted items (QuotedItemsTbl) (Query QuoteID).
On that Form i want to have a button to 'add items' on that form be able to pick from items in StockTbl which when selected and button 'close' copy the data to QuotedItemsTbl
Any advice to a enthusiastic buy novice newbie much appriciated.
I have a table called "WorkRequest" consisting of some fields such as WR Number, WR Date, WR Time, WR Requested by and WR Work Requested.Once a work request is completed, I want to open a form called "JobCards" from a table called "JobCards". When I click on the pulldown box for the Job card number, it lists the "WorkRequest.WR Numbers" which is what I want.
My problem is: As soon as I select the WR Number and it displays in the jobcard form in the JobCardNumber field, and I press ENTER or TAB, it must automatically populate the corresponding fields on the JobCard Form. These fields are defined identically in bot the "WorkRequest" and the "JobCard" tables.
Hi,
I'm new in Access and facing a problem. Hope I’ll make myself clear.
I've a table "members" and I've created a form "member_form" based on this table (members).
1. I want to binde my form "member_form" with my table "member" so that the new data I store in form, automatically sotres in table. How can I do that:confused:
2. In form, I've fields "Member_ID" and "Member_Name". I want that when I type member_id in "Member_ID" field, the member name in "Member_Name" field come automatically. How can I do that???:rolleyes:
Thanks in advance
Hami Bjorn
I have been working on this for hours and I can't seem to find how to take the data I input into a form and have it appear in another table I had created earlier. I want to be able to pull the data up from either source and then edit it. I can put the chart into database mode but that isn't what I want to do. I want the data in a completely separate table.
Thanks sooo much
Hi,
This could be extremely simple but it's not something I have done before so would appreciate some pointers.
I have a form ("frm_ArchiveEntry")with 3 text boxes ("txt_Date", "txt_WorkInProgress" and "txt_CompletedStock") into which the user enters data.
I have a table ("tbl_Archive") with 3 fields ("a/cCode", "StockValue" and "StockTakeDate") to which data is added to using an append query (Run from a button on "frm_ArchiveEntry") which collects summary data from another table for a/cCode and StockValue.
Firstly I would like this report to also take the value of the "Date" textbox and enter this value for the "StockTakeDate" for these records when running the append query(or afterwards if necessary).
Secondly I am need to write some code that would enter 2 new complete records into "tbl_Archive":
Record 1 would have "a/cCode" = "Work In Progress", "StockValue" = Value of "txt_WorkInProgress" and "StockTakeDate" = Value of "txt_Date".
Record 2 would have "a/cCode" = "Completed Stock", "StockValue" = Value of "txt_CompletedStock" and "StockTakeDate" = Value of "txt_Date".
As I said, this is probably really simple, but this is the first time I have been trying to enter data into a table from a form that is not directly linked to it, and don't really have a clue where to start!
Thanks in advance for any help anyone can give.
hello...i am new in using access..and my problem was... i made a calculation (multiplication of 2 value,,"QUANTITY*PRICE=AMOUNT) in a FORM and it works, it does display value in "amount",,,but it doesn't display the said value ("amount") in the table...which is necessary in my report...don't have a value in "amount" field in my table.
help me..tnks in advance..
Hi everyone, first time poster here!
I have a quick question. I am continually updating and adding fields to a table. Once I have added a field, how can I see that field on the form I've created? Since I am often adding fields, it is necessary to capture the data of these fields within the form. Do I manually have to add a field in the design view of the form and link it to the corresponding field in my table? Any help someone could provide would be much appreciated. Thanks.
Bill
i have an Table with 2 fields FIRST and SECOND.Using a Form, i Open this table ( and what already have been added there ) , and using Add button , Exclude button, Edit button at the Form , make those actions on table.
View 6 Replies View RelatedHi Guys
I'm trying to create a database application which logs the number of times which i do a certain task.
Is it possible for me to create a button within a form that will increment the value with a particular field by one?
I have searched the net but can't find anything.
Thanks
Matt
hi, i have a table database created and i would like the information in it to be able to be linked to a form. but only certain information in the table, not all.
View 1 Replies View RelatedI have a form with several tabs on it, where the user enters various info.. I want to have the user hit the save button and have all info saved to a single table. Is there an easy way to do this. Please excuse my ignorance but I am fairly new to Access. Thanks in advance!
View 9 Replies View Relatedi have a problem adding the data from the fiels on the form into a table. I know you can just click on the navigation arrows and it will save the record but i want to use a submit button as this is more user-friendly and suitable for the work i'm doing.
I have attached the database... the form that needs the code for submit button is 'frmNew_JobStatus' and the table i'm trying to insert the data into is 'tblJobStatus'
can anybody have a look at what i've done so far and suggest how i can fix this... sample code would be very usefull as i'm not an access expert.
thank you all