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!
-
Referential Integrity issue doing an Insert to SQL
I also forgot to mention, both these tables have an autonumber field.- sts125
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Referential Integrity issue doing an Insert to SQL
I am trying to insert records into a Microsoft Dynamics database (SQL). I believe there is Referencial Integrity set up between two files. I load the SQL Insert statement for one of the 2 tables then issue: DoCmd.RunSQL sqlInsert (sqlInsert contains my insert statement) I get "Microsoft...- sts125
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need routine to set report to print on legal size for Access 2007
The routine actually works in 2007. It was where I was calling it from that was the problem. Putting it in the form load in my switchboard did the trick.- sts125
- Post #2
- Forum: Microsoft: Access Reports
-
Need routine to set report to print on legal size for Access 2007
Found routines to set a report to legal size print on the Microsoft website. There is a version for Access 97, and one for Access 2000. I am using Access 2007. I created a new module, and pasted the Access 2000 routine in. When I execute it, it dies at this line: rpt.PrtDevMode =...- sts125
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Skipping Detail Lines
I have a report in Access 2007 that consist of a Report Header, Page Header, "Employee_ID" footer, Page Footer, and Report Footer. I am basically printing a summary line for each employee ID with totals. Currently I am not printing any detail lines, but would like to see if there is a way to...- sts125
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
