Search results for query: *

Yesterday I finally managed to upgrade from XP to Vista Ultimate after a few problems I encountered along the way. Today I decided to uninstall some programs that I no longer needed. So I first started uninstalling Corel Paint Shop Pro X. Halfway through the uninstallation process I got the BSOD...

Marc, Thanks for your reply. As you said yourself, it does looks as though we're over complicating things by bringing in MS Access into the equation. However, Seagull don't sell any other products to manage the files - they've just got the actual Jwalk development package. And I might've been a...

Ok, I'm not looking for a complete solution here, just some ideas on the best way of going about this..... I'm looking to automatically transfer data from our AS400 into an MS Access database. The transfer of the data is to be triggered maybe via an exit program after an object has been checked...

When I run a stored procedure that executes a DTS Package I get the the following error: *** LoadFromSQLServer failed [SQLSTATE 01000] (Message 0) OLE Automation Error Information [SQLSTATE 01000] (Message 0) HRESULT: 0x80040e14 [SQLSTATE 01000] (Message 0) sp_OAGetErrorInfo failed. [SQLSTATE...

Well I tried creating a linked table in Access to the file on the AS400 and although I'm able to view the records in the file it took almost half an hour to display the file which contains 3000 records. Also, it was almost impossible to page up and down through the table because it took an age...

T Blom - no I didn't upgrade to V5R2. I've had Client Access V5R2 installed on my PC for sometime now and it was only the latest Service Pack that I installed a few days ago. I'll give you idea of creating linked tables ago and see what happens.

I have an MS Access database with a function to import a file from our AS400. This function has always worked until a few days ago. Now whenever I call this function it just hangs, and when looking at the QZDASOINIT job log there is a message which says MSYSCONF in QGPL type *FILE not found. My...

Thanks for your help...I found a way of doing it!! The first form now posts to a different page (post.asp) which adds a record to the database. In this same page I have the second form whose hidden values are taken from the first form. I've then got the following piece of Javascript code which...

Basically I have a form that posts to itself so that a record can be added to the database. There are 3 fields in this form (name, email & address) that then need to be submitted as hidden fields on the second form. But I don't users to have to manually submit the second form. So by a user...

DeCojute - not sure what I should be looking at from the link you gave me??

Does anyone know whether it's possible to automatically post a form without having a user click a submit button? I have one form that users will complete/submit and the results will be saved to a database. Some of the values from this first form will be used as the values for a second form...

Thanks everyone for your help, but to make life a little easier I'm going to add the value of the "validfor" field into the table as well. Then I can subtract "expdt" from Now() and if it's greater than "validfor" delete the record. Just seems an easier way than...

I just tried changing strDate to = day(date) & "/" & month(date) & "/" & year(date) and it's still not deleting any records!

When I get the date (strDate) it's being returned as 12/11/2003.

When I add a record to the table I'm using: objRecordset("expdt") = cdate(Now() + Request.Form("validfor") "validfor" is a number between 1 and 14 in a dropdown list. In other words the message will be valid for between 1 and 14 days from Now().

I tried your second example but that isn't deleting any records, and I can confirm that I'm using the UK date format. This is an example of the records in the table: ref expdt notice 39 14/11/2003 18:54:22 LS01969,LS02022,& LS02018 being shipped w/end 8/11. 47 14/11/2003 14:53:47 2 mile times...

GaryC123 - when trying your SQL statement I first got a Data type mismatch error, so I removed the single quotes and tried it again. This time I got the same result as before where it's only deleting all the records upto the 12/11/2003!!!

I'm using an Access 2000 database.

OK, I tried the following SQL statement: sql = &quot;DELETE * FROM tblNboard WHERE expdt < # &quot; & Now() & &quot; #&quot; and it deleted all the records in the table up the 12/11/2003......for some reason it doesn't delete the other hundred or so records in the table up to todays date...

mwolf00 - I tried your suggestion but got the following error: Undefined function 'getDate' in expression. Dynapen - I tried your suggestion but got the following error: Data type mismatch in criteria expression.