Recent content by Alvis

My Daughter wants to print her Labels for her school note books through Access and for her friends too ? Is it possible ? She wants to give the name as a input in one form and then she needs a box to click on all the subjects she wants like History, Maths etc. Once she gives this, all the...

Please help guyz ....

I have attached again. PLease check and support. Thanks in advance. Thanks Alvis Lazarus

Friends - I have attached a sample spreadsheet which is a table in a MS Access database. In this I need to pull out a report to tell me following: >> For each month (Column B), how many stock codes are counted (Column G) and how many stock codes have variance (Column M) ... i.e variance...

If we decide that the user should not see this message we can set the options to turn it off when we run the command. This will usually be actioned from a command button somewhere within the user interface of the application. The following example shows how to turn off the warning messages...

Thanks .. I'll try it !

Dear Friends ... Currently, I'm using Import through macro "transferdatabase" and giving the file name and location. Is it possible to Import a excel spreadsheet through a user friendly file pick option ? If possible, Any has a sample database for that ? Below code did till picking the...

Guyz ... it worked for me. Thanks a lot !

Friends ... yup, I think that's the problem. My application is around 28MB now. I'll try to compile and then try the accde option ! Thanks ! Is there any other options available other than accde in 2007 ?

Hello John, Thanks a ton, Buddy ! I'm ordering the book you have suggested in Amazon today ... Have a gr8 day ! Thanks Alvis

All - How to really design access control your MS access application when you are rolling out to a larger group? This is much needed for the benefit of the users and to make sure that no one really changes the code or the design piece of the application. The ACCDE option is not really...

@ Qualia I have sent you the sample database to your email ID. Happy learning ! Thanks Alvis Lazarus

John - Good morning. I understood that .... the clarification I asked is for eg: If the color field is having 5 Colors say Red, Blue, Yellow, Green and Black. I should have a check boxes in the user form for all these colors. I can pick either one color, or 2 colors or 3 colors ... based on...

Guyz ... please share some good reference books ... All experts in this forum ... how you guyz mastered this tool ? One is by usage I agree ... but when u r learning ... what are all ur references ?

@Qualia .. my file bounced back. Please give me your email ID .. i can fwd my database. Thanks Alvis