Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CALCULATED CONTROLS
sum([TextA]) + Sum([TextB]) should work- rileynyc
- Post #2
- Forum: Microsoft: Access Forms
-
Hiding or Making a Form Invisible?
forms!login.visible = false you can then set it to true whenever you want- rileynyc
- Post #5
- Forum: Microsoft: Access Forms
-
Using Access over a network
FYI Front Ends should always be put on the local pc, seperate front ends on a shared drive is better than sharing one front end, but performance will dramatically increase if the front end is placed somewhere on the local drive. There are a million different ways of deploying updates to all the...- rileynyc
- Post #9
- Forum: Microsoft: Access Other topics
-
Merge data in Access
In the field(s) on the master file where you have data that you do not want overwritten, set the criteria to "Is Not Null" within the query builder. It will then only update data when the master field is blank. Does that help?- rileynyc
- Post #4
- Forum: Microsoft: Access Other topics
-
Merge data in Access
It should be fairly easy using an update query or two. Are any of the fields duplicated? If so, which data do you want to keep? Another way to easily merge data is to use a make-table query, pulling your data from the two tables and producing a merged resultant table. Hope that helped a...- rileynyc
- Post #2
- Forum: Microsoft: Access Other topics
