Search results

Your are welcome.... If someone helped you to solve your problem and the problem solved then add his/her post to his/her reputation...

Hi Dear, > A very simple solution could be grouping all items with rectangle..... you can do this in this way..... Format menu > group. > Another way could be tab tab control.

Ok........ lets analyze first........ Access cannot recognize PNG format for transparency... If Access is unable to apply transparency with GIF, then is there any grantee that PNG will work as transparent.... if Access supports transparency....... then it work with GIF too..... there could be a...

There is another way... You can use images instead of buttons.... but they don't have 3D behavior.

Hi Rosh, If you are working on form then... you can add this me.allowaddition = fasle in your form_load event procedure. And for any addition, insert Add Record by manually or by using wizard and just before the add command in event procedure type this. me.allowaddition = true This will enable...

Hi Jon, Jon you can do it while using form... In form design view... goto combo properties... In format tab, select from format box which format you want... you can select LONG DATE, MEDIUM DATE or SHORT DATE, it will hide the time form your combo box... Hope it will work...

There is no component with this name in my reference list. How could I install DateTime Picker component or where could I find it...?

Hello All Experts; I have a bound form with a query. In this form, there is a bound text box with data type (Date/Time). Now I want Calendar in this field like VB Date picker combo box. Is it possible in Access...? or any idea about fastest date selection rather then typing...!

Hi Dear, If you have set STARTUP option active (i.e. Tool Menu>Startup) then goto Startup option again and uncheck the option "Allow default shortcut menus" and then re-open your project and test in report view... Note: It could decrease your project security if your project is on sharing...

Hi Wasim, If you are using query for your report, then enter <>" " in your criteria box of then field in which null value exist. Try it...

Hi dear, Just openup your database while holding SHIFT key. This will bypass your startup. Just try it..........

Some time big problem solves with simplest logic...

Thanks budy......... It was really helpful for............... Thanks a lot.........

Hi Rosh, It is possible, just insert new field "customer id" in policy table and set its datatype "Number". OK, now create a form using CUSTOMER table/query then create a form using POLICY table/query. Now in your CUSTOMER form, insert POLICY form as subform and from its properties, set Link...

Respected Experts, I have a small database with 1 table "tblDocuments" containing 3 fields "ID" (autonumber), "DocNo" (NumberField) & "DocTitle" (TextField). With all these, I've a form including all these fields and a textbox "txtSearch" (unbound) and a button "btnSearch". Now I want that...

Hi Dear, I did it in my own temp database but its working......... Try to remove input mask from any one side........ just keep input mask either in table or in form......... Just try it........

well use the simplest method to use that query.... 1. Open the query in design mode and locate the criteria in you desire field like ID_CLIENT and then delete it by selecting all text from criteria field. 2. Just remove the WHERE clause from your query expression, like "where ID_CLIENT=...

Hi Dear, the reason could be that you are using the query in which you set the criteria i.e. =[Forms]![YourFormnameHere]![YourComboBoxNameHere] If you dont want to filter any data then use simple query or delete the criteria from the query you are using in your new form... Just try...

If someone helped you to solve the proble and the problem solved then add his post to his reputation.

You are welcome.