Search results

Thanks Bob, it worked. now its not giving errors.

Hi, i am incorporating inventory tracking in Northwind 2010 Template using a sample provided on this forum. Northwind 2010 stores Quantity Purchased in [PurchaseOrderDetails Table in field name Quantity] And Stores Quantity Sold in [OrderDetails Table in field name Quantity] Same field name...

found a vb6 project which is able to send sms. however i am not able to make it work in access VBA. give error on compiling ( even ignoring form item refrences). vb source code along with vb compiled exe is attached. i will be very thankfull if someone makes it work in vba. Thanks

just wanted a simple sms sending feature on a Access form using VBA using attached USB GSM Dondgle. googled out and found something relevent but NONE seem to work. http://www.andreavb.com/forum/viewtopic_5824.html http://www.java-samples.com/showtutorial.php?tutorialid=1131 it would be...

Thanks for the info. Now we have functional Northwind 2010 client database template if anyone wants. cheers..

Thanks for helping me out. i have another question some MSys prefix tables (EXCEPT MSysRelationships) have different enteries. can they be ignored or can they create errors in future. Thanks.

Thanks for the reply i have managed to convert forms/reports by saving individually as (saving as client object). however i am stuck with converting Tables. if i try by importing database the HIDDEN tables such as MSysRelationships,MSysQueries,MSysObjects etc gets renamed by suffix 1 and are...

is there any way of converting Access 2010 web database template into a desktop database. i tried Northwind 2010 web database template and after converting into accdb the form and reports cannot be edited in design view( there is no design view option). such forms and reports cannot be exported...

i tried another option saved the subform recordsource as query, than sumed it and used a command button on mainform to open that query. it worked and shows the correct sum now (strange...)

the subform has datasheet view and gets populated by unbound textboxes on mainform. that is why(i think) it does'nt get sumed on subform and gives error. any ideas how to get round this problem.

=[mysub].[Form]![TotalSum] where mysub is the name of subform and TotalSum is the textbox on mysub with controlsource =nz(Sum([Total]))

Hi all, I have applied different methods to show subform sum on main form. but it gives me an error. either i am doing something wrong or my access version 2003 is creating problem. i have attached the database. Many thanks for all any help,

here is another. This one handles paisa. Thanks to Yogi Anand modified a little for spaces before and after Rupess\paisa to be presented properly Function ySpellRupees1(ByVal MyNumber) '**** Yogi Anand -- ANAND Enterprises -- Rochester Hills MI 48309 -- 248-375-5710 wwwanandentcom '****...

I found this code to be working. But it ignores paisas. credit goes to Author: Bharat Modha open new module and paste the following Option Explicit 'This cade has been explicitly modified to suit the indian numerical format. Public Function cNumToWord(ByVal src_num As String) As...

Yes.. Thanks...

This is the picture of the options i mentioned in previous post.

If it would not be a problem Plz tell me both options i.e 1)- Do not print the the whole expense block if empty but print rest of the details. 2)- Print txt N/A in that block (under each label) or a single txt N/A.

Leave it , my problem is solved. But one more question regarding report. is it possible to hide(do not print) expense block in rpt_Invoice if it is empty. e.g for record 5,6 print only Dates and hide Labels(dates,Expense,amount,done by) & blue border+line below it. if it cannot be done than...

Thanks... i really appreciate it. Now the Qry shows the record. Also can u Plz brief me about it, how u did it. and now which Qry should i used to print the record.

hi everyone. currently i am facing a problem and would appreciate some assistance. the situation is that i have a main form , a sub form and a print button at bottom. the print button print the related record based on query with a filter. the problem arises when the sub form does not have...