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 / Forms / May 2007

Tip: Looking for answers? Try searching our database.

Cannot synch info or enter data into form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
joet5402 - 22 May 2007 14:05 GMT
First time poster...I have created a popup form from another form that
includes the following information:

WORK ORDER # (PK)
TECHNICIAN    TECHNICIAN 2    TECHNICIAN 3    TECHNICIAN 4    TECHNICIAN 5    TECHNICIAN
6    TECHNICIAN 7    TECHNICIAN 8    TECHNICIAN 9    TECHNICIAN 10   
START DATE    START DATE 2    START DATE 3    START DATE 4   
START DATE 5    START DATE 6    START DATE 7    START DATE 8   
START DATE 9    START DATE 10   
END DATE    END DATE 2    END DATE 3    END DATE 4   
END DATE 5    END DATE 6    END DATE 7    END DATE 8   
END DATE 9    END DATE 10   
START TIME    START TIME 2    START TIME 3    START TIME 4   
START TIME 5    START TIME 6    START TIME 7    START TIME 8   
START TIME 9    START TIME 10   
FINISH TIME    FINISH TIME 2    FINISH TIME 3    FINISH TIME 4   
FINISH TIME 5    FINISH TIME 6    FINISH TIME 7    FINISH TIME 8   
FINISH TIME 9    FINISH TIME 10   
CHARGE TIME    CHARGE TIME 2    CHARGE TIME 3    CHARGE TIME 4   
CHARGE TIME 5    CHARGE TIME 6    CHARGE TIME 7    CHARGE TIME 8   
CHARGE TIME 9    CHARGE TIME 10

I am trying to...
a.  synch the popup form to the original form
b.  enter data into the popup form (this form will not allow me to enter data,
but will show the data if it is entered into the table)

What is the easiest way to go about this?  ("Easiest" may not be the best
word to use when discussing Access)  

Thanks
Rob Parker - 22 May 2007 14:21 GMT
The very first thing you should do is stop using this database in its
current form.

The second thing you should do is read, learn, and inwardly digest what a
relational database is about.  Start with normalization, and try the links
at
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

Then, re-design your tables.

Then try again - it will certainly be easier than it is now ;-)

HTH,

Rob

> First time poster...I have created a popup form from another form that
> includes the following information:
[quoted text clipped - 29 lines]
>
> Thanks
 
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



©2009 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.