Search results

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...

That seems like a dangerous thing to do, as the user could scan twice by mistake. Especially for tracking medication, the user should be forced to enter the quantity. I wouldn't even use a default, what if you need to audit your inventory for controlled substances.

Import Drawback Receiver is a local Access table. Combined_Part is a query. Part Lines is a linked Access table. Based upon the references that were mentioned, it seems that a cancatenate operation in query will always cause truncation.

I am using an SQL Server back end. It seems that the simplest solution is to split "Body" into 2 fields. This allows me to use my generic send e-mail function, as opposed to creating some customized code. I have tested splitting and everything worked. Fortunately, I don't have a business need...

There is an intermediary, but the truncation is visible in the query itself. SELECT DISTINCT dbo_Receiver.ID AS Receiver_ID, dbo_RECEIVER_LINE.LINE_NO AS Line_No, dbo_Purchase_Order.ID AS PO_ID, dbo_Purchase_Order.VENDOR_ID AS Vendor_ID, dbo_Vendor.USER_5 AS [Vendor Name], dbo_Vendor.COUNTRY...

Many of the fields are from an external database that I can't change the field type for. I tried using cancatenating a long text field at the start of the field, but it did not help. Neither did changing the field type with CVAR, either for the first element of the field or the entire field. I...

I have query that is being used to generate the body of an e-mail. Sometimes, the result should be more than 256 characters. However, when the query is run, the value is truncated. Is there a way of having a query generate a result that is more than 256 characters?

You will need 2 queries. The first query selects the max Seatime_ID for each Crew_ID. The second query links the first query to the original data to pull up the dates. Queries referencing other queries is a useful technique.

It looks that you are trying to track inventory in some fashion. Lots are being received, moved and I assume shipped. You need to have a table of inventory transactions. Once you are tracking that information, you can determine everything else with a query.

You are doing this backwards. You should have a table of all inventory transactions. When an inventory transaction is created, you should then update the other fields. If there is a problem, you always go back to the table of inventory transactions and determine the correct values.

Just as you thought, there was a field that still had null values, even though the default was set. Fixing that resolved the issue.