Sign Up |  Live StatsLive Stats    Articles 35,345| Comments 159,790| Members 17,820, Newest waheguruhelpme| Online 206
Home Contact
 (Forgotten?): 
    Sikhism

   
                                                                     Your Banner Here!    

problem displaying specific record

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 400 USD, Received: 35 USD (9%)
Please Donate...
Related Topics...
Thread Thread Starter Forum Replies Last Post
Open combo box to specific record Economics Information Technology 4 28-Jul-2006 08:31 AM
problem displaying specific record martin.ryan@esbi.ie Information Technology 0 28-Jul-2006 08:30 AM
Open subform to a specific record fabianjones@gmail.com Information Technology 0 28-Jul-2006 08:17 AM
RE: print a specific record Ofer Cohen Information Technology 0 28-Jul-2006 07:59 AM
Current record not displaying properly alaskahawk Information Technology 2 17-Nov-2005 18:02 PM


Tags
problem, displaying, specific, record
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #10 (permalink)  
Old 28-Jul-2006, 08:31 AM
Rick Brandt's Avatar Rick Brandt
Guest
 
Posts: n/a
   
   
Re: problem displaying specific record

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
MartinR wrote:
> This is what it says in the filter part under the data tab.
> ((Spares.[No]=651))
>
> What way should i now change my code?


Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12605-problem-displaying-specific-record.html
That suggests that your RecordSource for the form has two fields both named
[No] so Access is appending the TableName-Dot in front of them to
distinguish. You either need to eliminate one of those from the query or
modify your code so it also includes the TableName-Dot notation...

Private Sub index_DblClick(Cancel As Integer)

Dim stDocName As String, stLinkCriteria As String

stDocName = "Sparesform"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
stLinkCriteria = "Spares.[No] = " & Me![index]

DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com





 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!
Reply With Quote
Sponsored Links
  #11 (permalink)  
Old 28-Jul-2006, 08:31 AM
MartinR's Avatar MartinR
Guest
 
Posts: n/a
   
   
Re: problem displaying specific record

  Donate Today!  

that worked perfect. I see my mistake now.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
again thank you.

Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
Display Modes

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 On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Gurbani Jukebox
Listen to Gurbani while surfing SPN!
» Active Discussions
sikhism Who is "Mohan"?
Today 08:46 AM
22 Replies, 335 Views
sikhism How important is Matha...
Today 08:12 AM
59 Replies, 1,038 Views
sikhism need urgent advice.......
Today 06:46 AM
6 Replies, 81 Views
sikhism ਨਾਮਾ
Today 06:37 AM
2 Replies, 53 Views
sikhism Sikh Diamonds Video...
Today 04:23 AM
6 Replies, 116 Views
sikhism Are Creator and Creation...
Today 01:30 AM
44 Replies, 2,837 Views
sikhism Herman Hesse,...
Today 00:54 AM
13 Replies, 229 Views
sikhism On a Scale of Most...
Yesterday 21:42 PM
30 Replies, 1,277 Views
sikhism I became victim by...
Yesterday 19:50 PM
0 Replies, 44 Views
sikhism Sikh Books downloads
Yesterday 15:39 PM
2 Replies, 66 Views
sikhism Salok Sheikh Farid ji...
Yesterday 09:35 AM
0 Replies, 47 Views
sikhism In Punjab, three farmers...
Yesterday 05:36 AM
0 Replies, 49 Views
sikhism Supernatural Sikhs, what...
Yesterday 03:45 AM
19 Replies, 414 Views
sikhism Sukhmani Sahib Astpadi...
26-May-2012 22:57 PM
0 Replies, 51 Views
Do You Think You Are...
26-May-2012 09:59 AM
94 Replies, 8,258 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.2

All times are GMT +6.5. The time now is 09:08 AM.
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.5.2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.26416 seconds with 30 queries