Recent content by zgray

Hello, We have an SQL backend with our access front end. We use a custom unique ID for the primary keys in our tables that is an INT data type. In the coming months another system that our data base talks to is changing that unique ID to be over 10 digits. To accommodate that change in our...

I feel like this is the simpelest thing and that i just cant seem to get it. I have a query that has 2 dates and 2 checkboxes, among other fields. But what im wanting is that date1 or date2 is >=#8/1/2016# and that both check boxes have to be checked. The tables are joined by a common ID...

This worked. But why is it doing that when its typed in exactly 0.0399 and the other values work perfectly?

I have a number field that will not filter correctly either on a query, through vba or quick filter. Every filter for any number will work except filtering the number 0.0399. There are records there with that number. IT shows up as an option on the quick filter and when i select it i get...

I'm using a dropdown that has the months of the year in it. The user selects a month and the form is then filtered by a date if its the first of whatever month is selected. It works fine but when the filter is applied I cant select the little arrow on the column headings and select the boxes...

This looked like it worked. Thanks for all your guys help.

I have this query. It counts how many records a person has based on a date. SELECT queryName.UserName, Count(*) AS [Count] FROM queryName WHERE (((queryName.Date)=Date())) GROUP BY queryName.UserName; It spits out the persons name and how many records for them for the current day. Simple...

I have a few tables that have a int data type field as its primary key. That field used to hold a 7 digit record number and it worked fine. Now they are using a 10 digit number and the INT data type is too small I need to change that field to a BIGINT. When I just change it and go to save it...

I have a table that has a regular yes/no field. Some of them are yes some of them are no. When I click the little funnel at the top to filter I can select yes, no, or all. I click yes and it shows me all the yes records. I click no and it shows me nothing. I click the filter again and see that...

I ran setspn -a mssqlsvc/<server name>:1433 <domain name\administrator> I had the database open while I did that and it was fine, no change. I got out and got back in and got the error and everyone else did as well. I then did setspn -d mssqlsvc/<server name>:1433 <domain...

I did the setspn and now the error pops up everytime. No one can log in.

I ran this query SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid ; and it returned NTLM. So I guess im not using Kerberos. Sometimes the connection fails when the database is started, other times after an hour of it being open. Just seems completely random...

Using access 2013/2010 as a frontend and sql 2012 on a virtual machine as a back end. Every once in a while users are getting this error Connection failed: SQLState: 'S1000' SQL Server Error:0 [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context It's somewhat rare that...

If I put them all on the or line in the query it only showed the ones where all 6 are "Not Done." I went into the SQL of it and changed all the and's to or's and it worked. I just thought putting it on the or line in the query design did that for me. Then after I changed the SQL to that...

I have a query with 6 fields in it that are being calculated right there in the query. The results of the calculations are either "Done" or "Not Done." I want to make it so that if all 6 say "Done" it falls off the query. If just one of the 6 say "Not Done" it has to stay on. I cant seem to...