Search results for query: *

To the best of my knowledge I have included all the dll in the folder in the system path, however when it comes to the installation package I will have to speak to the developer, however, how would that explain all of the export working locally but not on the TS2003, and the fact that it did...

Thanks for your reply, this is the first reply I have had in days on a number of forums. I am using Crystal 8.5. Would you know if creating Crystal Decisions and MergeModules folders manually and placing all of those files in would have any affect? Cheers

I have read a lot about this error and all the suggestions put in place in order to have it working to no avail.We have a Visual Basic 6 application and we are able to export reports to Word,PDF or EXCEl through Report viewer, however for sometime we have had problems exporting to PDF on...

I need to add a field to an table in sql db that has to have a default value. HOw can I assing the default value to a field in a table please? Thanks

Hello all, I have a db to convert from Access 97 to 2003 format, however the db is a replica and gives me an error that "Local forms,reports,macros and modules in this replica will not be converted" I have done some research but I am still not sure on some things since I have never done this...

Hello guys, I have to convert a db from 97 to 2003 format, the current database has an MDE file created as well and I need to do that.None of that is a problem I know how things should go, but I am getting an error "You can't convert or enable and MDE file" and finding out what that meant...

Thanks for you reply but I don't really understand your reponse, it seems to me you think that i have a column that this new date value needs to be inserted in, but that is not the case, this "new or changed date value" needs to be part of the comment which is what this code does here. Please...

I hope somebody can help me, I have inserted the code for the trigger that if/when dates are changed it sends an email like below, but instead of noting that the field has changed and emailing that I need to email and capture the actual date it was set to and I am not sure how to do this. Could...

I have an insert query that we use for populating data when submitted through our website, however even though the field allows 4000 characters it only ever submits up to 2700 so I need to allow it to submit up to 4000. I was trying to alter my sql query with CAST and CONVERT but i keep getting...

I need help with changing data source/which database my Access application connects to. We got this application from overseas,it is a Access front with an SQL db, I have restored the database, so we have the database, however as soon as I click to do anything in the program I get an error...

I was thinking something like select * from test where Created < '20053105' and NOT InvoiceReceived >'20053105' do you see my logic, but this is not correct, I don't think this option exists

I don't know if I have gone damb, but I have tried that and similar queries but that gives me results where Invoices were received up until that date, when what I need is a list of results where no inovoices, no activaity was done after this date.

HOw do I write correctly a query where I want to say give me everything where Created is before 1/6/2004 and InvoiceReceived are not after 1/6/2004. So some of these results can be created before 1/6/2004 but we are still using them and invoicing is coming through, but I want to find what was...

Ok, I am trying to create 3 radio buttons and to have "Leave" radio button checked by default if the value of D_Approved = NULL. This code displayes correctly if this is approved or rejected but what behaves funny is that "Leave" radio button is ticked ALL the time and it alllows me to tick one...

We have a Visual Basic 6 project and asp pages loaded "through it" clicking on a node/link loads a page,recently certain users are getting error "Permission denied" but only when they try to access this web page by clicking on the link the first time, every other time it is fine, and the web...

Ok,all of those functions where causing me lots of headache so this is what I have done in case somebody has the same problem.Insead of forcing the sql server to understand the format I need I am scanning it in ddmmyyyy format and just before the insert I am converting it into yyyy-mm-dd format...

And if there is no such function then how would you do, how would you format the date, can you help me with that.

What do you mean, visual basic Format function, these are ASP VBScrip pages.

Call myCon.Execute("INSERT INTO BloodInventory (ProductID, locations, RBC,PhenotypeReserve, CMV, IRR, AverageDailyIssues, " & _ "DaysRemaining, SDLPF, TWLPF, FilteredApheresis, UserName,Scan, address, FilteredPaediatric, TimeEntered) VALUES (" & _...

Hi guys, I hope somebody can help me or point me in the right direction at least.If I have a product that when scanned into the web site will scan as a single piece of string but it is really made out of start code - A0, componeneet code - 00150, stop code 3B, how could I drop prefix and sufix...