I can answer general Access questions and also specific ones about Replication. I am not a good person to ask Access 2007 specific questions. For free online Access tutorials, look here: http://webpages.charter.net/bobalston/AccessDB.htm#Free_Access_Online_Tutorials
Have worked with Access for over 10 years. Built one application for nonprofits that is used in over 235 nonprofits in the USA and Canada. Built an application using replication involving 25-30 laptops and three servers in three business sites each having three replicated master copies of the database.
www.techsoup.com - community - software forum
B.A. Mathematics; MBA
Phi Beta Kappa
What you propose is not a good approach. Instead make the primary key for the record an autonumbered field so it is unique by definition. Then the user's last name, first name and other data you store
Normally you do it the referse of what you are saying. YOu define fields on a form that will later be accessed by the module and used there. If you want to save the values from usage to usage, set up
I am available to answer specific questions of a technical nature. I am not available for free to design your database/system for you. Some free Access training is available here: http://webpages
It does work for me. I found the following in the HELP within Access Visual Basic for Applications Reference DateValue Function See Also Example Specifics Returns a Variant (Date). Syntax
Check your query very cafefully. Expand the column having the above expression. I will bet you will find an extra, unbalanced ")" at the very end.
Answers by Expert: