Search results

I Simple want if ReadForm is selected.means if bit field is checked .then i want to see the corresponding value.but Nothing Comes .when i runs the query.Kindly let me know the idea.Any help would be highly appreciated. Readform is a Yes/No field. SELECT AccessRole.emp_ID, AccessRole.FormID...

can anybody tell why this Ms Access query is not working .Kindly let me know the idea.Any help would be highly appreciated. SELECT AccessRole.emp_ID, AccessRole.FormID FROM AccessRole WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';

can anybody tell why this Ms Access query is not working .Kindly let me know the idea.Any help would be highly appreciated. SELECT AccessRole.emp_ID, AccessRole.FormID FROM AccessRole WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';

can anybody tell me ?.Why this query is not is not working .Kindly let me know the idea.Any help would be highly appreciated. SELECT AccessRole.emp_ID, AccessRole.FormID FROM AccessRole WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';

can anybody tell me .how should i resolve this issue.when try to open ms access database got error. The database is an Unexpected state. Kindly help me.any help would be Greately appreciated.Kindly find the error.zip attachment also.

can you tell me how should i use self join in Ms access using sql view i got syntax error when i tried ? Select distinct row m.* from mr m inner join mr r on m.req_no=r.req_no

yes sir i got security warning .if you don't mind can you tell me any aditional way to solve this issue. since we cannot install security certificate for all pc there are 50 pcs here in. [ Private Sub Command6_Click() Dim Access As New Access.Application Access.OpenCurrentDatabase...

sir when i put these codes access is comming i want only report when i click on the button only access report should come. Private Sub Command6_Click() Dim Access As New Access.Application Access.OpenCurrentDatabase ("\\asfserver\itp$\Product_tabletest.mdb") 'Access.DoCmd.OpenReport "MR"...

how Access save report to word document.kindly help me please and send sample code ?

sir , since i will show only MR report but database is comming in normal mode. Kindly help me. Private Sub Command6_Click() Dim Access As New Access.Application Access.OpenCurrentDatabase ("\\asfserver\itp$\Product_tabletest.mdb") Access.DoCmd.OpenReport "MR", acViewNormal End Sub

i got runtime error 2486. you cannot carry out this action at the present time. Private Sub Command6_Click() Dim access As New access.Application access.DoCmd.OpenReport "MR", acViewNormal End Sub

When i put this lines i got runtime error 2486. err.desc you cannot carry this action at the present time Private Sub Command6_Click() Dim access As New access.Application access.DoCmd.OpenReport "MR", acViewPreview End Sub

where should i place these codes in vb6 codewindow or ms access query section don't mind sir i as i am new in reporting of ms access .Kindly find attachment also there you will get sir MR table as well as mr report. Dim qDef as queryDef On error resume next set qDef =...

Re: generating complicated report in vb6 Can i design complicated report like Material requisition ,purchase order in Ms access since i am using backend as a ms access 2003 and front end vb6(sp6) . May i get some help.

SELECT PRODUCTION.Productname, PRODUCTION.Item_code, Sum(PRODUCTION.Qty) AS TotalOfQty FROM PRODUCTION GROUP BY PRODUCTION.Productname, PRODUCTION.Item_code this will simply retrieve productname,item_code and total of qty and what about the detail of total quantity suppose there is a...

can anybody tell me how should i genereate a Ms access query so that i see records itemwise i have written a query but it is not working i want to display records item wise suppose if code of item is p70 when user put p70 it should show matching productname with issues quantity as per user...

i want my requisition no should start from 214500 and when user again save record through frontend it should increase by 1 how should i set req_no fields property so that it should be start 214500 but it should not be autonumber. it should be number.

Sir i want to store grid data column wise these lines are working fine but i want to store multiple record in A Ms access 2003 table rs1.Fields("item_code") = Grd.TextMatrix(1, 1) rs1.Fields("productname") = Grd.TextMatrix(1, 2) rs1.Fields("unit") = Grd.TextMatrix(1, 3) these line working...

NOW I MADE A FUNCTION IN VB6 AND BACKED MS ACCESS 2003 I WANT IF USER CLICK ON SAVE BUTTON PRODUCTNAME,ITEM_CODE, AND UNIT SHOULD BE STORE IN MR TABLE BUT THIS FUNCTION IS NOT WORKING . Kindly help Sub InsertIntoMR() If DataPath = "" Then Exit Sub Else Dim rs As adodb.Recordset Dim...

I Am Having A Database Which Is Having Production Consumable Product With Product_id P1 To P199 Similarly Maintenance Cons. And Tools Consumable How Should I Make A Query So That Last Product_id Should Return. When User Enter Something It Should Automatic Generate P200 For Producuction...