Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Trying to set DefaultValue based on ServerFilter value in ..

 
   Database Forums (Home) -> MS Access -> Data Access Pages RSS
Next:  Jdbc Oracle getMetaData is slow?  
Author Message
frustyak

External


Since: Mar 20, 2006
Posts: 2



(Msg. 1) Posted: Mon Mar 20, 2006 1:49 pm
Post subject: Trying to set DefaultValue based on ServerFilter value in Ac
Archived from groups: microsoft>public>access>dataaccess>pages (more info?)

I'm accessing two tables using data access pages and framesets. Here's
the scenario:
Two tables, A and B, with a 1 to many relationship between the two (A
has 1, B has 0 to any number of matching rows). The column used to link
the two is called 'intmid' in both tables.
Each of the tables has it's own Data Access Page, and there is one html
file called
'mainpage.htm' with two frames, one for each page. Whichever record you
have from table A, it's intmid value is passed as a ServerFilter to the
other DAP and the corresponding records from table B are shown (one per
page) in the other frame. You are then free to peruse the corresponding
records from table B in the frame.
This works great, EXCEPT when there are no corresponding records from
table B for a given intmid value. In that case, all the textbox fields
in the second frame are blank. When the user needs to add a record to
table B I need to have the intmid field already filled in with the
intmid value from the calling frame.
Ideally, I want to set the DefaultValue parameter for the intmid field
but I can't figure out how to do that. I've been able to hardcode a
DefaultValue, but that's obviously useless to me. I can parse an http
string ("webpage.htm?intmid=value1&whatever=value2....") but
successfully setting the DefaultValue in the called page using this
method has eluded me.
I'm open to any suggestions that involve VBScript, Javascript, or
modifying the Property page for the intmid field. There is no web
server involved here, so anything ASP-dependent is out.
Thanks in advance for any help given.
Regards,
Frank Rustyak

 >> Stay informed about: Trying to set DefaultValue based on ServerFilter value in .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Populate one drop down based on the selection of another - Hello, I have been trying to find a solution to this problem with no success. I was wondering if someone could tell me how to populate one drop down list based on the selection of another in a data access page. I know how to do this in an access..

Please help me with updating a form combobox (or table fie.. - I have three tables: Courses (Key is Autonumber Course Number, also have Text Course Name); Instructors (similar fields); and Courses and Instructors (have a combination of the four fields). Currently, if I manually select the course from the drop-down....

DAP Find not always working - We have a DAP shoing both a spreadsheet as well as a form. The code below is being used to find records on the form but this does not work whilst viewing the first 4 records on the database, once we skip to the 5th record, the find starts to work. It....

Creating Data Access Pages - I am very new to DAPs. I have created one using a wizard & everything is fine. I can edit it in design view. I then save it & can open it & use it BUT I can't change the design. When i try to open it in design view, Access fails with a ter...

Sending e-mail after Data Access Page is updated - I have a data access form to collect information about users with computer problems. I want my data access page to send an e-mail automatically after the page has been updated. Is there any way to do this. Please help.
   Database Forums (Home) -> MS Access -> Data Access Pages All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]