Search results

Thanks Bob, have just been googling, but I can't see how i can use it within the line: arrSummaryData(intRecordCount).curAdultTP = IIf(IsNull(![adulttp]), "", ![adulttp]) I have just noticed something whilst trying CCur - if the [adulttp] = £3.51 then it works fine - so the routine just cuts...

Thanks for replying. No, I have a button on a form, that runs a whole routine, which eventually brings up an email with all the data in it that i need to send to someone. It is in that email that the £3.5 shows. Ian

hmmm - this code goes and gets the data from an SQL server. It then puts all the information I need into an email, ready to send to someone. It is in this email that the [adulttp] doesn't show 2 digits. Even if there is a better way of doing it, given that i have done it this way, is there a...

Hi Folks I have the following code: f OpenConnection Then If rs.State = adStateOpen Then rs.Close rs.Open SQL, cn, adOpenKeyset, adLockOptimistic If Not rs.EOF Then dblRecord = rs.RecordCount ReDim arrSummaryData(1 To dblRecord)...

Well, good point jdraw. The simplest answer is that i think this might be beyond my skills to write such a routine. I would have to get access to rename the jpg image, before it puts the images name into the field, as they must both have to have the same name. At least with the current...

Correct so far! The program is the access database. Say I am on a record for the film "Crimson Peak", and i want to assign an image name for that film. I click on the button that produces a list of all images (GET JPGs button), i find the one for crimson peak, click on it and the name of the...

Hi I may not have been clear enough in a posts below - but i have, thanks to you guys, a solution that works well for me. A message pops up if someone tries to enter a filename with a space in it. Job done! And I can't thank you all enough... Ian

Well our database drives our website www.artsalive.co.uk and also our weekly email alert, and there is often strange behaviour with images if there is a space in the filename. Ian.

Yeah, training has happened, staff were informed but you know what it is like - there is even some text below the field in RED saying "no spaces in this field please". They do have the ability now to rename the image name when they click on the button to show the list of images. Thanks for...

Thanks fo your suggestion - as you might have gathered by now, the user chooses the filename, rather than typing it in, but i will bear this suggestion in mind for another field where they do type in info, so thanks!

Another staff member collects images that we can use for publicity purposes, and save them in a folder called images - this is all outside access environment. They often forget not to use spaces in the names. So, when a user in access wants to associate one of the images to a record, they can...

The user does click on a button which brings up all the jpg's and they choose one, and the name goes into the field. Problem has been that when the jpg is saved it is often saved with a space in the name. But now with this code in the afterupdate property: Dim Msg Msg = "THERE ARE SPACES IN...

Hi All I have a text box that holds the name of an image - and i want users to NOT use a space in the filename. Is it possible to validate for No Spaces? I searched on this forum but could not spot an answer.... Thanks ian

Thanks for your reply, appreciate it. I can see when i step through the code that before it goes into an excel file, it goes into a temp file and even here, with no formatting, this one line changes the format of the data. Best regards Ian

Wow, thanks Mark, there is lot going on in this post, and I am about to finish for the day. But will have a good look tomorrow and see if i can put some of these suggestions into practice. Really appreciate your time. Ian

Thanks very much for replying. Yes that date is being inserted correctly, but of course it only gets its value on that line - e.g. it is always equal to today. The other date field [datefield] has a value already, from the database - a date in the format dd/mm/yyyy. So I don't know why on...

Hi I have a routine that writes to an excel sheet from my database in the exact format i need to import into Quickbooks UK. It all works well except for this routine which inserts a line, but it puts the date in the american format rather than UK. I can't seem to find out how to make the...

Perfect Dave, thanks very much. And sorry for calling you after your dog. Best regards Ian

Thanks Jemma, that does indeed work. Not sure why this is only a problem on IMDB as all the other buttons work for searching amazon and google etc. I just need to research how to make spaces into +'s now. but thanks for your help, you have got me on my way! I.

Anyone any ideas? Have been looking around the internet but can't seem to find an answer that works. Thanks Ian