Recent content by delboy2

Client access Hi I have been informed that the following will work If you get Client Access part of which is the OBDC Driver (32 Bit) Many thanks

Hi All Not sure if this is possible or not I currently have a table of e-mail addresses, names and dates I am looking to send each individual a confirmation on the date they are due. All this works fine when sending the e-mail as a normal mail I am looking to get these fields imported into...

Hi All I need some help with configuring an odbc connection. The issue is that when I go to another site I cant access the AS400 tables I think this is due to the drivers being different on each site. I have tried using "NS/ODBC" on system DSN this worked once and then crashed. On the site...

Hi Please help ! I have a form on which I require several sub forms I have created controls on The sub forms to change the sourceobject of unbound sub forms. However I am having problems seting the link criteria to come from the previous sub form It does work when using normal forms and using...

Hi I have a small issue with a database I have developed The issue is that our servers in work are not known for there reliability I have several backend databases linked in to frount end user databases all linked tables are currently linked to W: and all user databases are on the pc its self...

I would go for the simple way out and make all other fields invisible until the field you want has been updated On open set every other field to invisible and after update to visible You would also need to use this each time you went to a new record Hope this makes sense

Hi here is some code that will prevent you from being able to use the shift key If you are going to use this please make sure that you have a hidden button somewhere to unlock it again. Sub SetBypassProperty() 'locks the database and does not allow shift key Const DB_Boolean As Long = 1...

Hi Fisher Here is some code i have used before it might give you some ideas Private Sub Next_Click() Private Sub cmdnew_Click() On Error GoTo Err_cmdNew_Click If IsNull(txtAC) Then MsgBox "Please enter the customer's account number", vbInformation, "Datanet" txtAC.SetFocus Exit...

Hi Is there any way that access can link to outlook and return the users e-mail address. Guess I am just being lazy but it would save compiling a list of e-mail addresses The reason I ask this is we are looking to automate mails to specific users who are still logged on to a database which...

Thanks Thats a great help

Text messaging All you really need to do for this is set access to send an e-mail to an sms service. I have used esendex in the past the email is simply sent to "mobile number"@esendex.net With the e-mail body which is changed to text You do have to set up an account with a monthly charge...

Hi I have a piece of code which i use to drive an e-mail from a form Dim strEmail As String Dim strmessage As String DoCmd.SetWarnings False strEmail = "MyE-mail" strmessage = Title & " " & SirName & " Account No " & txtAC & " has called to cancel there Service Because They are...