Search results

Try executing the query from VBA. Start by analyzing the value of the combo box then build your where clause to include or exclude the username restriction. Build your union query using the same strings that you are using now then append the where clause as needed. 1. Build all the select...

I am working through a similar issue where I need to use a temporary table to properly join information. I am thinking of using a recordset in memory to accomplish this. Has any tested that method? What should I be planning for to avoid possible problems?

Try this: Lets call you combo box cboAppType Edit the Combo box rowsource to hold more than one field like Select appointmenttype,cph from tblAppointmenttype Bind the data to column 1 so when the user chooses the appointment type, they see what they expect. After the session length is entered...

strUsername = Nz(Dlookup ("USERNAME","AUTHORISATION","AUTHORISATION.USERNAME= " & Forms!PASSWORDS.[Text43]),"NoAuth") If strUserName = "NoAuth" then msgbox "You have no permission for this" else 'do stuff End if Th nz function looks for spaces, nulls and otherwise blank data and enables you...

Method 1: Try pressing the F11 key once the database is open. Method 2: find the database file in using a file explorer (My computer). single click the file Press and hold the shift key, then press the enter key. Keep holding the shift key until your databse window opens up. This should...

If you want to prevent the users from selecting a piece of equipment that is already reserved, why not limit the list they use to select it to begin with? Use a query that requires the Status field is "Available" to populate the list. this avoids error instead of handling it after the fact...

I fought with this for a while and eventually figured out the solution based on the thread referenced above, and "Hey, Scripting Guy" posts. Below is a template script that is working on my network; this solves the issues of non-admins editing the registry as the scope is for the current user...

One arguement I see in this type of debate is the conflict between evolutionists and creationists. Does anyone seriously consider it possible that both are true? Consider for a moment that God created all life on this earth in stages that are not explained in the Bible. This would makes...

It's your imagination on this one, you tell us.

I am curious about what you (the reader) would do if you had a chance to get your hands on a hacker or virus writer. Assume you get all the time in the world to do what you want, you would not be prosecuted or suffer any negative consequence otherwise and any tool or accomodation is available...

I would like to answer my own question now. If you still feel you have the right to someone else's property, provide justification for that position. The fact that someone has more than you does not count as a valid argument. We don't. A few basis points: 1. Our government is funded...

Thales750, again you project your own faults and prejudice on others and make assumptions instead of dealing with facts. I am not in multi-level marketing, I am building a clientele for which I provide computer based services like networking, programming, repair and virus removal. The more my...

I have been running SBS 2003 R2 for 5 years. I have run into bare metal recovery problems, even with Symantec's IDR (Intelligent Disaster Recovery). I can think of few options. 1. Add an array of disks and move the storage to that array. 2. Add another server to manage the file sharing /...

1. I was responding to his specific failure to make a point about my religion, not law. 2. I believe your first point on the flat tax is faulty. First the government is built to serve the people in specific ways. Social issues is not one of them in the case of the Federal government. If it...

Back to my original post: I support a flat tax. I support allowing people to enjoy the fruit of their labor as they see fit whether you make the widgets or if you're the guy who took to risk to open the widget making company. I support the right for someone to choose not to produce and...

Chippert: don't project your own doubts and failures on me. One who wishes to know the truth studiesthe truth alone. There is no need to study lies, when you know the truth you can identify lies when they come to you because they do not agree with the truth. Assuming the role of a pharisee...

ChipperT: I don't need your faulty interpretations to be true to my faith. As a self-proclaimed non-Christian, you are not qualified to council me on my faith. Thales750 said"Left unchecked the growth in the upper .1% will stifle all small business and make our Nation similar to Mexico to our...

SteveR: I agree with your last statement. Thales750: You are throwing out more red herring than fish market. I agree that stockpiling the majority of the cash does hurt the economy. I continue to hold my position that you have no right to demand that the owners of that wealth do something...

Thales750: "If as you say the money of the United States belongs to the People, than it follows that the People should not support a system that decimates the middle class. The ultra rich have been stock piling cash for some time now, and the middle class is in jeopardy" No, I did not say...

Funding the governent is about providing the necesary means to execute enumerated powers, not satiating special interests. Although I will agree with your point that special interests have a large rolein the problems with our tax code, your focus on satiating the special interest groups is...