copy data to new record

[Karen Skipper]

I've been working on this code and now get an error saying " invalid use of
null". How do I handle null fields (they are okay in what I'm doing)?
Sample of code below:

'save data in fields
emailvar = Me!
extvar = Me![EXTENTION]
phonevar = Me![PHONE]
faxvar = Me![FAX]
origvar = Me![originator]

'code in here to append a new record to the table

'copy data in fields
Me![EMAIL] = emailvar
Me![EXTENTION] = extvar
Me![PHONE] = phonevar
Me![FAX] = faxvar
Me![originator] = origvar


Any help?

Karen

 

[Larry Daugherty]

If you dimmed your variables as string you may need to dim them as variant.
Variant can handle null but a string type can't.

hth
--
-Larry-
--

I've been working on this code and now get an error saying " invalid use of
null". How do I handle null fields (they are okay in what I'm doing)?
Sample of code below:

'save data in fields
emailvar = Me!
extvar = Me![EXTENTION]
phonevar = Me![PHONE]
faxvar = Me![FAX]
origvar = Me![originator]

'code in here to append a new record to the table

'copy data in fields
Me![EMAIL] = emailvar
Me![EXTENTION] = extvar
Me![PHONE] = phonevar
Me![FAX] = faxvar
Me![originator] = origvar


Any help?

Karen

[QUOTE="Kevin @ 3NF"]
Alternatively, if you just want specific fields, create a bit of VBA[/QUOTE] code[QUOTE]
to
create a variable for each item you want to copy, populate that variable
with the existing infomration, move to the next record, then set the
controls to the value of the varible.

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



is
used due[/QUOTE]
[/QUOTE]

 

[Karen Skipper]

Thanks, That seems to fix the problem.

FYI-
I also found that I have to have the docmd.Echo true (there is a docmd.echo
false at the beginning of the code) after the section that fills in the new
fields or some of them appear to be empty until I move to the previous
record and back to the new one. I had it in the section where the new
record is appended. I'm not sure that even helps keep the user from seeing
the form change and the fields get filled in.

Karen

If you dimmed your variables as string you may need to dim them as variant.
Variant can handle null but a string type can't.

hth
--
-Larry-
--

I've been working on this code and now get an error saying " invalid use of
null". How do I handle null fields (they are okay in what I'm doing)?
Sample of code below:

'save data in fields
emailvar = Me!
extvar = Me![EXTENTION]
phonevar = Me![PHONE]
faxvar = Me![FAX]
origvar = Me![originator]

'code in here to append a new record to the table

'copy data in fields
Me![EMAIL] = emailvar
Me![EXTENTION] = extvar
Me![PHONE] = phonevar
Me![FAX] = faxvar
Me![originator] = origvar


Any help?

Karen

[QUOTE="Kevin @ 3NF"]
Alternatively, if you just want specific fields, create a bit of VBA[/QUOTE] code[QUOTE]
to
create a variable for each item you want to copy, populate that variable
with the existing infomration, move to the next record, then set the
controls to the value of the varible.

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



I also have Access 2002...

Create a button on your form and use the wizard to fire off the Duplicate
Record command (from Record Operations). This has the effect of[/QUOTE][/QUOTE] doing[QUOTE]
a number
due
[/QUOTE]
[/QUOTE]