Search results

thanks for you help man! its solved. Please check my attachement to see it

thanks for your help namliam but i replaced the IFF with NZ but no change occured. in fact i used iff to be able to replace the null values with 0 to calculate the field "extra" when do data is in receivedqty or issuedqty. any other idea that will allow me to use >=0 to show only positive...

hello guys ! plz check the attached screenshot of ma query. what im tryin to do is to display only positive values of the calculated field "extra" in the query. if i try to put >=0 in the criteria row of "extra", it asks to fill the paramters "receivedqty1", "issuedqty1" and "balance1" can...

please note that while im tryin i removed all the grouping and summing from the query and excecuted it but still, the items that have to record in the second table are not showing at all.

thx man. in fact, my original report had grouping and summing instead of using it in the query. but when i came to the point to add the value of all the used materials, which will be a calculated field in the report, its always showing 0 since u cant add calculated fields from a report so i used...

i have already done dat in the query, edited the relationship between tables but still only the material used in the projecttable are showing and the ones not used are not in the report. my query has grouping and sum to sum the quantities used for each material. any other solution?

i have 2 tables: stocktable and projecttable "stocktable" contains records listing materials for projects "projecttable" will be filled by choosing a material from a drop down menu listing the materials from table "stocktable" and each record will have a qtyissued in "proejcttable". the...

i have a report with different fields, i need to hide the row where one of the fields, status is = to completed. PS: i didnt remove it by query coz there are some fields from the same row still to be used for calculations. thanks

i am working on ms access forms! but whenver im trying to change anything it gives me an error that it couldnt save because it would create a duplicate in primary key, indexes.. it comes many times and then the project goes with vb code for application project is corrupted! wat is goin on? thanks

im built a paramter query with 3 paramters jobno, ponumber and material. when i fill the three of them i get the wanted result. when i keep any of them empty it gives to result so i added the "is null" but its giving me all the results. wat i want is for example if i fill the first...

i think you missunderstood me!my columns headings on the crosstab query is the jobs which are added with time. what im trying to say is that everytime a job is added as record on my main form, its gona be added as a new column in the query and therefore i want it to be added dynamically(on its...

hello guys im trying to make a report based on a cross tab query. the number of columns is dynamic in the query.whereas its not on the report. i have read some articles about adding unbound textboxes and assigning the column values "on open" of the report.this doesnt work for me since i cannot...

thank you soo much man! it worked like silk! i really appreciate the help of the experts. addind "docmd.runcommand accmdsaverecord" at the begining of the afterupdate event solved the problem. take care God Bless

im using the following code to create new records in a subform on the afterupdate even of a combobox in the mainform. the main form has a primary key ProductID. the problem is that on the afterupdate event, the primary key in the main form is null which is resulting in a null "ProductID" in...

thx guys i solved this problem by changing the code as follows: Private Sub type_AfterUpdate() Dim db As Database, tb As Recordset, rs As Recordset, ns As Recordset Set db = CurrentDb Set tb = db.OpenRecordset("Select * from Materialtable1 where ID =" & Me.Type.Column(1), dbOpenDynaset...

runtime error hey guys im having this error on executing this code; must use dbSeeChanges option with Recordset Private Sub type_AfterUpdate() Dim db As Database, tb As Recordset, rs As Recordset, ns As Recordset Set db = CurrentDb Set tb = db.OpenRecordset("Select * from...

in fact i have 3 related tables "type" (ID) one-to-many-relationship with "materialtable1"(MaterialID) one-to-many relationship with "subtypes". these tables are used as templates.the user setup the content once and he can use them. i have other 3 tables with same structure relationships...

hehe in fact this is the oposite! im trying to copy the full record set from the "tablematerial1" to the subform fields.

The action was cancelled by an associated object runtimeerror "3426" when trying to execute this code: Me.invetory_transactions.Form.Recordset.AddNew PS: it only happend when the recordset is empty. it doesnt happen if records are existing and we are adding to them Private...

one more thing is that when i m choosin one type from combobx and then rechose another type, the records are adding! what i really want is to erase the old records and replace them with the updated ones!