View Single Post
  #3 (permalink)  
Old February 2nd, 2010, 08:04 AM
leonardpogrady leonardpogrady is offline
Authorized User
 
Join Date: Jan 2010
Location: Whitsundays Australia
Posts: 36
Thanks: 1
Thanked 0 Times in 0 Posts
Default MS Access SQL Problem

Hi Imar,

You are the hardest working man in this forum!

Recordset1 Inserts in my form shown below-

Code:
Company Name or Name of Partners: {Recordset1.CompName}
ABN / ACN: {Recordset1.CompABN_ACN}
Trading Name/s: {Recordset1.CompTradAs}
Trading Address: {Recordset1.CompTrdAdL1}
                       {Recordset1.CompTrdAdL2}
                       {Recordset1.CompTrdAdL3}
                       {Recordset1.CompTrdCrty}

Server behaviors below in same order-
<%= Recordset1.Fields.Item("CompName").Value %>
<%= Recordset1.Fields.Item("CompABN_ACN").Value %>
<%= Recordset1.Fields.Item("CompTradAs").Value %>
<%=(Recordset1.Fields.Item("CompTrdAdL1").Value)%>
<%=(Recordset1.Fields.Item("CompTrdAdL2").Value)%>
<%=(Recordset1.Fields.Item("CompTrdAdL3").Value)%>
<%=(Recordset1.Fields.Item("CompTrdCrty").Value)%>

Your Statement -

Also, are you sure the QueryString contains the correct value for each company?
No I am not sure at all, my experince writing querystrings is zip! This work was done by a former empoyee of mine years ago, I did work once but the data has been passed around to a few different devises over the years.

Above looks ok (unless you see somthing out of place I am not seeing) but
the Recordset1 SQL set up in the Server Behaviors I sent in the last post is probably not right. I say that because the above {Recordset1.CompName} and all the rest below it show the right value in each Recordset but is stuck on the first row of the table Company? no matter what login user/password is used and I have a different ID for each?

Cheers

Len
Reply With Quote