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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"untranspose?"
If I have a table as such: Prov Num Field 123 aaa 123 bbb 123 ccc 456 xxx 456 zzz How would I go about getting: Prov Num Field1 Field2 Field3 123 aaa bbb ccc 456 xxx zzz- HubbleO
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Excel process left open by VBA
I'm using VBA in Access 2003 to open an Excel spreadsheet and dump data from two worksheets into two tables. The code does not work if Excel is already open, and once the code ends the Excel process is left running. To further complicate things even with just the process open the code does not...- HubbleO
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Insert Trigger for only some records
I currently have a table with many fields and want to add a record (with only some data) to a second table when a record is added to the first. When a record is added to the first table if the DOCNUMBR field of the record added starts with 'INV' I want to add a record to my second table. Fields...- HubbleO
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
Changing report section height
I tried changing the height of the detail section of a report using code in the open event of a form based on a option group on a form (i.e. selecting first option would have the section height .1667 and the second option would have the height .5). This didn't seem to work then I came across...- HubbleO
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
