Help: Need to get results to in a table..

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

Guest

Help, I have a function that will convert bytes to gb, mb etc. I am very
new to programming and writing functions and my issue is: I can call the
function and enter in my value and get the answer in the immediate window,
but how do I get that same answer to be written to a table automatically.

Example: Results in the immediate window
? SetBytes (79990845440)
74.50 GB

I would like to have this 74.50 GB written to a field in a access table:
Please give me some insight on how to proceed. I have done many searches with
no good result. Thanks
 
there are several ways to do it, "how" depends partly on the circumstances:
do you want to update a field in an existing record in the table? or do you
want to append the data into the table as a new record? where are you
calling the code from - a form? if so, is the table in question bound to the
form? more specific information, please.

also, is this a calculated value? are the "raw data" values, used in the
calculation, already being saved somewhere in the database? if so, the
general rule is that calculated values should not be saved as hard table
data. there are always exceptions to a rule, so you need to decide if you
have a sound business reason for writing calculated values to a data table.

hth
 
Back
Top