Recent content by mahenkj2

You may need to review proper indexing of table fields. best regards.

Please follow this link: http://office.microsoft.com/en-in/access-help/about-calculating-a-total-in-a-subform-and-displaying-it-on-a-form-HP005187909.aspx I suugest if you can use Datasheet view in sub form in place of continuous form. best regards.

Try docmd.sendObject DoCmd.SendObject acSendReport, "report1", , [From] If you call this report from a form, then do you have customer name at form. Then you can reference customer name in place of [From] When you type docmd.sendobject, intellisense shall start helping you. best regards...

Jeds, although you might have taken care of MS advise carefully, unfortunately it still does not open. anyway, you now have jdraw recommendations, so please follow with him and others. best regards.

If this was A2010, please convert to 2007 or earlier. Most of people here may not have 2010. Also, remove specific features of A2010 (calculated field, navigation control etc.), just keep simple form and then import in blank database.

Sorry, but this says unrecognized database format. I use Access 2007.

would it be possible to post a sample dB?

The below link might help you: http://www.access-programmers.co.uk/forums/showthread.php?t=238218

-1 and 0 are two status of a check box. with regards.

Please try something like this in the Load event of form:

I have found the solution. Actually, I used a wrong link to install. Although It installed successfully but I think it did not have Database Engine included. BTW server name I used - .\SQLExpress

My first post in SQL server. I downloaded SQL server 2008 Express x86 and at the moment I want to try and learn on my PC only and my aim is to connect some of Access database to use as fron end and back end I want to make SQL server. Now when I connect, I use the server name as local in...

Also, you might not need to write condition for elseIF, instead you can just write else exit sub Because, if OK is not selected, then there is only one choice i.e.cancel. I hope I am correct. best regards.

Your code is giving error on Msgbox because you are not declaring it first. So, I have changed your code above. Please confirm if is as you want. best regards.

I am using Access bible and found it very useful but I am sure it is not the whole thing you are looking for. The book may be complete in itself but Access and VBA is so wide that one book may not be enough. At least at some level, you would consider that as a basic book. Although, you get some...