Search results
-
K
Append Current Record on a Form using Form Button
Error Message Hi Chris, The Prem_iD field in tblLicensedPremHistory is NOT an autonumber datatype. The error message I am getting is as follows: Run-time error '3134': Syntax error in INSERT INTO statment. When I go into debug the arrow points to the line ---> db.Execute strSQLAp...- KevinC
- Post #3
- Forum: Modules & VBA
-
K
Append Current Record on a Form using Form Button
Hi All, I have two tables: tblLicensedPrem and tblLicensedPremHistory (these tables are identical). tblLicensedPrem contains records for licensed premises. Over time details of a licensed premises change: e.g. the premises changes its company name, opening hours, manager, telephone number etc...- KevinC
- Thread
- Replies: 3
- Forum: Modules & VBA
-
K
Create Un-aggregated Records Table
Hi, I have a database that contains a table with an administration area and a number associated with the “count” of a certain characteristic of that area. For use in another piece of software I need to convert the count system to individual records. For example I need to go from: AREA COUNT...