Search results

When you make rules that deviate from reality, you are almost certainly misunderstanding the requirement and will end up making major modifications later. Is the only information you have for a doctor his name? If not, then you really need to create the data entry forms differently. You have...

Your skillset is more aligned with small companies rather than large and probably wouldn't qualify you for an H1b visa into the US. Have you considered looking for work as a consultant where you can work for yourself? Sometimes you can get a start by finding a placement firm that places people...

If you have to call the query from multiple forms, you can use TempVars. If you want to open a recordset with it, this is the code I use: Dim db As DAO.Database Dim qd As DAO.Querydef Dim rs As DAO.Recordset Set db = CurrentDB() Set qd = db.Querydefs!myqueryname qd.Parameter!CustID =...

So, follow my directions on how to use the BeforeInsert event of the second form. You also have three more problems. One the others mentioned and two they didn't. 1. The relationship between specialties and doctors is m-m, NOT 1-m. I'm going to attach a database with a sample m-m...

Interesting. I think they were an abomination. When they were first announced, I was excited to build one. I discovered within the first few days that I couldn't even link to a Jet table and so I stopped development and went back to the linked tables method. There was no way that every...

The goal of the Democrats was to keep the black population trapped in poverty in the inner cities. An unanticipated side effect of Johnson's programs was to separate the father from the family which was disastrous. We know this but for whatever reason, we haven't fixed it. Sadly, the inner...

Possession needs to be handled differently from intent to sell. The drug dealers handle this by using mules to hand off the drug so that the mule has only a small amount on his person at any point in time. So, unless you catch him in the act of exchanging money for drugs, he gets charged with...

Since these are "sibling" forms rather than "parent/child", I don't think the master/child links will work but you could try them. You have to qualify the master names with form!subform. But if that doesn't work, then 1. in the Current event of the Specialty subform requery the doctors...

q.StartedFrom >Forms!yourform!StartedFrom AND q.EndedOn < Forms!yourformEndedOn If the form fields are unbound, make sure you set the format property for each to short date so Access knows they are date datatypes.

It is hard to see the whole problem. I think you are missing at least one table. You could post the relevant part of your database diagram. Make sure you expand the tables enough so that we can see the PKs and all the relevant FKs as well as the join lines. I understand the concept of what...

I want to know WHY any person who commits a crime while carrying a gun whether it is used or not spends less than 10 years in prison? I was being facetious Doc. We don't actually need new laws, we need to enforce existing laws. If you come down HARD on the criminal use of a gun, criminals...

I have a question for our non-American members. In your country, is fluency in your native language a condition of citizenship? Do you actually have an official national language? I know some countries, like India, have way too many languages so that is even more of a problem for native born...

THAT's the problem. We need a NEW LAW that says that criminals MUST obey the gun control laws. THAT will fix everything.

Voting is a special case. If you are not fluent in the language, how can you possibly have enough information to cast a meaningful vote? Printing ballots in foreign languages is just a part of the suicide pact the Democrats created. Why we would ever want people who don't understand what...

I guess I need to put on my glasses;)

Sadly, that seems to be the case around the country. Apparently asking immigrants to do us the curtesy of learning English is no longer relevant. Fits right in with immediately registering illegal aliens to vote. Having the ballots in multiple languages just makes that easier also. Just so...

When you try something new and it doesn't work, just telling us "it" doesn't work is pretty useless since we don't know what "it" is. Please get used to always posting the code/query you tried to run and the result you expected if it isn't obvious and the result you got.

I use the subform's BeforeInsert event. You don't care about anything UNLESS the user tries to enter data in the subform before entering/choosing a mainform record. All you need in that event is three lines of code An Error message. Me.Undo Cancel = True KSS. You don't need to worry about...

Neatness counts so I understand the request to propercase the words but keep in mind that Jet/ACE are not case sensitive by default. so A = a.

The point of using Me in addition to getting intellisense is to tell the interpreter that the variable is defined in the current object and there is no need to search for it. Unlike COBOL where I could actually see the assembler language code generated as part of the process of compiling my...