Search results

Hi, I have a form..which have a group of option buttons..based on the selected option ..the text boxes would display.. But by default one option in the group is selected and as result the textbox under it are visible when the form is loaded. I tried giving visible property false..in form...

Thank You very Much...

Hi guys, In the ZipCode text box ,The default value is 0.But when i type the zipcode as the 02921..Its deleting the starting 0 and just saving as 2921.. How can I save the zipcode which includes 0.. Please help me out.. With Regards, HimaBindu.B

Sorry, I did not meanthat..when i was trying in differentways..i got this ..when i tried it works..Thats why i published it there.. Thank you very much..

Hi guys, I got that.Here is the code: Private Sub Delete_Click() On Error GoTo Err_cmdDeleteRecord_Click Me.Undo DoCmd.RunCommand acCmdDeleteRecord Exit_cmdDeleteRecord_Click: Exit Sub Err_cmdDeleteRecord_Click: MsgBox Err.Description Resume Exit_cmdDeleteRecord_Click...

Hi, I tried using the above code also..Its showing the message but not not deleting the records.. Even I tried creating another delete button..Even then the problem is same.. Is there any option which i must have changed... Thank you very much.. With Regards, HimaBindu

Private Sub Delete_Click() On Error GoTo Err_Delete_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_Delete_Click: Exit Sub Err_Delete_Click: MsgBox Err.Description Resume Exit_Delete_Click End...

Hi guys, In the form i gave a command button for delete..But when i click on the delete button its not deleting the records and even not showing any error message.. With Regards, HimaBIndu

Hi, I tried this code: Me.YourControlNameHere.StatusBarText = "Whatever you want" but i did not get the text in the status bar.. But when i tried me.yourcontrolNameHere.controltiptext="Whatever you want" It worked out.. Thank you very much... With Regards, HimaBindu.B

Hi guys,.. I am trying to give that in a subform..is this the problem.. With regards, HimaBindu.B

sorry guys..I am not able to get the status bar text..But when i tried in the similar way i got the control tip text.. Please help me out.. With Regards, HimaBindu

hi , Thank you very Much.. Please tell me how to set the status bar text to dynamic..I am getting them in the design view.. Thank you very much.. With Regards, HimaBindu

Hi guys, when the user is using the application i want to display the hints and notes in the status bar..or when the mouse points in that particular box.. Please help me out..How can i do that.. With Regards, HimaBindu.B

Thank you very much..Its working..

Hi, I have a small doubt..when i am doing reports..The report shows the results only when the given criteria is satisfied..But when No data is found with that criteria..I want to display a message saying..no records found.. How can I do that.. Thank you very much.. With Regards, HimaBindu.B

Thank you ,but i want to use in the code so that the application can be used and printed in all different systems.. Please help me out.. Thank you

Hi , I want to give a default margins for the reports in access..How to do that using the code..I have tried using.. Report.Printer.BottomMargin = 1 Report.Printer.LeftMargin = 1 Report.Printer.RightMargin = 1 Report.Printer.TopMargin = 1 Please help me out.. Thank you...

Thank you very much.. Here is the order [forms]![formname]![subformname].form![fieldname]

thank you..Will you please tell me how to pass the parameter of the combo box to the query.. When i do the same in the query..Its the same as the first.. Thank you, HimaBindu..

hi, I have a small application which have a tabbed buttons.In the 2nd tab i draged the form..which have the report options combos..when i indivudually tested the form..it was fine..i,e based on the selected option in the combo box i was able to print the report.. but when i dragged it tab...