Search results

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

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

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.

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.

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

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?

I recently changed an Access native table to a linked SQL Server table. When I ran a loop to edit individual records in the database (in a situation where I could not run a query), I started to get "Record is deleted" errors. After much searching I discovered, that sometimes the ODBC driver...

I have found it useful to have a table in my database, that contains a record for every integer from 1 to 100,000 with a field for the alphanumeric equivalent. With a table like that you can use an unmatched query to find missing values. A table like that can created in Excel in a few minutes...

The GROSS_WEIGHT changes rarely, but when it changes is likely be when the NET_WEIGHT changes.

One of the schemas is for our ERP and I can't modify that schema.

What is a CLR?

It is the same Server, so I will try this.

They can according to https://www.mssqltips.com/sqlservertip/5909/sql-server-trigger-example/.

I will check out using an insert trigger. I link to the data using Access, but most users need to go into it using our ERP, so it is better to deal with it at a database level.

I need to create a constraint within SQL Server that enforces the rule NET_WEIGHT <= GROSS_WEIGHT. My problem is that the GROSS_WEIGHT field is in a different SQL server database. How would I create such a constraint? Is there a way I could create a view or some similar object within my database...

Getting rid of the OrderBy Month fixed it. Thank you for the help.

Same result with a CSV, only the header row appears.

I have used code and exported it manually. The result is the same.

A customer wants me to e-mail a spreadsheet showing sales and columns for each month (even future months). Here is a simplified version of the query. TRANSFORM Sum(dbo_History.Net_Sales) AS SumOfNet_Sales SELECT dbo_History.CUSTOMER_NAME AS [Customer Name] FROM dbo_History WHERE...

Why is "shift minutes" a currency field? It should be a "number/long integer" field in Access and "int" field in SQL Server. Do you really need to track fractions of a minute for a shift? If you do need to track fractions of a minute, you still should not use a currency field.