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 TouchToneTommy 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: jsanderson
- Content: Threads
- Order by date
-
help with module to export fixed-width text file
I am writing a module to export the results of a query to a fixed width text file. I am using the MSKB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q210052 as an example. The only difference that I can see is that the example is based on a table with a primary key and mine is...- jsanderson
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Exporting to Fixed Width text file - formatting problems
I have a query designed that creates all of the data in the proper order and formatting (mostly). On my main form I have a command button with the Click event set up as follows: Private Sub cmdRunReport_Click() DoCmd.TransferText transfertype:=acExportFixed, _...- jsanderson
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Probably a simple question re: table design
I have two sets of data to store: Property Number and Unit Number. Property number is unique but Unit Number may duplicate across multiple properties. So in my table, I have a UnitID field set to autonumber to keep each unit separate. The problem is this: How do I keep the data entry form from...- jsanderson
- Thread
- Replies: 14
- Forum: Microsoft: Access Tables and Relationships
-
Linked Combo Boxes
I have a two table database (tblUnits, tlbPayments) with two forms (frmUnits, frmPayments). The fields of tblUnits are UnitID(primary key), PropertyNumber, UnitNumber, FirstName... The fields of tlbPayments are PaymentID (primary key), UnitID, PaymentAmount.... There is a one-to-many...- jsanderson
- Thread
- Replies: 1
- Forum: Microsoft: Office
