Search results for query: *

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

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?

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

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

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

hi can anyone help with this problem? what im trying to do is just do some basic calculations which did work beofre attempting an upsize and now has decided to stop funtioning and reporting the error above. what is this acctually refering too then?

Does anybody know how to validate combo boxes because i cant seem to get this code to work Dim response As String Dim response2 As String Dim Response3 As String Dim response4 As String Dim response5 As String If (IsNull(DateId)) Or DateId = "" Then response = MsgBox("Date field is empty...

I was wondering if anybody can help me. i have got a table called "Product" in which it as a feild called "DateId" this feild is a combo box that is linked to another table called "Date" in this combo i would like to be able to either select the date previously entered or ad a new date. can...