Search results

Thank you Brian. I will try to remember that in future. My stupidity shows in that I was trying to do something which, from experience, I should have known was not possible. As I said I am not a professional user just an oldie trying to help a small local business that's finding things a bit...

Hello All, Running WinXP and Access 2003. I have to admit to not being a pro user of Access and that at the moment I’m feeling particularly stupid (and fed up !) All afternoon I have been trying to create a simple query using the query grid (I don’t do code) to do a straight forward...

Hello Everyone, I need some basic guidance and help. In my mind the task is elemetary but I just cannot get it to work in my report. I'm on Access 2003 in Win XP. I am trying to produce entrance tickets for our local festival. The performers may be in more than one event. The events cover a...

Hi Wazz, I didn't explain very clearly what the problem was. We can get the data up on the site but I think he's complaining about the length of time it takes handling all the separate pages. I can understand how a single file would simplify the operation but I just cannot find a way to supply...

Thanks Wazz, but won't that take away control of the file when used on the web? I suspect the web designer will need some manipulative freedom with the file which means HTML coding. Bomac

When I export it into Rich Text Format, and then open into Word, occasionally the text is cut off, even though in the Access version all the text is there. The particular field of concern is Memo data type. Hello ClaudiainDC, I've never dared offer help to anyone before but I stumbled on...

Hello, Using Office 2003 on XPPro. I do a bit of computing for a local charity and I am being asked by our website designer if I can provide my report as one document rather than 250 separate HTML pages. Is it possible to do this ? I have tried various options involving Microsoft and Adobe...

Hello Boblarson, That was wierd! I cut and pasted the code you supplied, knowing I would probably mess it up if I tried to copy it, and somewhere in the process the code acquired square brackets round a couple of the words. I removed these after revisiting and checking your previous replies and...

Spot-on Boblarson! I had put it in the wrong place ! However now that it's in the correct place the error message has changed:- Run-time error '2465' Acces can't find the field 'l' referred to in your expression. (where the 'l' is the vertical line and not the lower case letter L) I am sorry...

Hello Boblarson, Sorry to have to come back - especially since it's most likely my lack of understanding that's to blame but - I get the following error message when I try to open the form:- Access can't find the macro 'Me'. "The macro (or its macro group) doesn't exist, or the macro is new...

Thanks Boblarson, I think I can even understand enough to see the difference between the first and second statement ! By the way you are so right in your assumption...I'll settle for 2010 when I can retire (for a second time!) from active service. Thank you for your help, Bomac

Hello Boblarson, This particular date gets set now in readiness for an event which always takes place the following March so the date will always be current+1. Bomac

Partial Date Input Thanks Boblarson, I will take that away and have a try. When you say it will change the year to whatever the current year is - can I make it change the year to next year ? Bomac

Partial Date Input Hello Harleyskater, I have been trying to get something using masks etc to work but so far I've had no joy. It always seems to interfere with the rest of the field. It was just a thought but if it can't be done we'll just keep on typing. Thanks anyway. Bomac

Hello All, I have a minor question about inputting a date on a form. The dates we are inputting are for events which will take place during March next year. Is it possible to have the system supply a specific year when the dd/mm is input. i.e. when the user comes to input the date they type...

Select Top Three Only Hello Jon K, At the end of a rotten day I was so pleased to see that you had followed up with detailed advice on what I should do! I haven’t had time to try it yet but I am sure it will work fine. I also intend to see if I can find out a bit more about the ‘In’ operator...

Select the best three Hello Jon K, Thanks for picking up my query and for the example you made available. I had a quick squint at your reply first thing this morning before going to work and I’m sure it mentioned something about table structure. My original submission gave all the details...

Hello All, I have a small problem which I feel I should be able to solve but the hours of trying are proving me wrong! From a choice of 16 events, competitors can enter as many as they like providing they are eligible. For each event they receive performance marks which are duly stored in a...

Can only snake across then down Thank you Pat for your comments and advice. At least on the face of it, what I've set up should work and that's encouraging ! I hadn't realised I could apply so many parameters to a sub-report. I haven't given up on trying to get it to work and next chance I get...

Hello All, I built and manage simple access databases for a couple of local charitable organisations. Unfortunately things don’t always stay simple, which is the situation I find myself in now. I have a report which when run snaking ‘across then down’ works absolutely fine. When set up to...