Search results

I may have gotten the wrong end of the stick here but don't you need a join to the except table? FROM schedheader LEFT OUTER JOIN scheddetail on schedheader.EXCEPTION_CODE = scheddetail.EXCEPTION_CODE LEFT OUTER JOIN [except] ON schedheader.EXCEPTION_CODE = [except].EXC_ID and...

Has anyone seen this? Should provoke an interesting dicussion. (or flame war!). But lets hope it doesn't sink to that level yet again. Link

Plenty of versions from http://www.gutenberg.org/wiki/Main_Page Just search for 'bible'. or here http://etext.lib.virginia.edu/ebooks/subjects/subjects-bible.html

Tried and Failed. The project/task went away so this wasn't pursued.

In an attempt to resolve this problem I thought I could the Microsoft Web Browser control. Using .navigate I can open up IE and browse the web in a form. How would I direct the contents of my field to this control? Any one?

You beat me to it Kraj. I would have beaten you its just that the web page took at least that long to refresh. Seems kinda slow today.

Have you tried this? In IE. Tools, Internet Options, Content tab, Autocomplete. There are 3 check boxes. Web, Forms and User names and passwords. Are any checked?

We have received an Access database containing records as part of a data migration. In one of the tables there is a memo field that contains HTML code for process descriptions etc. How can I display or print the contents of this field so it can be read?

Agreed. They ARE wild animals after all. I wouldn't go out of my way to pat them on the head. But nor would I trek miles into the wilderness and shoot one either. If I need meat I'll go to Safeway.

Couldn't do that, too much of a wimp.:o Would rather pet them.:)

Yes, I forgot to mention that.:D My wife, a 'damn yank', has two. A 44 and a 357. I haven't fired them in ages as we don't have any bullets.

I moved from the UK to Oregon about 4 years ago and have never looked back. Salary doubled, house size tripled, car size doubled and waist band, well, increased!!:o

Funny. But fake! http://www.snopes.com/humor/lists/fakenews.htm But they were funny all the same.:)

My company, in their ultimate wisdom, have decided upon a new stationary standard. This involves putting the logo and address info at the bottom of their stationary, but only for the first page. The following pages do not have this information. How can I make Access (A2000) not print the footer...

Thanks for the solutions guys. They all work. This has been one of those things I've often wondered why it happens. I think its a bug too, unless anyone else has an explanation why it happens. Is this documented anywhere? I couldn't find anything about it in the MS knowledgebase.

Can someone test this for me? I have created a tiny sub that increments a value on the form. Each time the button is clicked the underlying sub runs twice causing the counter to add 2 instead of 1. Note: I have not used the standard On_Click sub I've made my own. Thanks

After a bit of fiddling around I think I've got it working for you. I used the 'on change' event if the lookup combo field. I'll have to see if that change will make mine work. :D

Perhaps you could make an .mde version. click on Tools, Database Utilities, Make MDE file

in the After Update field, change it to Event Procedure click on the 3 dots and then type in me.requery. However, I've tried this on your sample but the records still do not appear. I don't know why as I'm having the same problem with a DB of mine. I look forward to see some replies for a...

Right this is the actual SQL I have at the moment. SELECT qryWonStatus.BidStatus AS BidWon, qryWonStatus.WonCount AS WonCount, qryWonStatus.ValueByType1 AS ValueByType1, qryWonStatus.AvgMargin1 AS AvgMargin1, 'Lost ' as BidLost, 0...