Search results for query: *

Hey all, I dont "do" access stuff very often and i am struggling. I have a form\subform all working fine. However on the subform design i have added this Private Sub Form_AfterUpdate() Me.Form.OrderBy = "OrderKey" Me.Form.OrderByOn = True End Sub This works fine when i view the form on its...

Firstly that doesnt look like an error - that sounds like a command. Does this use SQL server as a database? I recommend finding a nortel forum to try and find more details on the issue. ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because...

Just to clarify - my view is that no other system can be 100% accurate. At the end of the day its common sense - can you program that? ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter...

But how do you know that its not ASHLEY COMPANY CONSERVATION DISTRICT? My personal view on this.... If you need 100% accuracy then there is only one way to do it. Do a straight match (maybe change Ltd to LIMITED?). Then see whats left. Lets assume there would be less than half, maybe a...

You could use dynamic sql if all the structures are the same. like it suggests here: http://stackoverflow.com/questions/3206304/loop-through-databases-on-server-and-update-data But be careful and make sure you have a good backup. You may also want it to exclude any other system databases...

As far as i am aware you cannot hide parameters. The only thing i can sugguest is setting them to "unused" or similar dependant on the other filters. Then obviously you will have to cope with this "unused" wherever this parameter is used. ----------------------------------------...

As far as i am aware you cannot hide parameters. The only thing i can sugguest is setting them to "unused" or similar dependant on the other filters. Then obviously you will have to cope with this "unused" wherever this parameter is used. ----------------------------------------...

Hi, In this instance i would compare the files and find the difference first and foremost. To do that i would use an app like WinMerge (i believe it is free) to compare the two files and find the difference. That may then get you closer to the why? Dan...

Hi, I am not sure if you even need a table function for this. Can you explain what the report does? So it takes in a year - but then it has to work out the quarters for what reason? I am not trying to be awkward but it sounds like you are thinking about this in the wrong way. For a starting...

The convert function will fail unless you remove the letters first. I would suggest a post on the oracle forum will get someone who can help you with the PL\SQL for that. Dan ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who...

This link may help you http://www.dbforums.com/microsoft-sql-server/1214500-linked-server-sql-dbase-db4.html ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch...

Sorry to be the bearer of bad news. I am quite sure there is no such date stored. The only other way would be attempting to get the date out of the transaction logs back to whenever it was inserted - if you have them, but i cant imagine that would be easy even if you did. Dan...

I am not sure this would be possible (i may be wrong). Without recursion\CTE\Cursor SQL works in batches of data, not at individual row level. A row does not know what the previous row was. Would love to be proved wrong however :-) ---------------------------------------- www.fountain.me.uk...

Hi, Its because of the order by. Do you need to order the insert? If so i can probably code round it. Dan ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch...

How about this (untested so please try on a dev box) INSERT INTO Product_SpecificationAttribute_Mapping (ProductId, SpecificationAttributeOptionId, AllowFiltering, ShowOnProductPage, DisplayOrder) SELECT PD.Id AS ProductId, sao.Id AS SpecificationAttributeOptionId, '1' AS...

Where does this missing data come from? ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch Computer Science is no more about computers than astronomy is about...

Yes you should be able to search using a text search tool the RDL`s to be able to find direct references. To find references within stored procedures on the SQL box i would use the free tool from Apex SQL called ApexSQL Search. With this tool you can find a sting (in this case the table name)...

Wouldnt it be easier to change the collation of the database? ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch Computer Science is no more about computers than...

The only thing i can tell you is that i have experianced if you are watching files upload with BIDS that sometimes bids gets behind itself and it takes a while to catch up to what it has actually done! D ---------------------------------------- www.fountain.me.uk Be who you are and say what...

What do you mean by the "highest client name"? ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch Computer Science is no more about computers than astronomy is...