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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: brucerichards
- Order by date
-
how rendomize records
Add a flag to each record, say called selected. Open a recordset of all data where selected is false. Get a random number based on the number of records in the recordset. e.g. Int((MyRecordset.Recordcount - 1) * Rnd + 1) Move through the recordset that many times, get the data and set the...- brucerichards
- Post #2
- Forum: Microsoft: Access Forms
-
Lock a record after change in data
Once the field has been ticked, you need to force a save (i.e. form requery) and the reopen the form, without closing it as read-only. e.g. Forms("MyForm").Requery DoCmd.OpenForm MyForm, , , MyUniqueID = CurrentUniqueID , acFormReadOnly The record will now be locked.. Obviously...- brucerichards
- Post #2
- Forum: Microsoft: Access Forms
-
Database Records on Web Pages
I want to be able to load a web page, have the user enter data, perhaps load a different page in the same browser window and then return to their original page where their previously entered data still resides. I don't want to commit the record to SQL until it is complete. I was thinking of...- brucerichards
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
