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!

Register Log in
  • Congratulations Rhinorhino 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. smuckers

    Query Analyzer - Alter Table shortcut menu item is disabled

    Good Morning: When using Query Analyzer with the Developers' Edition of SQL Server 2000, on my XP Pro, Office 2003 desktop, the "Alter" item in the shortcut menu is disabled when viewing the "Script Object to ..." shortcut menus, after right clicking a table name in the object pane. For...
  2. smuckers

    Normal ASP connection to Access Fails, .Net Issue?

    Good Morning FesterSXS: Thank you for your response. I doublechecked those settings and no luck so far. Smuckers "May your hysterical randomness be cured!"
  3. smuckers

    Normal ASP connection to Access Fails, .Net Issue?

    Good Afternoon: I am trying to use a normal ASP program with approximately 50 asp files. The setup file that uses a connection string to MS Access fails. Now after trying the simplest of *.asp file connections to the MS Access Northwind.mdb database, that fails too. I tried using DSN &...
  4. smuckers

    Find Empty Fields in a Table and Propagate Them?

    Good evening dtrahokie: I had to make the assumption that the last Update Number was the Maximum value and that the two tables were not joined. Note, this query is unique to MS Access only. The T-SQL version for Update does not work for MS Access in this instance, thus the use of the "DMax"...
  5. smuckers

    Autopopulate to new line in table

    Good Evening kdoran: I use the following process of adding info to a new line in a table. To summarize: 1. Declare and open an ADO recordset. 2. Must use the ".AddNew" and ".Update" statements if adding a new line to a table. 3. I assume you have an autonumber field, FieldTagNotesID, as...
  6. smuckers

    using T-SQL in Access

    Good Morning Machiaveli: This has worked for me with very low maintenance. 1. In Query Analyzer, start by verifying the proper functioning of a stored procedure calling a DTS package. 2. In Access, use the command ADO object to pass in parameters(s) and to run the stored procedure. Be sure...
  7. smuckers

    Cannot update Bound Textboxes

    Good afternoon Cranebill: Your original question was to see how the SQL string could be updateble. Review all the tables that are pulling data and look at the tables in the database relationships view. To be updateable, include those tables that are acting as bridges or connections between...
  8. smuckers

    HELP! I'M GOING NUTS trying to figure out how to do this

    Good Morning pzaman1077: From your description it sounds like you are very busy. My approach is non-standard but I believe in your situation it my be helpful. I'll leave that up to you to decide. First of all, this is an evolutionary process. You may use any point to start and then move...
  9. smuckers

    MS Access and SQL

    Good afternoon Masaud: This is how I got started. I learned SQL with a free program called WinSQL. It can be used for MS Access, SQL Server 2000, MySQL, AS-400 and many other applications with tables. The interface is very user friendly. Using WinSQL and MS Access Query interface, I was...
  10. smuckers

    Transfer data from Acces to Excel, Initializing loop, Compare record

    Good afternoon noorani: After reviewing your code and your problem statement, I think I can help. Unfortunately, I do not believe that there is only one problem. I offer to you a series of code tests to try. The result will be this problem being resolved or determing that Excel is not the...
  11. smuckers

    DoCmd.TransferDB Settings.

    Good Morning mikeyb540! I have experienced similar issues and handled them 2 different ways. Each time my objective was to force a change in the link/connection causing it to reset itself. Sorry, this is not good programming methodology but these two techniques have proven themselves. My...
  12. smuckers

    database startup

    Good Afternoon cg084! Hmm... I have used various security schemas without the Security Wizard. The code snippet below will restrict access to forms, buttons, controls or other objects. You'll need a couple of tables that will hold the following information: 1. Users Names 2. Passwords 3...
  13. smuckers

    Having a hard time setting up a Tra

    Good Afternoon mikeyb540! I used the following statement to successfully transfer and export form objects. Perhaps including quotes and fully qualified paths the statement will work. When you get close, the error messages will start telling you which argument or part is not working. I...
  14. smuckers

    Locate passwords in a single module

    Good Afternoon kennetha! Yes,I do it this way and as long as the file is open the username and passwords may be used at any time. I first create a Class Module and name the properties. I named the class clsLogOn. ******************************************************** Public Property Get...
  15. smuckers

    What reference do I check to use Left and Right string functions

    Good Afternoon pdbowling! I checked the Left$ method in the object browser of the VBE and found the Library to be VBA, or the Visual Basic Applications library. Hope this helps. Sincerely, Smuckers
  16. smuckers

    Bizarro Column Order

    Good Afternoon! I can't explain why but I can tell you what I did to fix the problem. My Projects use stored procedures as much as possible and these problems occur from time to time when using Form-datasheet views. In this case, I open the form in Normal view and click on the column heading...
  17. smuckers

    Turn off Shift Bypass key in .adp

    Good Afternoon! Below it the title of the article that relates to the startup properties of a Project. The article covers programming in both the *.adp and *.mdb environments. I have used it to set a few of the properties for my applications. Sorry, I have not used it for the ByPass key yet...
  18. smuckers

    Form - Dynamic ADO Recordset not editable

    Good afternoon! I am unable to edit an ADO recordset for a Form using Stored procedures. It works when the form has the property "Recordsource" set directly to a single table but not when it is dynamically changed using the code below. I created a small table of 3 records with 3...
  19. smuckers

    Data Access Pages

    [b]Good Afternoon! Open the DAP in Design mode and select the "command" button control from the toolbox. Make sure the wizard is on when the button is selected. It will walk you through the process. The result is a button that will save and advance the existing DAP entries and...
  20. smuckers

    Locking error, "File already in use", Back- End, A2K

    I have a split MS Access 2000 database, unsecured, on a network. The FE is shared via a common shortcut. The program locks out multiple users. When I click directly on the BE file, the error message, "Could not use "G:\Database_be.mdb"; file already in use" displays. I...

Part and Inventory Search

Back
Top