Search results

I'd rather watch a two hour long science fiction film about a being who visits Earth and inspires awe in the people with their advanced technology. All sorts of tricks can be achieved by film makers and magicians.

But who created the raw materials to make the button?

I believe you just need to add the "Rowsource" method to your code. And for cmd_En : Private Function cmd_En_Click() Me.cbo_Organ.Rowsource = "select distinct bodySystem, organLatinName" & _ "from tbl_organs " & _ " order by bodySystem;" End Function And for cmd_Ar : Private Function...

... not to mention deleting records without a trace.

Is there a missing comma between "111" and "-2"? If the column is numeric you could also try SELECT fieldName FROM theTable WHERE abs(someField) < 1000;

Oh ho, Peterborough. There's a blast from the past. :eek: I did a four month stint of Access development at our Peterborough office (Orton Goldhay) back in 2000. I think they were trying to get me to move from Kent and out of the London office. :p Surprisingly enough, I didn't take them up on...

I guess it would be one way to judge whether you knew things by heart, from years of experience, or simply went off to Google, or the Help facility, and plagiarised example code. You'd probably only have to go to Subroutine or Function level for some of the controls and put a remark in...

There is also the ActiveControl property which returns the control which is active as a control object. Dim ctlCurrentControl As Control Set ctlCurrentControl = Screen.ActiveControl If ctlCurrentControl.Name = "txtCustomerID" Then . . ' Do something here. . ElseIf...

Most of the time when people make grammatical errors we do accept them by taking them at face value. However, those errors may change the intended meaning of what was written and people react to what the author actually wrote rather than what was in their head at the time.

In the UK the church has not been placed in the position of being forced to marry same sex couples. However, any Christian denomination that wants to (apart from the Church of England, ie the State religion) will be free to do so. The Catholic church would also be unlikely to do so. Until...

For thousands of years most, if not all, "men" (everyone after Adam & Eve) have been man-made, without the intervention of a god, as well.

strSQL = "DELETE rs(TableName).*, rs(TableName).SubjectID " & _ "FROM rs(TableName);" If you are deleting the whole record I don't know that you need the extra ".SubjectID" part. It could be simplified as ... strSQL = "DELETE * FROM [" & rs(TableName) & "];" I have included "[" and "]"...

It could be somewhat difficult to reconcile the existence of God with the disbelief in the concept of gods.

"gave his accounting of the actual creation in writing to Moses back about 3-4000 years ago" ... One might ask what was God doing for the rest of the 4,500,000,000 years (age of the earth) or 13,800,000,000 years (age of the universe)? ETA: Maybe some advanced alien race did make the Earth...

There may well be conclusive proof of the existence of an advanced being, who could exhibit godlike powers, but that wouldn't mean they were a god. Some events from the Bible could now be seen as routine medical achievements but were considered as miraculous to people two thousand years ago, it...

If appropriate, you might be able to use a tabbed control with one tab having all the sensitive fields on it which could be hidden, or revealed, by using password in one action.

I would probably put a breakpoint at the beginning, watches on the values of your loops and single step through the code. Look out for any unexpected values where your loop counters reset. I suspect that there might be a line of code which resets a pointer incorrectly, 0 instead of 1 or 1...

You're welcome. :)

As an aside the "&_" construct is used to continuation of a single command line over several lines, it does not insert line breaks.

To use multiple SQL commands on one line you need to terminate each command, except for the last one, with a semicolon. SQL command 1; SQL command 2; SQL command 3 Batches of SQL Statements To take one of your options as an example: sSQL = "RESTORE DATABASE [" & txtEngID.Value & "]" & _...