Search results for query: *

Hi I have some data which is set up as follows; I have a collection of Parent objects which each contains a collection of child objects. I'm trying to obtain a list of all child objects which appear in every parent. The only way that I can think of doing this is to loop through each parent...

Hi guys, I'm new to Java - converting from c#, so sorry for the simple question. I've created a webservice, which parses an XSD file which I have on my hard drive. Trouble is, I don't know the best place to put the XSD, and how then to get a handle on the file. I'm currently specifying a fully...

Hello Beginners question! I need some help regarding writing XML to a file using C# I am currently outputting my XML to a file directly using KeywordsDataXML = new XmlTextWriter(keywordCacheLocationFile, Encoding.UTF8); This working fine, however I now need to examine the results of each...

Hi Guys, I've been going mad trying to get this to work - there seems to be very little c# resource available on these Office libraries. Anyway I'm trying to update a Word document to insert autotext into the footer of a document - the "page x of y" autotext entry. I can get the autotext to be...

Hi guys, Really annoying problem here that I'm trying to fix for a friend. I am working on a laptop with windows 98 installed and with an EPSON C62 printer. After the printer was installed my friend was having problems communicating with the printer. The source of this problem has now been...

Bit of a strange one. I'm trying to set up a network connection for a friend. I've installed the network card but the network neighbourhood icon isn't on the desktop. Any ideas why it wouldn't be visible? The machine has windows 98 installed. thanks a lot, Mark

Hi, I am having trouble returning an ADO recordset to access from a server stored proc. I read somewhere earlier that when select statements are perform in a stored proc they can be "automatically" returned? This is my called procedure in access: Function get_recordset(sqlstring As...

Hi, Is there any way of, having looked up a String value from a table, evaluting it in visual basic. It seems the eval function isnt sufficient to eval commands such as "forms!form1!control1 = 2" Any help is greatly appreciated!! Mark

When I right click on SQL server agent and click start i get the message "An error 5- (access is denied) occured while performing this service operation on the SQLServerAgent service" I am logged in as an admin user who has all the possible server roles. Any ideas?

Hi, Bit of a strange one. One of my SQL tables has stopped being updatable when viewed though a linked table in access. When i change some data directly in the table I get a write conflict. When viewed in enterprise manager it is updatable. It is possible to add new records in access and these...

Hi, A similiar question has been posted to this but as its slighty different i thought i'd make a new post. I have an access database with around 50 tables in. Around 30 of them have primary keys. I need to transfer all the tables/data to SQL server. I am using the create DTS import wizard on...

Hi i'm currently trying to setup and upgrade an old PC for a friend. Everything is working now except for the RAM. The motherboard is an old P1 board and so has 4 SIMM slots and 2 DIMM slots. I've decided its not worth using the SIMM slots anymore so i went and bought a 256MB PC133 SDRAM DIMM...

Hi, Not sure how easy this is but i'd thought i'd ask anyway... I need to put ordered integers into a field(order) depending on the value of another field(date) So the order field ends up with the higher numbers in the records where the date field is further into the future. So for example...

Hi, is there anyway to retrieve (in code) the number of records that are currently in the recordset of a form, after any filtering or querying has taken place. (i.e the number that is displayed next to the navigation buttons) This has to be used from the same context as the currentrecord...

Hi, I need to trap a possible error when I am inserting into a linked server. I have a linked server which is just an access database which a stored procedure copies records into out from SQL server. This is done at night and the stored procedure is called from access code using ADO so it is...

Hi, I have been designing a database using access/SQL server and it is now ready for users to start using. However I need to make a copy of this database on the same SQL server so I can continue to develop and test my access front end without affecting the live data. I've trid copy database...

Hi, What would the syntax to update a boolean field in the record that contains the highest value in an integer field. I bascially need to set a flag in the record that has the highest ID. I've looked in various resources but they dont seem to quite answer the questions that i need. For...

Hi, I need to copy some selected data from one table to another using a stored proc. This isnt a problem - i figured i should be using insert into. However the problem is, the table that I am inserting into needs to obtain one of its column values from a local variable and not from the select...

Hi, I'm new to T-SQL and so this is a simple question, but one that I cannot find the answer to anywhere. I need to return an integer value from a select statement into a local variable. I don't understand what happens to the recordset after it has been returned by the select statement. How...

I have a very simple stored procedure: CREATE PROCEDURE [dbo].[copier] AS INSERT INTO [DISS EMAIL]...[EMAIL](mailto, mailfrom) SELECT TOP 1 mailto, mailfrom FROM [EMAIL] ORDER BY email.id DESC GO This is used to simply copy the most recently added record from the "email" table on...