Search results

If X <= y Or x >= z Then That's the method I can only seem to get to workIf Me.txtStartDate <= Date - 7 Or Me.txtStartDate >= Date + 7 Then MsgBox "This date may be incorrect please check your records & try again" Me.txtStartDate = "" Me.txtStartedHidden = "" End If

Hi DCrake, Where do you put your code so I can try it out?

Mmm, I found that solution from another post somewhere & perhaps was based on a query. Oh, well. My other method seems to work & happy to use it if noone else says otherwise Thanks Brian :)

Yes, I tried to add "then" to the end of the line but it errors out :confused: Must be something wrong with "Between" as that is highlighted in red If Me.txtStartDate Between DateAdd("ww", -2, Date()) And DateAdd("ww", 2, Date())

Hi, The following code now works after formating the date field to short date Private Sub txtStartDate_AfterUpdate() If Me.txtStartDate <= Date - 14 Or Me.txtStartDate >= Date + 14 Then MsgBox "This date may be incorrect please check your records & try again" Me.txtStartDate = ""...

Minature sausages filled

Hi all, I'm trying to prevent records being entered outside a time period & I'm struggling to work out the best method of doing so I've been trying If Me.txtStartDate <= #3/13/2010# Or Me.txtStartDate >= #3/12/2011# Then MsgBox "This date may be incorrect please check your records & try...

Thanks guys I was able to get some help & it's now sorted we simply replaced the strBody code my code now reads Option Compare Database 'Used for Text Messaging interface Global Const strClickatellURL = "http://api.clickatell.com/http/sendmsg?" Global Const strAPI_ID = "api_id=*****"...

paste this code into a module to get the windows login name Option Compare Database Option Explicit Private Declare Function apiGetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long...

Hi, thanks for your reply I have tried your suggestion but it still does not work, the message still goes through but the sender mobile no is not included Global Const strClickatell_From = "&from=[Forms]![frmSMSMessage]![frmUserMobileNoSubform].Form![txtUserMobileNo]" The footer works with or...

Hi all, Can anyone help me please? I'm trying to reference a mobile no from a subform but can't get it to work Basically a mobile phone no is displayed when a user sends an SMS message which should allow the recipient to reply to it. I have a table with all the windows login user names along...

Department for Work & Pensions Dennis Penberthy, an elderly Cornish farmer, received a letter from the Department for Work & Pensions, stating that they suspected he was not paying his employees enough and they would send an inspector to interview them. On the appointed day, the inspector...

For a parachute to work you have to take the plunge :D

That could happen anywhere not just Ebay. Take the plunge & sell one item & see how you get on, I'm sure you will enjoy it - nothing better than seeing all the watchers on your items & seeing your bids getting higher & higher. once you are happy then you can sell more expensive items Only pay...

The most I spent on Ebay was £2200 for my parachute - the best investment I ever made on ebay. I put it on sale the other day for £2500 & within hours had a lot of interest,. I then cancelled the auction before any bids tool place because I felt I was losing a good item & did not want to give...

It's up to the seller to be as honest & describe the item condition as accurately as possible, I don't know much about Rolex watches but I would have thought it would be easy enough to prove that it was not fake with certificates or proof of purchase etc Was the Rolex actually found to be fake?

Never heard of that before :confused: As a seller you can avoid Paypal all together & ask for cash or cheque instead but you will not be protected if anything goes wrong. Doing that may also put buyers off as they may think that you're up to no good but I do find that for larger expensive...

I have been using Ebay & paypal for over 8 years now & have logged over 300 positive feeback entries I can only guess that most problems people have are from inexperience & not planning their auctions properly whether it buying or selling I do agree that Paypal may be a problem but that is...

Happy Birthday Hayley :)

HAppy Birthday :-)