Is it possible to pass parameters programmatically in a Microsoft Access update query I just tested this and it works in Access 2.Say you have a SELECT query with parameters PARAMETERS start.ID Long, end.ID Long.SELECT Members.WHERE Members.ID Between start.ID And end.ID. Free Download Webos For Nokia N900 User . You run that query interactively and it prompts you for start.ID and end.ID.That works, so you save that query as Member.Subset.Now you create an UPDATE query based on that query UPDATE Members SET Members.WHERE Members.Pko-8G3kyQ4/maxresdefault.jpg' alt='Microsoft Access Vba Sql Update Table' title='Microsoft Access Vba Sql Update Table' />
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |