Search results

Hi everyone! How to hide navigation pane permanently? I mean it should not open even when someone check display navigation bar from Microsoft access button.

Hi Everyone! I have a bound form which shows list of items in the stock. When i click on a button it should open another form which shows the details of item which we choose from the first form. the code which i have in click event of the form is : Dim strCrit As String strCrit = "PkID="...

Thank you...that worked perfectly...:)

Hi! How can i add date in textbox by simply selecting it from calendar?

Its done. I set popup and modal properties of new form to 'yes'.

tnx for the reply... Both modal and popup properties are set to 'no'

Hi everyone! I have a form and when i Click on a button it opens another new form. Its working fine but the new form opens behind the present form and only become active when I close the present form. I don't want to close my present in order to use the new form. What could be the problem...

Thank you JBH. Its working fine now. Actually it wasn't txtItem, it was txtQty :) and also I put Exit sub in IF - End if statement. Thank you.

Okay I understood it's not correct code. Can you please help me the correct code.

If I code like above it's not giving any error message. But if i code like below it says "invalid use of null" IssueQty and leftQty are declared as integer in module. Thank you.

Hi JHB! Thank you for your help but i tried to placed end if after exit sub but its not working. If IsNull(txtItem) Then MsgBox "Please fill the required fields", vbInformation Exit Sub End if I even tried with else,still its not working. When i try with else statement...

There is no error message.

Hi everyone! I have a confirm button in my form which will enter new records in a table and also update another table. It gives an error if user clicks on button without typing anything in text box. It was working fine but now its not working. Its not giving an error,not inserting any records...

Hi everyone! I have a main form which contains text box and search button. When user type something on text box and click on search button, I want user to move to another form which will display all the list of items which contains the word in the text box. Can any one help me out with this...

Actually i tried my best to solve but i do not know from where the problem was coming and yes, the problem is not regular which is a problem again. But now I am not getting any such error message also and i just hope i will not get in future. Thank you

Hi Mahenk and khodr! Mahenk ! I was just worried if this error me problem in future because as khodr said Access will not generate an error without a reason. But now i am not getting any error. I hope I will not face any problem in future also. Thank you Khodr and mahenk.

The primary key autonumber will get inserted automatically. You do not have to insert in manually. So, do not select it from the table only. Try to insert other values and leave the field LessonID. I hope this will help because it worked out with me.

As of now there is no error as I told you the error is not coming frequently. And even while pressing shift key its not giving any error. Will let you know if I get the same error again. About the application icon i did not select any icon symbol for my database. Thank you.

I am using database as backend and frontend, when i close and reopen i do not get any error. But I am getting error if I open my database after few minutes. I have no idea what's going on. Anyways Thank you for help khodr

Hi michal I am not sure but i feel like there should be equal number of fields selected from table and the values you want to insert. In your code you have 17 fields and only 16 values. I am sorry , I am not sure with this.