Search results

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...

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...

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...

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...

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...

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...

hello guys hope everybody is fine. i have attached 2 jpgs for my access database. in "Untitled 1" u can see and their subtypes in "Untitled" u can see the combobox types and the subsubform holding the material column, Size1 columnn. Dim1 Column... how can i autofill records in the subsubform...

hello everyone im trying to add to my switchboard a listbox that lists all the existing records on the main form to choose one of the them and go straight to that records im using the vba code: if Not IsNull(Me.List0) Then DoCmd.OpenForm "main", acNormal, , "ProjectID = " & Me![List0].Value...

Hello i have two related tables types and subtypes with one to many relationship id primary key.n i hve 2 combo boxes type in form1 n subtype in subform1.how to select the list of combo subtype based on the selection of combo type based on id?

i am using this function to calculate dim1 on the afterupdate event of a combobox which is material. the list of the material combobox and the formula are in one linked table. the problem is that the dim1 is updated with only the first entry of the formula values in the table no matter wat i...

Dear all, i got the attached database to calculate a formula based on a user input. im using its tables as linked tables to seed combo box list of a Main database. In the main database, i have a main form containing size1 and size2. a subform material and a sub-subform named submaterials...

hey guys hope i ll get help from you experts because im not able to solve this. i want to build a form that will allow the user to set his own mathematical fomula, name it and save it. when needed, the user will chose ,from a combo box ,the name of the formula he set before and the result will...