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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Updating Tables from a Batch Transaction File
Here is a piece of code I use when I proces a series of records. Maybe this will inspire u: Sub runrecs() Dim dbs As Database Dim rs As Recordset Set dbs = CurrentDb Set rs = dbs.OpenRecordset("[Query A and B]") With rs Do While Not .EOF .Edit !field_in_B = "Some value" .Update...- pcgram
- Post #2
- Forum: Microsoft: Access Other topics
-
Right String
Decide wether u want to change your data into the decimal part. I.e. change the number 7.85 into 0.85 or do u want to view it as 0.85. In the first case u would make an update-query, updating Number to Number - int(numer). In the later case, u would make a select query DecNumber: Number -...- pcgram
- Post #4
- Forum: Microsoft: Access Other topics
-
Scanner as object type
In a db I store passport-size pics. I want to save the picture and not a link to a file in the db. Worked well for some time, but then I bought a new SONY flatbed scanner. Now there is no *scanner* object in the list of available OLE-objects. How can I manually or automatically update the...- pcgram
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
