Search results

if you post the code here I'll have a look....

Hi, A bit of a guess but i might help you... I think that access uses the date format as per your computer's settings for the dates you see (e.g. if you are in the UK then a date on a form will be automatically dd/mm/yyyy) but no matter where you are access VBA uses the US format...

Hello, I've been having a few problems with sending emails from access. I've a form which has all the info on it about a particular guest. I have a button that I press to email this guest using info from the form. I think it works fine when outlook is already open. If though outlook is...

hello, thanks for the post. I have a table of each available bedspace, which has a column for chalet, for room number and for bed number. This means each bedspace has a unique ID, which is linked to from a field in the guestbooking table. I thought that would be a good way as you then are...

hello, I've a it of a head scratcher here. I've been going at it for a good while without avail! I have a bookings database for ski chalets. There is a table tblBedSpace, and there are 4 fields being ID, chalet, roomnumber and bednumber. The idea is each guest gets placed in, for example...

hi everyone, just to say thanks very much for all the ideas. It's very kind of everyone to give up their time and share their experience. Great to hear some debate on naming too! And the normalisation, thanks for the pointers there, I'm going to spend a good while on that first. Thanks...

Hello, I'm currently in the process of gutting and redoing a bookings database (access 07). I built it last year, and it was the first database I've built. As such, it's not great! I'm re-doing it to make it more efficient and faster for me to use (I'm the only user so it doesn't have to be...

Thanks, that worked a treat. Here's my working code, just for anyone looknig through who had the same problem. I created 2 public functions: Public Function Column15(strText As String) Column15 = strText & Space(15 - Len(strText)) End Function Public Function ColumnRight15(strText As...

thanks, of course no offence taken at all! I'm very grateful for the ideas. Right, I'll get stuck into that too! thanks, phil.

hi george, thanks for the reply. I store the emails I sent out to guests in a memo field. This function is to template an email to my guests letting them know what ski lessons they have booked. It needs to go into the memo field as this jsut templates the email then I tweak it manually, add on...

Hello, I am using access 07 and have some VBA code which puts some text into a memo field for me. It gets the text from various columns of a table. Currently it produces text that looks like the below: phil - hire - advanced jonathan - lessons - beginner claire - lift pass - local area etc...