two questions...urgent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have to guestions:
i'm totally new to this access and vba stuff so i would really aprecialte a
detailed answer.
1.my first question is: i have a report that inludes a feild that starts
with numbers and ends with characters (say "1111test") and i need to get only
the numbers how do i do this? i know this is done using vba and some function
called "val" but i wasn't able to make the thing work.
2.my second question is: after i'm done with this report i want to export it
to a flat file. and no i can't got to file>export. i want it to have no
format just raw data. i also know that this is done thru vba and functions
like open(), write() but can you add more intfo

thank you very much
and i would apreciate a quick response
 
A text box with a control source of
=Val([YourField])
should display 1111 if it containts 1111test.

Not sure what you mean by "format just raw data".

Open any module and search help on "Open Statement"
 
what i need to do is create this report and feed it to an old mainframe
system. now the old mainframe system cannot understand the fancy access
report so i want to get only the data out of the report into a text file that
will be fed to the mainframe system. the text file will only have the data,
it will not be neatly formatted or anything. something like this
111abcd20050406 this is what i ment by raw data. i hope i got my point
accross.
i have another question. any ideas how to transform a date from mm/dd/yyyy
format to yyyymmdd format? is it possible to do that in a query or does it
have to be in a vba module?

thank you

Duane Hookom said:
A text box with a control source of
=Val([YourField])
should display 1111 if it containts 1111test.

Not sure what you mean by "format just raw data".

Open any module and search help on "Open Statement"

--
Duane Hookom
MS Access MVP


desprate said:
i have to guestions:
i'm totally new to this access and vba stuff so i would really aprecialte
a
detailed answer.
1.my first question is: i have a report that inludes a feild that starts
with numbers and ends with characters (say "1111test") and i need to get
only
the numbers how do i do this? i know this is done using vba and some
function
called "val" but i wasn't able to make the thing work.
2.my second question is: after i'm done with this report i want to export
it
to a flat file. and no i can't got to file>export. i want it to have no
format just raw data. i also know that this is done thru vba and functions
like open(), write() but can you add more intfo

thank you very much
and i would apreciate a quick response
Click to expand...
Click to expand...
 
Try press F1 and type in "how do i format dates".

You can conatenate lots of values together in an expression in a query.

--
Duane Hookom
MS Access MVP


desprate said:
what i need to do is create this report and feed it to an old mainframe
system. now the old mainframe system cannot understand the fancy access
report so i want to get only the data out of the report into a text file
that
will be fed to the mainframe system. the text file will only have the
data,
it will not be neatly formatted or anything. something like this
111abcd20050406 this is what i ment by raw data. i hope i got my point
accross.
i have another question. any ideas how to transform a date from mm/dd/yyyy
format to yyyymmdd format? is it possible to do that in a query or does it
have to be in a vba module?

thank you

Duane Hookom said:
A text box with a control source of
=Val([YourField])
should display 1111 if it containts 1111test.

Not sure what you mean by "format just raw data".

Open any module and search help on "Open Statement"

--
Duane Hookom
MS Access MVP


desprate said:
i have to guestions:
i'm totally new to this access and vba stuff so i would really
aprecialte
a
detailed answer.
1.my first question is: i have a report that inludes a feild that
starts
with numbers and ends with characters (say "1111test") and i need to
get
only
the numbers how do i do this? i know this is done using vba and some
function
called "val" but i wasn't able to make the thing work.
2.my second question is: after i'm done with this report i want to
export
it
to a flat file. and no i can't got to file>export. i want it to have no
format just raw data. i also know that this is done thru vba and
functions
like open(), write() but can you add more intfo

thank you very much
and i would apreciate a quick response
Click to expand...
Click to expand...
Click to expand...
 
Back
Top