Search results

I am just clicking a link. I don't see how I would retrieve the information about the link I just clicked. However, if I click the "Accounts" tab directly, it goes back to where I was in the "Accounts" sheet. Is there a way to simulate clicking a sheet's tab in Excel. This sheet will be used by...

Can I create a link to a sheet that does not specify a cell, so that the cursor remains on the sheet where it was previously, as if I had clicked on the tab for the sheet? I am working on a spreadsheet with a long list of financial accounts on the "Accounts" sheet and links to locations on...

The murder of Uriah the Hittite. The murder of Absalom. The usurpation of King Saul. Even King David's propagandists couldn't find an excuse for Uriah the Hittite. David was a mercenary leader who was hired various Philistine cities, and then grabbed control of Israel. He faced constant...

What about the Virginia colony which started earlier. Or the Dutch in the New Netherlands. Or Connecticut and Rhode Island, both founded by refugees from Puritan rule.

The account of King David in the Bible contains many crimes (and that is the pro-David account). Are you suggesting that David's crimes reflect divine inspiration?

The Puritans and Pilgrims did not found our country. They founded the Massachusetts and Plymouth colonies. By the time of independence, people had become much more secular.

Isaac, the founding documents of the United States are conspicuous in their lack of Christianity. The interesting phrase in the Declaration of Independence is "the Laws of Nature and of a Nature's God", which is a Deist phrase, not Christian. Lacking direct word from God, there are only human...

I am not sure what "God being in the highest order of power" means. Lacking direct communications from God, you are relying on human interpreters of God for instructions with all the usual problems of humans. Debt levels are becoming a problem but it is hard to see secularism as a cause. The US...

You are going a little to far to say that Christianity was incorporated into the government. Neither the Constitution or the Declaration of Independence makes any references to Christianity. (Compare the UK which still has a nominal state religion). While some of the founders where supportive of...

I have never murdered or stolen or born false witness or committed adultery. Have you? It seems more like the bare minimum for rather than a high standard.

The Establishment clause of the First Amendment, did not require the separation of church and state. Establishment is the support of a specific religion with public funds. At the time of adoption, a number of states, most notably Massachusetts, has established religions. The separation of church...

It was not so easy to find the link, but I got it now.

Do you have the actual code you demonstrated available?

I have PDF's in an Access table using the Attachment field, that I need to automatically export and attach to an e-mail. I would I do this in VBA?

Works perfectly, thanks for the help.

I have been using VBA to copy a series of queries into a number of locations on an Excel Spreadsheet. Function CopyQueryToExcel(QueryName As String, FileName As String, Worksheet As String, StartingCell As String) Dim DB As Database Dim RS As Recordset Dim Row As Integer Dim Column As String...

I needed to remove the line with .InitialFileName, then it worked perfectly. Thank you for the help.

I need to have a user select a file for further operations using a normal dialog. I tried this code, but nothing happens, not even an error. Dim FileName As String Dim FD As FileDialog Set FD = Application.FileDialog(msoFileDialogFilePicker) FileName = FD.InitialFileName I have the Microsoft...

Thanks for the help. I used plog's second suggestion, of creating an autonumber field in a temporary table to import the data and then using a repeated query to fill in the data.

In order to compute commissions I need to read data from a spreadsheet provided by the customer. Unfortunately, the customer does not understand the first normal form and is not showing repeated data. Sid Harvey Sid Harvey Branch Sid Item 0004 BROOKLYN,NY (0004) NY SPE-EZ5E-CS...