ASSIGNING FIELD VALUES VBA

F

FAROOQ

OH SMALL PROBLEM ARE BIG PROBLEM. ANYWAY I HAVE A STATEMENT IN VBA
SOMETHING LIKE THIS

"C:\BUSINESS\FURUC SPC\CUSTOMER FILES\ME.PART_INFORMATION.[PART_NUMBER].ACCDB"

WHAT I AM DOING IS CREATING NEW DATABASE, THERE IS FORM CALLED PART
INFORMATION, THERE IS A FIELD CALLED PART NUMBER.

I WANT TO PASS VALUE FROM PART NUMBER TO CREATE DATABASE PART_NUMBER.ACCDB.

I TRIED EVERY WHICH WAY BUT IT WON'T PICKUP VALUE FROM FIELD PART NUMBER

I KNOW I AM DOING SOMETHING HEADACHE

ANY HELP WOULD BE APPRECIATED

THANKS
 
J

John W. Vinson

OH SMALL PROBLEM ARE BIG PROBLEM. ANYWAY I HAVE A STATEMENT IN VBA
SOMETHING LIKE THIS

"C:\BUSINESS\FURUC SPC\CUSTOMER FILES\ME.PART_INFORMATION.[PART_NUMBER].ACCDB"

WHAT I AM DOING IS CREATING NEW DATABASE, THERE IS FORM CALLED PART
INFORMATION, THERE IS A FIELD CALLED PART NUMBER.

I WANT TO PASS VALUE FROM PART NUMBER TO CREATE DATABASE PART_NUMBER.ACCDB.

I TRIED EVERY WHICH WAY BUT IT WON'T PICKUP VALUE FROM FIELD PART NUMBER

I KNOW I AM DOING SOMETHING HEADACHE

ANY HELP WOULD BE APPRECIATED

THANKS
Click to expand...

First off... please turn off your caps lock. It's hard to read all caps, and
it's considered impolite - it looks like you're SHOUTING AT US.

Please explain why you want to create an all new *database*. A database isn't
much like a document; it's a container for multiple tables, forms, reports,
code and other objects. A database *does not contain fields*; a database
contains Tables, each of which will have fields. It makes no sense to create a
database and "assign it a part number"; it makes even less sense to create a
new database for each part number!

What will you do with this database when you create it? What real-life task
are you trying to accomplish?

Please note: a response in all caps will be deleted, unread. If you don't like
using the shift key, all lower case is acceptable.

John W. Vinson [MVP]
 
F

FAROOQ

soory about caps bad habit
anyway the reason for making seperate database for each part is keeping
each part seperate for spc reason. we work with one part to do statical
analysis.
each time we do part analysis we link to that database and do whatever we
want to do and unlink that database and go to next one
thanks
farooq

John W. Vinson said:
OH SMALL PROBLEM ARE BIG PROBLEM. ANYWAY I HAVE A STATEMENT IN VBA
SOMETHING LIKE THIS

"C:\BUSINESS\FURUC SPC\CUSTOMER FILES\ME.PART_INFORMATION.[PART_NUMBER].ACCDB"

WHAT I AM DOING IS CREATING NEW DATABASE, THERE IS FORM CALLED PART
INFORMATION, THERE IS A FIELD CALLED PART NUMBER.

I WANT TO PASS VALUE FROM PART NUMBER TO CREATE DATABASE PART_NUMBER.ACCDB.

I TRIED EVERY WHICH WAY BUT IT WON'T PICKUP VALUE FROM FIELD PART NUMBER

I KNOW I AM DOING SOMETHING HEADACHE

ANY HELP WOULD BE APPRECIATED

THANKS
Click to expand...

First off... please turn off your caps lock. It's hard to read all caps, and
it's considered impolite - it looks like you're SHOUTING AT US.

Please explain why you want to create an all new *database*. A database isn't
much like a document; it's a container for multiple tables, forms, reports,
code and other objects. A database *does not contain fields*; a database
contains Tables, each of which will have fields. It makes no sense to create a
database and "assign it a part number"; it makes even less sense to create a
new database for each part number!

What will you do with this database when you create it? What real-life task
are you trying to accomplish?

Please note: a response in all caps will be deleted, unread. If you don't like
using the shift key, all lower case is acceptable.

John W. Vinson [MVP]
Click to expand...
 
F

FAROOQ

FAROOQ said:
OH SMALL PROBLEM ARE BIG PROBLEM. ANYWAY I HAVE A STATEMENT IN VBA
SOMETHING LIKE THIS

"C:\BUSINESS\FURUC SPC\CUSTOMER FILES\ME.PART_INFORMATION.[PART_NUMBER].ACCDB"

WHAT I AM DOING IS CREATING NEW DATABASE, THERE IS FORM CALLED PART
INFORMATION, THERE IS A FIELD CALLED PART NUMBER.

I WANT TO PASS VALUE FROM PART NUMBER TO CREATE DATABASE PART_NUMBER.ACCDB.

I TRIED EVERY WHICH WAY BUT IT WON'T PICKUP VALUE FROM FIELD PART NUMBER

I KNOW I AM DOING SOMETHING HEADACHE

ANY HELP WOULD BE APPRECIATED

THANKS
Click to expand...
sorry i forgot to mention when i create new database, i also transfer 5
tables for data entry to that part number

thanks
farooq
 
J

John W. Vinson

anyway the reason for making seperate database for each part is keeping
each part seperate for spc reason. we work with one part to do statical
analysis.
each time we do part analysis we link to that database and do whatever we
want to do and unlink that database and go to next one
Click to expand...

How many records are there for each part? Millions? Hundreds of thousands?

If any less, then you would be much better off creating Queries to simply
select a subset of the tables, and base your statistical analysis on those
queries. You can't do statistical analysis on a Database, after all - only on
records in a query. Setting it up so that the query contains all of the
records in an extracted database does you no good at all, and simply makes
your task harder.

That said... you will need to construct a text string using the part number
and concatenate the rest of the desired database name. Something like

Dim strDBName As String
strDBName = "C:\BUSINESS\FURUC SPC\CUSTOMER FILES\" _
& Me![PART_NUMBER] & ".ACCDB"

and then use strDBName in the CreateDatabase method call. I don't have A2007
installed so I don't know if the syntax has changed since A2003, but I'd guess
that it has.

John W. Vinson [MVP]
 
Top