Recent content by RogerCooper

  1. R

    Query result is being truncated

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

    Query result is being truncated

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

    Query result is being truncated

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

    Query result is being truncated

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

    Query result is being truncated

    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?
  6. R

    Solved Top values for unique records

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

    Please help: mark True/False if value of the same record has been mentioned in other table

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

    table showing all stock qty changes from old to new value

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

    "This record has been changed by another user since you starting editing it"

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

    "This record has been changed by another user since you starting editing it"

    Access is recognizing the primary key. It works as long as I select specific columns but fails if I use the "*".
  11. R

    "This record has been changed by another user since you starting editing it"

    Last night, I needed to rebuild my database by creating a new database and copying all objects into the new database. I am now receiving the "This record has been changed by another user since you starting editing it" error when I edit a specific table that is linked to SQL Server. 1. If I go...
  12. R

    Solved Restricting Entry to Numbers Only in Text Field

    A period would be a bad character but in practice that it not likely to be an issue. The problem is inconsistencies in the source document being transcribed, which sometimes has dashes and spaces.
  13. R

    Solved Restricting Entry to Numbers Only in Text Field

    The length of the values can vary. Even if the values had a fixed length, I would be uncomfortable using a numeric field with something that is not really a number. It could cause future problems if somebody thought is was really number and didn't pad with leading zeros.
  14. R

    Solved Restricting Entry to Numbers Only in Text Field

    This worked in validation IsNumeric([Entry#])=True
  15. R

    Solved Restricting Entry to Numbers Only in Text Field

    I have a field that should only have numbers as characters, but it can have a leading zero, so I can't use a numeric field. Is there any way that I can prevent accidental entry of non-numbers in the field at the database level?
Top Bottom