Search results

Yes actual name But how to do it if one field. As I want to get the balance from last record. As user add new value then will be add with last record in new field.

is there a way t do make ms access to count from last record based on item ID, instead of counting all column. thanks

Balance1 = startup quantity

Dears; i need help, i have created Inventory Database, as i want to track the balance after filed update, i tried the below code but the issue is that, it does not include the current record as it calculate previous record. Private Sub Qnty_Out_AfterUpdate() [Final Balance] = (Nz(DSum("[Qnty...

what i want to copy the record in current subform , and upon button click open another form and paste the value.

Dear guys; wanna help ; i have a form " Response" having a button "update1" . and opened form " Search1" and subform " MRN Query1" so once the user click on update1 then " location code" get the vale form " MRN Query1" and past it in the new record in " Response" i tried below code but not...

thanks that's work, but i need , Afetr opening 1- filer as above (Done) 2- if no record found , then copy the item code form current record " MRN Query1" to new record on "Clinic_Response" .

Dears; I have a form which has a button, upon clicking on the button, ten wanna open another form and filter record to 2 criteria, But if no record then open new record and copy the "Item Code1" to " Item Code" in the new form. so i tried this code to open and filter but not working. so please...

i am trying to Extract the data from another table and doing calculation in query, then wanna update this result in customer table. as they are unable to update.

Dears; I have Table1 "Customer" contain date, a And Table2 " Request" contain data which is converted to form and have calculated field through query. the field: ID Item_Name Item_Code Quantity so I want to Update the matching record BY ID , and if no record then add a new record to table "...

i need this form, what i mean if no record in this form then do not open

if no, then will open the form and show the record in another form. but if the record not present in another form then only to show message .

Dears; I have a list in the form and upon double click open another form and filter to selected record, i need if NO record , do not open the form and proceed to next . i tried this code below but it show the message and open the form . Private Sub List6_DblClick(Cancel As Integer) On Error...

Dear all; I have a form that upon double click on list open another form and filter it, i tried below code but not working DoCmd.OpenForm "MRN_Query1_Delivered", acNormal, , "[Item Code] = '" & Me.List6 & "' and [Location - Clinics Code] = MRN_Query1_subform.[Location_Code] & " item code is...

i can do that , but the issue it take long time to open especially when the file shared . as i have more that 10 thousand record in query.

i did that but the issue i dont want to write the code ,as it take time to open. i want the report get the value from opened form. but it will repeated for all field as its different.

Dear Guys; Need help: I created a form , as there is a text field will read the data from table with below code. and there is a button to open a report . so if i do the same code in report, it will take time to open . my question is there any way that once i open the report , will get the...

work successfully . thanks

i tried above but got this error as in attached picture.