Search results for query: *

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

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

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

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

Hi guys, I have just been reading some posts about this subject and in one of them I have found that you can use javascript to submit using Enter key but only if you have one field, is that correct? Also would somebody have an example of submitting a number of fields using the Enter key...

select a.RelocateID,a.DateEntered,a.CompanyID,b.FileClosedDate from test1 a inner join test b on (a.RelocateID = b.RelocateID) where CompanyID ='5710' and DateEntered >= '01/01/2004' and convert(varchar,FileClosedDate,101) < '31/12/2004' Hi I was wondering if somebody could help me alter this...

HI guys, by reading posts in this forum I have changed my web page so when users submit the data the page doesn't get redirected but it submits to itself, so visibly it clear the values and submits and they are happy as that speeds up the process but what I haven't relized up until now is that...

We work in ASP VBScript pages. When a check box is ticked at that moment I need to be able to have certain values selected in two drop down lists, so all of this exists at the moment and works but it has to be done manually, since it is all connected it would be good if it had the values...

We work in ASP VBScript pages. When a check box is ticked at that moment I need to be able to have certain values selected in two drop down lists, so all of this exists at the moment and works but it has to be done manually, since it is all connected it would be good if it had the values...

I will try and explain this the best possible way, I have a appl. that prints labels, before printing a label I enter two pieces of data but one is only important as that gets printed on the label as well. So I click on "Print label" and then this code takes me to RecordLabelPrinter function...

I have an application where we print labels and capture certain info about gadgets we place the labels on. I have just added an ability to upload serial numbers for device we use, table contains ID(autonumber),Colour,SerialNumber,ExpiryDates. So we use these devices until they don't expiry and...

Could somebody please explain to me how do we join a table onto itself as that is what I was advised to do but I can't quite get where I want to go. What I want to do is list values from a table,but those values can be just a quote (what would cost if they decided to go for that option) or...