Search results

Hi Kristen, I was the person that helped you before. Your database design needs some retooling. I think I see what it is that you're trying to do, but it would take some time to fix it (consolidate some tables, redesign relationships, etc). When is your deadline?

One way to do this would be to base your AddAssignment form on a query, and in the query one of the fields would be EmployeeID (or whatever your employee PK is). In the criteria of that field, you point to the value of the listbox. See this link for more details...

Instead of using a message box, have you tried having a field on your form serve as the parameter? DoCmd.OpenReport "IndividualDonation", acViewNormal, , [IndividualDonation].[ID]= me.txtParameter Where txtParameter is an unbound textbox on your form where you're supplying the parameter.

Just to clarify, according to Islam, there were humanoids before Adam? So, If I am understanding you correctly, Islam is essentially version 3 (to simplify). Judaism - Christianity - Islam? As in, Judaism was perfect up until it wasn't, then god sent a new prophet(s), which eventually bore...

I think you're not understanding Galaxiom though. He's saying he does not care about Islam, does not have respect for it, etc. He's not saying every word in the Qur'an is wrong, he's saying it is beneath his notice, essentially. Using your logic, we could say that no one can completely...

You're not understanding aziz. Australia did not base its laws on sharia. If an Australian law coincides with something in sharia law, it is pure coincidence. Which means there is no value to you pointing out, though you seem to think so. As a point of curiosity, you said: What about...

Dick, have you ever tried using Firefox? If the whole purpose of you copying and pasting from Word is for the spellchecker, Firefox has a built-in spellchecker. Or try to find and enable a spellchecker add on for IE (with a quick search I found: http://iespell.com/)

When you say you want to make button 3 to 7, you mean buttons 3,4,5,6 and 7, right? Here's one possible way: Select case CodeID Case 1 me.btn1.visible = false me.btn2.visible = false me.btn3.visible = false me.btn4.visible = true me.btn5.visible = true...

Generally I agree. However, there are some people that are not totally committed to their religion. They may have doubts based on scientific discoveries, or the lack of observable miracles, using common sense, etc. I'd like to think debates like these would engage them to further research and...

It would seem that the logical answer is to use a query to pull data by semester. If the number of records being displayed at one time is what is causing the slower load time, then having a form based on a query that only pulls a limited number of records should speed this up.

Could you list the 72 sects of Christianity then? You continually miss the point. Of course, there is going to be differences in interpretations. That's human nature. Much like it is human nature to try to control other humans (which is the purpose of religion). If you believe you must...

Sounds to me like you have it most of the way figured out. I threw something together real quick and it seems to do what you want: SELECT tblStaff.StaffName, tblAbscence.AbscenceType, Sum(tblAbscence.AbscenceLength) AS SumOfAbscenceLength, Count(tblAbscence.AbscenceStartDate) AS...

This is a good first step for any believer to take. In my experience, however, most believers, even when they tolerate non-believers or believers of another faith, they don't accept them. For example, I have a co-worker who is basically a typical mom, 2 kids, husband, working for a better...

Books are written in the language that is current at the time. Language changes very rapidly. I believe it was earlier in this thread that you were explaining how the Arabic language has changed through the years. As such, trying today to look at the original writings from 1,000 years ago is...

In order to get a good answer, I think you're going to have to do a better job of explaining. What do you mean by "so if a customer exists in Brands 4, 8 and 13". Essentially, provide more details or attach a stripped down version of a database that demonstrates at least the basics of what...

I think you need to rethink your table design. It looks the purpose of the Pairing field is a unique identifier that is tied to the individual. However, this table design is far from optimal if that is the case. Example: tblPeople, which contains all the details of the people, using PeopleID...

Without actually seeing it, I can only make a general suggestion. If you have a report based on a query, and the query references the form that is open and contains the command button that launches the report, then you should be all set. HTH

That's how I usually handle this type of setup It doesn't have to be that way, but typically the report preview takes up most of the screen, so they would have to minimize to get back to your form anyhow. Docmd.Close when run from a report closes the report. I'm not sure that there is a...

You're welcome. Take a look at the VBA code and see if you can decipher it. Try to deconstruct what each part is doing, and that will help you to better understand the overall picture. One of the issues that you were running into was that you were utilizing both macros and VBA. I would...

Hi Dick, I wonder if this could be it: http://answers.microsoft.com/en-us/windowslive/forum/livemail-email/flagged-emails-disappeared/5d216394-5451-46df-adf6-400a2b1e4f0d HTH