I know this is simple but I'm new to Recordsets and can't find the code.
I would like to create a temporary table when my form loads, it should
contain 3 numeric fields and 3 Yes/No fields. I need to write temporary
values to these fields when this form is open and then destroy the table when
the form is closed. I'm using a permanent table right now but soon the
program be in a multi-user environment.

Thanks,
Ken

Ken

I'm not there, so I can't be sure, but it sounds like another approach would
be to keep your table and add a User field. That way, the table could
handle multiple users.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"KPR" <(E-Mail Removed)> wrote in message
news:E18EB87E-1DBF-4D8F-873A-(E-Mail Removed)...
>I know this is simple but I'm new to Recordsets and can't find the code.
> I would like to create a temporary table when my form loads, it should
> contain 3 numeric fields and 3 Yes/No fields. I need to write temporary
> values to these fields when this form is open and then destroy the table
> when
> the form is closed. I'm using a permanent table right now but soon the
> program be in a multi-user environment.
>
> Thanks,
> Ken

you don't need to create a temp table

you can do all of tihs on a real table



"Jeff Boyce" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Ken
>
> I'm not there, so I can't be sure, but it sounds like another approach
> would be to keep your table and add a User field. That way, the table
> could handle multiple users.
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "KPR" <(E-Mail Removed)> wrote in message
> news:E18EB87E-1DBF-4D8F-873A-(E-Mail Removed)...
>>I know this is simple but I'm new to Recordsets and can't find the code.
>> I would like to create a temporary table when my form loads, it should
>> contain 3 numeric fields and 3 Yes/No fields. I need to write temporary
>> values to these fields when this form is open and then destroy the table
>> when
>> the form is closed. I'm using a permanent table right now but soon the
>> program be in a multi-user environment.
>>
>> Thanks,
>> Ken
>
>

Aaron Kem.pf has begun posting under a new alias.


"Tom Wimpernark" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> you don't need to create a temp table
>
> you can do all of tihs on a real table
>
>
>
> "Jeff Boyce" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Ken
>>
>> I'm not there, so I can't be sure, but it sounds like another approach
>> would be to keep your table and add a User field. That way, the table
>> could handle multiple users.
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "KPR" <(E-Mail Removed)> wrote in message
>> news:E18EB87E-1DBF-4D8F-873A-(E-Mail Removed)...
>>>I know this is simple but I'm new to Recordsets and can't find the code.
>>> I would like to create a temporary table when my form loads, it should
>>> contain 3 numeric fields and 3 Yes/No fields. I need to write temporary
>>> values to these fields when this form is open and then destroy the table
>>> when
>>> the form is closed. I'm using a permanent table right now but soon the
>>> program be in a multi-user environment.
>>>
>>> Thanks,
>>> Ken
>>
>>
>

Thanks Jeff, can I do this without having a user logging in?

"Jeff Boyce" wrote:

> Ken
>
> I'm not there, so I can't be sure, but it sounds like another approach would
> be to keep your table and add a User field. That way, the table could
> handle multiple users.
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "KPR" <(E-Mail Removed)> wrote in message
> news:E18EB87E-1DBF-4D8F-873A-(E-Mail Removed)...
> >I know this is simple but I'm new to Recordsets and can't find the code.
> > I would like to create a temporary table when my form loads, it should
> > contain 3 numeric fields and 3 Yes/No fields. I need to write temporary
> > values to these fields when this form is open and then destroy the table
> > when
> > the form is closed. I'm using a permanent table right now but soon the
> > program be in a multi-user environment.
> >
> > Thanks,
> > Ken
>
>
>