Search results

hello all , In my form the first field to enter is kaizen number, & I have 5 depts., so the number would be a1,b1,c1,d1&e1 and so on . Now as the list is getting long, I have to check each time what was the last number given to a particular dept. & I have to write the next number. Is there any...

Thank you , I looked at your example database It is really helpful for people like us (busy in office work but want to learn acess). However I am just asking the question as below to just get clarity. But as attached in my image the login form is pop up only , but still opens closes itself in...

This below code is hiding the window , but not opening my Login screen form , I have attached the form properties also , kindly verify & help me. Code for the form. Option Compare Database Option Explicit Private Sub Form_Load() Me.TimerInterval = 3000 DoCmd.Hourglass True End Sub Private...

thank you for your reply, How can the database be converted to exe file (sorry if I am asking too much )??

Can multiple users use the same database at a time??(different forms for each user , but same table for storing) Is there any steps to follow to make it possible ?

Dear sir , Thank you for your reply. At first I made a query with exactly the SQL you gave to me , And the result were same as you described. But I need Only one row for each equipment name, But Total should be from both "in-Use" and "spare". Please tell me how to achieve this .

Hello , I have attached the data base.

Hello sir , I edited the code to "vblong" but still it didn't work. First combobox is filtering fine . Only this person combo box is showing this message.

Thank you for your reply . Here is my SQL. TRANSFORM Count([Instruments list].[MASTER List serial number]) AS [CountOfMASTER List serial number] SELECT [Instruments list].[EQUIPMENT NAME], Count([Instruments list].[MASTER List serial number]) AS [Total Of MASTER List serial number] FROM...

I have a query with 3 columns, there are 5 types of filters , A,B,C,D,E I want my query to show Total of only A,B and not Others. But when I use OR criteria it is showing 2 rows (for each one of them). How to get total in only one row for both ??

Thank you, below is y row source of person details Combo box , & for the other it is a typed list . Shall I add the ID column to my otherCombo box too ? ELECT [person details].[ID], [person details].[Person details] FROM [person details] ORDER BY [Person details];

For further details please refer the attached image.

Yes the combo boxes are related , but sorry I didn't get the second question..?

hello all , The below code was supposed to filter the data in my report using 2 combo boxes in the form . But Area combo box is working , but when I entered the person name in second one ( even though it is related to same area) it is giving me error as : ERROR 3464 : Data type mismatch in...

dear all , I have a query with 3 columns: Instrument name , status , & model no . status column has 4 different values , in-use, spare , sent for repair & withdrawn. But I need my query table to show only in-use & spare instruments . When I am using "OR" in criteria , the instruments are...

I replaced the empty cells with Zero & now it is working. Thank you for your tip.

=Nz("",[Sum Of Leave(Hrs)])/Nz("",([Sum Of Leave(Hrs)]+[Sum Of LOP(Hrs)]+[Sum Of Absent(Hrs)]+[Sum Of OT(Hrs)])) Like this??(not working)

dear all, I have entered below expression to show percentage in my report , but unfortunately it is not displaying. =[Sum Of Leave(Hrs)]/([Sum Of Leave(Hrs)]+[Sum Of LOP(Hrs)]+[Sum Of Absent(Hrs)]+[Sum Of OT(Hrs)]) can anyone help where i am wrong?

dear sir , I am very sorry I was not able see your messages as I was busy in office work, really I didn't took it as insult . I also know that always sending databases to write the code is not usable in long time. hence I have also started reading access vba book to increase my knowledge about...

ok i'll try for myself & will find the solution for this . thanks for your time. can u send a good guide or book related to access vba??so that I can learn .