Recent content by nicklewis

cheers for your help guys i realised what id done about 2 mins after i sent it to the forum i was used to looking at dates in expression builder not coding its been a while Cheers for all your help

Right im proberly asking a silly question but ive been playing around with this one for a while and just not seeing what im doing wrong what i need to do is basically vaildate a date after update by using two text fields as the between dates so if the date netered is between these two datas it...

should it look something like that as it dosn't work for me docmd.SendObject(acSendNoObject,"Test E-mail",,"nick.lewis@manor-bakeries.co.uk","nick.lewis@manor-bakeries.co.uk", "nick.lewis@manor-bakeries.co.uk","Testing","Some one has just updated the tables make sure you update sql")

hi does anyone know of any code in which after a procedure is complete you can send a confirmation to a e-mail address? Any help would be greatly recieved Thanks in advance

Hi i was wondering if anybody knew of any code in access 97 that could send a e-mail verification when a procedure is finished?

Thanks that was the easy way to solve me problem i was playing around for ages as well cheers for your time mate much apreciated

Hi i have a DB that keeps coming up with this error when trying to open has anyone got any ideas why this is coming up? Any help would be greatly recieved Thanks in advance

didnt realise it was that easy cheers for the help that worked perfectly. hopefully this will be my last problem he says cheers again

error message: you must use the dbseechanges option with openrecordset when accessing a sql server table that has an identity colum The code: Dim db As Database Dim tblDowntime As Recordset Set db = DBEngine.Workspaces(0).Databases(0) Set tblDowntime = db.OpenRecordset("dwor_Downtime"...

yes it has two fileds very simple table DateId autonumber primary key Date

no i cannot add to the table strange how do i get around this sorry the start of the cod is Dim db As Database Dim tblDate As Recordset Set db = DBEngine.Workspaces(0).Databases(0) Set tblDate = db.OpenRecordset("Date", dbOpenDynaset)

tbl date is the recordset in which opens the table Date what this process is doing is finding todays date minusing one day from it then adding it automatically if not already entered to the date table

oh yeah sorry it says "can't update, database or object is read only" the only thing that we have been doing latley is upsizing the db to sql but havent had a chance to touch the table called date yet anyway

this was working but now has decided to not work today. any ideas? this is the code and it has stopped where the * is If txtday = "Monday " Then txtanswer = txtminus3day Else txtanswer = txtminusoneday End If tblDate.MoveFirst Do While Not tblDate.EOF If tblDate![Date] = txtanswer...

UPDATE ShiftType INNER JOIN ((ProductInformation INNER JOIN ((Plant INNER JOIN (([Date] INNER JOIN Downtime ON Date.DateId = Downtime.DateId) INNER JOIN [Order] ON Date.DateId = Order.DateId) ON (Plant.PlantId = Downtime.PlantId) AND (Plant.PlantId = Order.PlantId)) INNER JOIN Product ON...