Search results for query: *

I have a SQL Server 7.0 database I'm trying to get to talk to a SQL Server 2000 database. The communication actually needs to be 2-way in the end. I've been trying to use the sp_addlinkedserver stored procedure in conjuction with sp_addlinkedsrvlogin. So far, her is what I have: exec...

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

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

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

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

I'm sorry if this is a repeat question, however I searched through the forums and didn't really find the answer I'm looking for. I have an access project connected to an SQL Server 7.0 Database. I have approximately 25 forms built so far. Not all of them are fully functional yet. Yesterday I...

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

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

I have an SQL Server with an Access front end. I have a subform that is based on a stored procedure. The stored procedure has a couple parameters, that are filled in when the user fills in all the appropriate information at the top. At this point, the user is suppose to highlight the relavent...