Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2005

Tip: Looking for answers? Try searching our database.

Please Help: Find method and recordsets

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Belle - 22 Feb 2005 16:19 GMT
I have created a form called frmModify that is based on tblModify. Within the
form I have subform(called frmExisting).  On the the form Modify, I have a
list box where users can pick a conveyor to modify.  The only problem is that
the table Modify has many conveyors with the same name.  The way I'm
separating this issue is that a project name and description have to be
entered.  Within each unique project, the conveyor name has to be unque. This
works fine.

But all in all in my database i have several conveyor names that are the
same.  When using my list box to select the conveyor that I want to modify.  
It returns the conveyor BUT the conveyor that it returns is not in the
Project that I'm currently working on.

I think maybe the problem is the recordset.  Looking at the code it's using
the FindFirst property.  How can I code this to return the conveyor name that
correlates with the project and description that's being worked on?

I have a DAO database
Rick B - 22 Feb 2005 16:22 GMT
There is no need to post your issue in every newsgroup.  Do you really need
that many responses?  Do you really think it is efficient for multiple
people to work on your issue when you may already have an answer in another
group?

> I have created a form called frmModify that is based on tblModify. Within the
> form I have subform(called frmExisting).  On the the form Modify, I have a
[quoted text clipped - 14 lines]
>
> I have a DAO database
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.