forms of VB or Access

[monika]

hi.

I dont have much experience on this part so it might be a
silly question.

I am using excel and access. Can i link my access db to
generate excel sheets through vba? in that case then i
dont need forms from access?

I can create forms in VBA and link it to access and
generate reports in excel. Why do I need access front end
(forms)?

do help me to clarify this doubt

thanks a lot in advance
monik

 

[Mike Painter]

hi.

I dont have much experience on this part so it might be a
silly question.

I am using excel and access. Can i link my access db to
generate excel sheets through vba? in that case then i
dont need forms from access?

I can create forms in VBA and link it to access and
generate reports in excel. Why do I need access front end
(forms)?

Access is capable of generating far more complex report than Excel.
Access is a relational database and Excel is a spreadsheet.
You have to decide which you need or give us some information to help you
decide.
Using Excel when Access is needed is like using Word when Excel is needed.

 

[monika]

thanks a lot for the prompt response.
I got what u mean. Currently I am generating reports using
excel only. my input and output are both excel. i work on
vba. so now that i want to use access ... so wasnt sure
whether to use access forms or vba forms for taking user
input.
do u know of any good links which can help guide me on
access and excel linking and other things?

thanks again.
monika

 

[Arvin Meyer]

thanks a lot for the prompt response.
I got what u mean. Currently I am generating reports using
excel only. my input and output are both excel. i work on
vba. so now that i want to use access ... so wasnt sure
whether to use access forms or vba forms for taking user
input.
do u know of any good links which can help guide me on
access and excel linking and other things?

Access and Excel can be automated easily. Have a look at some of the
examples at the Access Web:

http://www.mvps.org/access/_vti_bin/shtml.exe/search.htm

Just type in "Excel" (without the quotes).

Access reports are like finding true love. Once you're comfortable with
them, you'll never want to look anywhere else. In truth, there's nothing
that can match the ease and power of the Access reporting system.

For good books on Access/Excel automation search at Amazon for books by Ken
Getz, or F. Scott Barker.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Mike Painter]

thanks a lot for the prompt response.
I got what u mean. Currently I am generating reports using
excel only. my input and output are both excel. i work on
vba. so now that i want to use access ... so wasnt sure
whether to use access forms or vba forms for taking user
input.
do u know of any good links which can help guide me on
access and excel linking and other things?

thanks again.
monika

There are tons of links but there is also a massive amount of information
contained in the help files for both products.

If you are using Excel properly building forms with either Access or VBA
will not be of much use.

But, again, we have no idea of what you are doing.