Search results for query: *

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...

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

...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 & DSN-less connections. Prior to the install of...

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"...

....CursorType = adOpenStatic .LockType = adLockOptimistic .CursorLocation = adUseServer .Open "SELECT * FROM tblFieldTagNotes" End With With rst .AddNew !FieldNotesDate = Me.txtUnboundDateField !FieldNotesText=txtUnboundTextField...

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...

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...

...is an evolutionary process. You may use any point to start and then move forward. As a side note, this forum focuses on MS Access Projects for *.ADP databases that work with SQL Server 2000. If you are starting out, I recommend HIGHLY, that you start with a *.mdb MS Access database and...

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...

...F8. 6. You will see the program work as you step through the code at the same time. (I always think that is neat! :) ) Option Explicit ' **** Start the program by placing cursor inside ' **** of the Wrapper function code and pressing F8 Public Function Wrapper() NameMyRanges...

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...

...whether it's for 5 switchboard buttons or 8 will save a lot of questions asked by the users concerning missing buttons or empty spaces. ************************************************** If GetAbility(UserName) = "Admin" Then Me.txtBox1.Visible = True Me.txtBox2.Visible =...

...work. When you get close, the error messages will start telling you which argument or part is not working. I finally got it by trial and error. ********************************************** DoCmd.TransferDatabase acExport, "Microsoft Access&quot...

...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 PASSWORD_1() As Variant PASSWORD_1 =...

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

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...

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...

...view. The records are not editable when the rs is assigned to the recordset property. THANK YOU in advance for your help! ' **** This section is to check for open connections *** If cnn.State = adStateOpen Then CurrentProject.CloseConnection Else...

[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...

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...