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 SkipVought 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: *

  1. dropspun

    Convert an Access table to SQL Server table programatically

    I'm new to ASP.NET. Does anyone have any tips on how to convert a Microsoft Access table into an SQL Server table in code-behind? I know there's got to be a way. I've gotten as far as getting an Accessdatasource and an SQLDataSource, but there my knowledge stops.
  2. dropspun

    "Identifier Expected" Error Message

    Help! I get an "Identifier Expected" error right beneath the open parenthese in (DataSourceSelectArguments.Empty). Can anyone tell me what can be done to rid myself of this error message? Protected Sub btnImport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles...
  3. dropspun

    Sub procedure stops at beginning

    Thank you all for your suggestions. Yes, I did try doing a compact and repair (pwise) and rebooting my pc (judgeh59) and clearing the break points (hap007). I did try putting in DoCmd acCmdClearAllBreaks, but couldn't get it to work -- my fault, it's a little above my skill level...
  4. dropspun

    Sub procedure stops at beginning

    Thanks dhookom. Putting in DAO didn't change anything, but I'm grateful for your time.
  5. dropspun

    Sub procedure stops at beginning

    I have a sub that I'm calling from a macro: Module Name: GeneralFunctions Procedure Name: SequentialNumber The program won't execute the sub; it simply stops at the first line of it and pulls up the "General Functions" screen as though I'm debugging. I can click the "Run" menu option...
  6. dropspun

    TransferText Exports Wrong Number

    JerryKlmns, Thanks! I tried your suggestion and it worked!!
  7. dropspun

    TransferText Exports Wrong Number

    lameid, This problem exists no matter which computer is used. I've tried changing the field to text, but that just makes it display 3.63797880709171e-12 instead of zero. -- dropspun
  8. dropspun

    TransferText Exports Wrong Number

    I'm doing an export using transfertext. I'm exporting a table with only one record. The last field in the record contains only zero (and is a number, double, with two fixed decimal places). Suddenly, after months of working correctly (by exporting 0) this zero is being exported as...
  9. dropspun

    Automating the Generation of SQL Table Structure Files

    Does anyone know how to automate the generation of the SQL files that show each table's structure in a database? I have 150 tables in one database and do NOT want to generate the SQL for them one-by-one. For my sins, I am using PowerBuilder 6.5 on a Sybase 11 server. I want to have this...
  10. dropspun

    Access 97 to Access 2000 Sort Order Question

    Thank you MajP, I appreciate your reply. But, although both databases are identical (except that one is in Access 97 and the other is in 2000), these table names show up in the order shown above even after I sort in ascending order. I did the sort by going to the "Tables" tab and clicking on...
  11. dropspun

    Access 97 to Access 2000 Sort Order Question

    I'm in the process of converting Access 97 databases (on a Windows 98 operating system) to Access 2000 (running on a Windows 2000 operating system. Has anyone else noticed that the tables on the "Tables" tab sort slightly differently in 2000? I'm not referring to records within the tables, but...
  12. dropspun

    problem with PFC

    Yes, you can disable services for just one window. How easy (or hard) this is to do depends on where in the inheritance scheme you enabled the window's services. . If Windows B and C are inherited from Window A AND . Window A is where the services were enabled AND . Window B is the window you...
  13. dropspun

    Why won't my PFC drop-down search service work?

    Here's something they don't tell you in the manual...you must have the drop-down's "Allow Edit" property checked. Can't tell you how much time I lost figuring that one out!!!

Part and Inventory Search

Back
Top