Search results

Hi, I'm not sure that this is what you are talking about, but when I did something similar, my Access Pivot Table rows ended up as columns in the Excel version. Off the top of my head I can't recall where it is, but there is a toggle to show results (details area) as columns or rows which...

Dave, I'm glad you got your problem sorted although I confess the answer doesn't mean much to me. Out of interest, does the "URLEncode = %26" configure the ampersand to be treated as text or change it to a '+'? Regards.

"40,000 ton brick house" :confused: :eek: Could you possibly mean a house made of 40,000 bricks? A 40,000 ton house would be pretty big, even for America. Not may mailboxes could cope with the wear and tear! :)

hi Ya, Use an Find Unmatched Items query. Select queries in the database objects panel, New/Find Unmatched Items. The wizard is fairly straightforward. You need to create 2 queries, 1 for unmatched items in table A from table B and another the other way round. I think the subtract one...

I'm very green in this (and other) areas but I can offer this which may be relevant. Sorry in advance if it isn't. :) In Pivot Tables, which I believe are functionally the same as cross tabs, only with more flexibility, you can right click row and column headings and select to show empty...

Mr. Smith, I'm not entirely clear what you want to do here. I think what you want is a report that shows only the current record and you then want to make a .pdf file from it? The sample database on this thread should sort you out for the single record report...

Try this thread. If the sample DB doesn't do what you need, post back. :) http://www.access-programmers.co.uk/forums/showthread.php?t=85822

Sorry, forgot to say welcome! :)

Microsoft Press Access 2003 Inside Track and Inside Out are both advanced books. To be honest, some of the content was over my head as a novice when I read them and now I have had some exposure to Access it would pay me dividends to go through them again. Neither of these books are out an out...

Hi, The db fell over at the Dim MyDB as database line copied below. I'm using A2k on my home PC. I saw your response to MSLady, but don't know where/how to reference a DAO library. If that is my problem, could you give me a little guidance? Private Sub Form_Open(Cancel As Integer)...

Elephants Elephants are the only beast on the planet to have 4 knees. All other 4 legged beasts have knees in the back pair and the leg equivalent of elbows in the front pair (I wouldn't swear to the second statement, but 4 knees and elephants is definite!) Elephants are believed to be able...

Bob, It's easy to get a blind spot when working on your own. I sometimes feel like the pantomime dame with everyone shouting "He's behind you!" when I'm missing something obvious. I'm glad your curiosity has been satisfied. :)

Thanks Oldsoftboss, I noticed that in post 12 of this thread and got further clarification from the other site referenced in post 13. Now that I understand a bit more of this, I think the whole point of modals & pop-ups is that they force themselves to the front, so to speak, and there is...

Hi David, Best of luck with the Muppet theme. :) Everything you are talking about is way beyond my experience so the following opinion is even more ill informed than usual :eek: :confused: :D Having said that, it seems that the data comes from an HTML page somewhere and is sucked into your...

Bob, I think the other thing that pisses people off is that I go on too long. Certainly annoys my wife. The top right corner of every post, on my PC at least, shows an old fashioned balance scale, as held by statues over court houses the world over - the scales of justice. Click on them and...

Karma, I don't quite know how this all works, but a poster can delete a post. If the poster deletes a thread starter, it may delete all replies:confused:

Greenbar http://www.access-programmers.co.uk/forums/showthread.php?t=103876&highlight=greenbar I came across this thread some time ago. It has a sample db with alternating green bars.

I found this link on a google search http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acmthRepaint_HV05186327.asp In short, echo turns repaint on or off so repaint isn't a separate thing that might apply to my modal form problem. Anybody know of any other way of...

Bob, Firstly, I wouldn't want to call you dumb. People in glass houses etc! :D The scales at the top left are a link to the reputation menu. There you can give a negative or positive tick for the post and add comments if you like. Somehow these are totaled into a score that is used to...

Is there any equivalent for Modal forms? Hi, I messed about with this until I realized that 'echo' does not work with modal forms. The form I want to use this feature on is modal and pop up. I tried to find something like repaint = off or me.repaint false but it looks like repaint does not...