Search results

do you mean something like this =[Forms]![invoicefrm]![Total Cost]-Sum([invoicefrm1].[Form]![Value Of Invocie]) as i have tried this it does not work-i get an #Error msg here is the code that works from the sub form =[Forms]![invoicefrm]![Total Cost]-Sum([Value Of Invocie]) however i want...

that would be a easier solution but this tender may be changed several times within a given period. So a change field is introduced so everytime it is changed the change field keeps a record of what,why, when it was changed sorry i should of explained earlier but wanted to make it clear and...

Hi i have a form and a subform within it. the sum form has some invoice numbers which i would like to total up. However i would like to calculate it minus the total ordered. The total ordered is on the main form and the total value of invoice is on the sub form here is the SQL i am using but...

cheers i have sorted that now thanks alot

hi i am trying to do a query where i have a table(T1) with data in it, and if the data in that table is ever changed. it has to be changed via a changeform(T2). however once changes are done in the change form, it must update it self on the T1 table. in total there are only four entities...

data mismatch error hi I am using the following code to link two tables(update one from to other) but i get the follwoing message. DATA MISMATCH ERROR however i am sure everything is right what could be wrong thank you here is the code i am using INSERT INTO tenderlink ( TenderlinkID...

the where statement is to add new data. it should if it worked add all tenderlinkID from the tenderlink table that are not in the tenderbackup. this is because it is an append query and at present the append query trys to add all the data from tenderlink, thus producing an error message saying...

TenderID does sometime exist in the tender backup hence i am trying to use the tenderlink as a way of checking if it already is in the database. tenderlinkID is the PK and tenderID is the FK, does this mean i am doing something wrong. i am trying to make the code reference to the tenderlinkID...

Hi how i have done the save button is i have written code that the button saves the data onto the main table first and then runs the query. so data does exist in the main table. i have tested to see if the data is saved onto main table and it is but not the backup table. what could be wrong :-(

i have done what you said but now it does not save on my back up table, i do not get error messages or anything. the data is saved on the main table but not the backup table.

code i am using-but not working Hi this is the code i am using but it doesnt seem to work Where am i going wrong INSERT INTO tenderbackup ( TenderlinkID, PartID, SupplierID, [Lead Week], [Basis Of Supply], [Tender Quantity], [Tender Unit Price], [Target Unit Price], [Tender Cost], [Cross...

Hi i have kind of solved my apped query problem but i was hoping if there any code where if there is any new data that the append query will only try save the new data. if not do you have any suggestions pls

I am trying to save data in two places because the one data will be changed as times go one and the other data will be fixed. The two tables will then be used later for calculations purposes. if i wanted to write a query what criteria would i need? thank you

hi i have two tables tblchangelink and tbltenderlink tbltenderlink is used to do a tender for a project, if any changes are required to the tender they need to be recorded and done in the tblchanhelink. however once they have been inputted into the tblchangelink i want them to be updated...

No the form is adding new record to the required table, however what i was hoping to do is make the form send the data to another table as well as i need the information for something else later in the database, hence my append query

Hi Is there any way where you can append query but just add all the new data added to a form. at present my query appends all the data from a given table-i get error message saying 69 of 71 records were not saved. this is probably cause they already exist from previous appending. can anyone...

sorry my attachment for some strange reason dont attach on the actual forum

Hi i have been trying to append a query but i keep on getting the same error message saying that "duplicate output destination partID" do you know why i am getting this message i have attachhed a picture of the two table i am trying to append

Hi Does anyone know of a way of transfering data from a form which i have just entered data into then when i click on save i want the data saved onto another table. This is because i want one table to keep data when it is first entered and the original table will have data that may or may...

sorry if i didnt make myself clear i was using the shopping list as an example. if you have a shopping list as a database where as you choose good from a list and you want that list(whatever it is delivered to you) but then suddenly the user decided he want to save money by reducing items...