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

    SQL Server 7.0 talking to SQL Server 2000

    The other server is a SQL Server 2000. In SQL Server 2000 you can have several "instances" of SQL Server on one server. So that is not actually the domain name, but the name of the server, and that instance of SQL Server 2000 is the NAICT011/MFGSQL. For posparity sake, the final...
  2. mesavage

    SQL Server 7.0 talking to SQL Server 2000

    ...exec sp_addlinkedsrvlogin 'NAICT011\MFGSQL', FALSE, NULL, 'engdb', 'engdb' Then, I attempted to do the following query: select * from [NAICT011\MFGSQL].[Drive Loaner Test].[dbo].[tbl_Drives_Out] where userid='mbenue' I get the following error: [OLE/DB provider returned message...
  3. mesavage

    Access Denied Problem

    OK, please forgive me as I do not know a whole lot about networking. This is not my area of expertise, and somehow I was sucked in to fill in for a guy on vacation. I have four different PCs, all on the same network and setup the same way (i.e. logged in the same username/password and into the...
  4. mesavage

    Limit selected items in list box?

    Is there a way that once the user has selected a certain maximum for the list box, to disallow them to select anymore? I would like to limit my user to be able to select a maximum of 10 items, with multi-select set to extended. Any help is greatly appreciated, thanks! Miriam
  5. mesavage

    CurrentProject.Connection and Password

    OK I fibbed in the previous post. I think that I accidentally did have the "allow save password" on or something. Anyhow, I went ahead and implemented the idea to have the dummy username and password. However, my recordset is not updateable when I do this. Here is my code to start...
  6. mesavage

    CurrentProject.Connection and Password

    OK, I later found the solution. The CurrentProject.Connection.ConnectionString property gives the password. So when I create the new connection for the transaction, I just need to add this ".ConnectionString" to the end and it works! Miriam
  7. mesavage

    CurrentProject.Connection and Password

    That is a very good idea. I have four different sets of permissions (with two more coming later). It could get a little messy figuring out who has what permission, but it is better than nothing! :o)
  8. mesavage

    CurrentProject.Connection and Password

    My problem is this: I have an Access Project connected to an SQL Server. The user is required to login when the project is opened. Since the "allow saving password" is unchecked in the connection window (because I want users to have to login), then the CurrentProject.Connection does...
  9. mesavage

    Report Spacing Problem

    OK, I doubled checked just to be sure, they are all the same height and and are lined up properly. So I guess that's not it... Miriam
  10. mesavage

    Report Spacing Problem

    Thanks, but that isn't it. I just checked, it is none. Miriam
  11. mesavage

    Report Spacing Problem

    I have an Access report. I print several fields out that are the result of a query. It looks something like the following: fld1 fld2 fld3 fld4 fld5 fld6 fld7 fld8 All the fields are bound text boxes. I have the can shrink/grow properties set to "no". Everyone once in awhile I...
  12. mesavage

    adding a bowse button to a form

    Oh that works wonderfully! Thanks! :o) Miriam
  13. mesavage

    adding a bowse button to a form

    I know this thread is old, but I am having the same problem as Walt (i.e. the licensing problem). I have no idea what the problem is, and can not seem to find an answer on the microsoft knowledge base. Does anyone know what the deal is? I have Access 2000. Is there something special needed...
  14. mesavage

    Access have form limitations?

    ...setting produced teh following error: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control. *The expression may not result in the name of a marcro, the name of a user-defined function, or [Event Procedure]. *There may have been an error...
  15. mesavage

    Error 2115 -- what the heck?

    Oh, I forgot to mention I did the debug.print right before the assignment. I don't have a beforeupdate event, which is the crazy part! This is suppose to be in the "afterupdate" event!
  16. mesavage

    Error 2115 -- what the heck?

    No, I have debug prints before to print out the value, and make sure that h1name is set properly...and it is. Any other ideas? Miriam
  17. mesavage

    Error 2115 -- what the heck?

    Hi all! I am trying to use an option box to fill some boxes below. My problem is that whenever I click on any of the radio buttons, I get the following error: Run-time error '2115': The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft...
  18. mesavage

    Working with multiple tables simultaneously...

    OK, I'm having a bit of trouble. I'm using MS Access as a front end for my SQL Server. I'm using stored procedures for all my queries. I have a stored procedure that takes in a list of IDs and some other information, puts the records into a temporary table, and then returns a recordset with...
  19. mesavage

    Working with multiple tables simultaneously...

    Thanks! I'm going to give it a try. If I have problems, I'll be sure to let you know. To answer your question, yes they do have a relationship. As my team leader always says, "Sometimes you just need a second set of eyes!" This solutions seems to obvious now. :o) Miriam
  20. mesavage

    Working with multiple tables simultaneously...

    I have a subform. In this subform, I would like for some information to show from one table. I also want some fields from another table to be updateable. I had the idea to put all the information into a single recordset, but I couldn't figure out how to combine it all. It seems to me the...

Part and Inventory Search

Back
Top