PC Review


Reply
Thread Tools Rate Thread

unbound form with DAO recordset in Access 97

 
 
Marcel K.
Guest
Posts: n/a
 
      5th Nov 2003
Greetings - I have created a recordset (no type specified)
that uses the .absoluteposition to determine which record
user is on - then this .absoluteposition + 1 gets put into
text box indicating the record number. The problem I have
encountered is after saving a new record
the .absoluteposition property is no longer available. To
get around the problem I am having, I link the source
tables instead of having locally. Is there something that
linking forces a recordsettype to have that allows
the .absoluteposition proprety to always work , be
enabled, etc.

Thanks in advance for your reply.

Marcel K.


 
Reply With Quote
 
 
 
 
TC
Guest
Posts: n/a
 
      6th Nov 2003
Check out dbOpenTable versus dbOpenDynaset.

HTH,
TC


Marcel K. <(E-Mail Removed)> wrote in message
news:06df01c3a3a5$aae5bce0$(E-Mail Removed)...
> Greetings - I have created a recordset (no type specified)
> that uses the .absoluteposition to determine which record
> user is on - then this .absoluteposition + 1 gets put into
> text box indicating the record number. The problem I have
> encountered is after saving a new record
> the .absoluteposition property is no longer available. To
> get around the problem I am having, I link the source
> tables instead of having locally. Is there something that
> linking forces a recordsettype to have that allows
> the .absoluteposition proprety to always work , be
> enabled, etc.
>
> Thanks in advance for your reply.
>
> Marcel K.
>
>



 
Reply With Quote
 
 
 
 
Guest
Posts: n/a
 
      6th Nov 2003
Ahhhh....Now I see, thanks for the input.
>-----Original Message-----
>Check out dbOpenTable versus dbOpenDynaset.
>
>HTH,
>TC
>
>
>Marcel K. <(E-Mail Removed)> wrote in

message
>news:06df01c3a3a5$aae5bce0$(E-Mail Removed)...
>> Greetings - I have created a recordset (no type

specified)
>> that uses the .absoluteposition to determine which

record
>> user is on - then this .absoluteposition + 1 gets put

into
>> text box indicating the record number. The problem I

have
>> encountered is after saving a new record
>> the .absoluteposition property is no longer available.

To
>> get around the problem I am having, I link the source
>> tables instead of having locally. Is there something

that
>> linking forces a recordsettype to have that allows
>> the .absoluteposition proprety to always work , be
>> enabled, etc.
>>
>> Thanks in advance for your reply.
>>
>> Marcel K.
>>
>>

>
>
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unbound forms and dao recordset question NKK Microsoft Access Form Coding 1 23rd Dec 2008 03:58 AM
DAO.Recordset and DAO.Database Help James Microsoft Access 2 20th Jun 2006 06:47 PM
DAO.Recordset and DAO.Database Help James Microsoft Access 0 20th Jun 2006 05:18 PM
How to create login form using DAO.recordset on a unbound form =?Utf-8?B?TWFrYWkgZnJvbSBEZW5tYXJr?= Microsoft Access VBA Modules 3 28th Dec 2005 11:54 PM
help convert DAO.Recordset to ADODB.Recordset =?Utf-8?B?Uk5VU1pAT0tEUFM=?= Microsoft Access Forms 1 27th Feb 2005 08:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:53 AM.