Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 23rd, 2005, 12:01 PM
Friend of Wrox
 
Join Date: Mar 2005
Posts: 264
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with bounded form query

Hi guys. I got a bounded form that supposed to allow me update/delete and add new records to project table.The form is displaying fileds from more the on table.(project,customer,department and employee tables)(linked to sql server tables). When i load the form i notice the drop down box does not show all values and i can not move trough records and ...I attempted to make the query in query design view but i do not know how to collect all the requried fileds.Furthermore, it is strange that i do not see the reletionships between query tables in query design view! I be happy if some expert teaches me how to fix this query.Thanks.

http://i5.photobucket.com/albums/y18...ormonload2.jpg
(form picture)


http://i5.photobucket.com/albums/y18...etionship4.jpg ( tables reletionships in sql server 2000)


http://i5.photobucket.com/albums/y18...tionships3.jpg

(table reletionships in access 2000 . I do not know why it does not show the reletionshops since i already defined the reletionships in sql server enterprize manger !)



http://i5.photobucket.com/albums/y18...etionship1.jpg

(form query )


Code:
SELECT dbo_Project.*, dbo_Customer.customername, dbo_Department.departmentname, dbo_Employee.lastname
FROM dbo_Project, dbo_Customer, dbo_Department, dbo_Employee;





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with adding deleting records in bounded method Access 1 July 30th, 2005 02:42 AM
How to add constraint to access bounded form. method Access 1 June 28th, 2005 10:39 AM
How to design a query for this bounded form method Access 0 June 24th, 2005 05:47 AM
Error updating record in bounded form method Access 0 June 19th, 2005 05:31 PM
How to delete current record in bounded form? method Access 0 June 19th, 2005 04:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.