Search results

Hello, I created a help file using the Microsoft HTML Help Workshop. I went into the API settings and created an alias of "1 = t1.htm". On the Access form properties, I set the HelpFile to link to the .chm, and set the ContextID to "1". However when I press F1, The help window that comes up...

I am actually a competant chess competitor, and a competant Poker player, and you've quirked me by saying the word luck. I assure you, luck is not needed to be successful at poker. All that has to happen is the law of averages work out over infinite, assuming you know and understand the skills...

He is stopping himself. Only explanation. Tim Brewer, what *IS* your plan? You must have a plan... once again, you're not doing ANYTHING, how can it be *YOUR* free idea if you arent doing anything. If anything, this is now the Access World Forum's Free Idea, if we chose to ever do anything...

Truth: Tim Brewer is a nut. At first, I was ridiculed for thinking this by members who believed in your ideas. Then I was violently opposed by people saying that your free option might be actually real. And now it is clearly taken as self-evident.

He is saying this thread goes like this: "My idea is free!" *Someone gets interested and asks some serious questions* "My idea is free though, and I've tested it so I don't need to supply any facts" *Someone gets slightly annoyed that you just bypass the questions* "It's free, open your eyes...

After doing some testing with it, I got the two queries built, but instead of a UNION for the results, I need an INTERSECT for the results, which Access doesn't support. I was able to add the two side queries inside the master query attached to the main table, this way only the results where...

Sounds good to me, I"ll give these methods a try. Thanks,

Thanks for the reply, I may not have explained the issue very well in the initial post. So I will try a bit more detail here. tblCompany has the fields CompanyID, CompanyName, BillingAddress let's say. tblPaymentType has fields PaymentID, CompanyID (Foreign Key), PaymentOption tblProduct...

Hello, Let's say I have a master form, which has two One-to-Many continuous subforms. If I wanted to be able to filter the results based on subform values (for example, show all master records which has a subform record equal to 'Product Name', this way I can filter out all 'Companies' that...

I would personally use the afterupdate event on the checkbox to determine if everything else should be locked or not. If me.checkbox = 0 then Unlock everything Else Lock everything except checkbox End if However if that code you have works perfectly except the Me.requery problem, this is...

This is one from a previous IT person. There was this database that was built horrible (double and triple links between tables, no referential integrity, nothing really 'worked' but had the illusion it did). Trying to explain to people that it doesn't work, and never worked, and that I would...

I disagree all those pictures were of actual "terrorist" acts, and accomplished by "terrorists" from the middle east. You would most likely be sending an afterlife report to those who would commit such acts! But biting again, what if the nice little afterlife orbs love playing tricks on the...

No problem, glad I was able to help! Good luck with your demo.

I tend to reply quick when at work ;) As long as I'm still subscribed to the thread! If you want to disable all warnings altogether, forever, then when the main database form loads, you need an "On Load" or "On Open" Procedure that simply runs: DoCmd.SetWarnings False The problem with this...

Hello, You need to go into the code where your delete code takes place. Put DoCmd.Setwarnings False right before the code, and DoCmd.Setwarnings True right after the code. For example, if you have a button for deleting a record, go into that button's OnClick event properties. Your first...

No option is free. To help you would take time from us, and time is money. There may be no monetary costs in the immediate overlay, but there are definitely costs!

I agree with Gemma that you need a separate table called "tblContactInfo" or something which has "Contact Criteria" such as Phone Number, E-mail, etc. and then "Type of Contact" which is a dropdown for "Phone", "Fax", "E-mail" etc.

Thanks very much for your help and insight.

So even though I am calliing the DLookup many times, it should still be faster than keeping the recordset open and doing all of the tests? Currently for this form there are four specific tests, but in the future this could grow.

Hello, Just a quick question because I am unsure of the technical specifications of each. Which is faster to lookup quick information, a DLookup or a Recordset. I have security built into the form to check the username, and show options appropriately. I originally made the code using...