Search results

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 :-)

Congrats to you both :-)

I've sorted out the problem I had all the data in the report header instead of Detail

I'm trying to run continous reports based on a query that returns more than one record at a time, if you know what I mean :confused: At the moment I run the report based on 1 record at a time & the record details fits all on one page I now need it to print one record at a time on each page as...

Thanks ;) I sheepishly looked for a way to delete my post without giving the game away but I was too deep in the mess & could not do anything else but this.....:o Cheers

What's wrong, the typo, my query or both? :D I see my typo so perhaps I should't try rushing too many things at the same time, will clear my head & try again :o I meant returning 10% from the following values 10% of 165 records is 16.5 - running query returns 17 records 10% of 29 records is...