newbie question

[ma]

Hello

I am new in access programming. I had some good experienced in C/C++
programming and I did some VB programming too so I have some idea of what is
programming.

For some reason I need to write a simple application for my wife:



I need to write code in access so that I can give it a 8.mdb file and the
program open it and do some data validation on it and probably calculate
some result and print them out into another MDB or an excel file.



I know how to the first step ( getting file name and path from use) but I
did a lot to open it in Access without any success. How can I open a
database in Access ( a very stupid question as Access is for database
programming! )



Best regards

 

[Mike Painter]

Hello

I am new in access programming. I had some good experienced in
C/C++ programming and I did some VB programming too so I have some
idea of what is programming.

For some reason I need to write a simple application for my wife:



I need to write code in access so that I can give it a 8.mdb file and
the program open it and do some data validation on it and probably
calculate some result and print them out into another MDB or an excel
file.


I know how to the first step ( getting file name and path from use)
but I did a lot to open it in Access without any success. How can I
open a database in Access ( a very stupid question as Access is for
database programming! )

I assume that should be *.mdb above.

Normally you would add what is needed to the database that contained the
tables you work on or you would link (File/import/link) the file.
If you need to open a database and then find another database this would
have to be done in code and is covered in help.

 

[ma]

Thanks
I want ot write code in VBA to do this but I couldn't find any help or
sample on how to do this in nVBA for Access. Is there any sample code that I
can use as template?

Best regards

 

[adsl]

Hello

I am new in access programming. I had some good experienced in C/C++
programming and I did some VB programming too so I have some idea of what
is programming.

For some reason I need to write a simple application for my wife:



I need to write code in access so that I can give it a 8.mdb file and the
program open it and do some data validation on it and probably calculate
some result and print them out into another MDB or an excel file.



I know how to the first step ( getting file name and path from use) but I
did a lot to open it in Access without any success. How can I open a
database in Access ( a very stupid question as Access is for database
programming! )



Best regards

 

[adsl]

I assume that should be *.mdb above.

Normally you would add what is needed to the database that contained the
tables you work on or you would link (File/import/link) the file.
If you need to open a database and then find another database this would
have to be done in code and is covered in help.

 

[adsl]

Thanks
I want ot write code in VBA to do this but I couldn't find any help or
sample on how to do this in nVBA for Access. Is there any sample code that
I can use as template?

Best regards

 

[adsl]

 

[adsl]

 

[adsl]

 

[adsl]

Thanks
I want ot write code in VBA to do this but I couldn't find any help or
sample on how to do this in nVBA for Access. Is there any sample code that
I can use as template?

Best regards

 

[adsl]

I assume that should be *.mdb above.

Normally you would add what is needed to the database that contained the
tables you work on or you would link (File/import/link) the file.
If you need to open a database and then find another database this would
have to be done in code and is covered in help.

 

[adsl]

Hello

I am new in access programming. I had some good experienced in C/C++
programming and I did some VB programming too so I have some idea of what
is programming.

For some reason I need to write a simple application for my wife:



I need to write code in access so that I can give it a 8.mdb file and the
program open it and do some data validation on it and probably calculate
some result and print them out into another MDB or an excel file.



I know how to the first step ( getting file name and path from use) but I
did a lot to open it in Access without any success. How can I open a
database in Access ( a very stupid question as Access is for database
programming! )



Best regards