Search results

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

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

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

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

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

Im starting a new database for a new project and im copying some forms from another database iv been working on and the colors are different. They both say they are the same color just my new database colors all seem lighter. Is there a setting somewhere that changed? Really confused.

We converted our Access back end to a SQL server and lost some functionality. Before switch to SQL we could right click on a column heading in a subform or datasheet and have a list with checkboxes of things to filter by. This is gone after the switch and would like to know how to get it back...

We converted our split database back end to sql and went in and changed our date datatypes from datetime2 to date. In the front end all our dates are displaying yyyy-mm-dd. I went into the forms and set the format property of the control to short date and it does nothing, I formatted the date on...

I have a split database and I have one user getting this error. If he tried to put any data into any field on the form this error will pop up. Theres also no vba being ran on this form which is what my googling skills tell me is causing this error. We tried to duplicate this error on my computer...

I have dlookup that is working correct but for some reason when I put in the criteria of a specific number it doesn't seem to find it in the table. I know its in the table and I even hardcoded the number into it. If I use any other number it works except this one. Heres my code...

For some reason when I change the order around of the columns in a split form or subform 90% of the time it wont save (right click save, file save, etc..) and have to constantly redo it until it finally works. Am I missing something obvious as to why this is happening?

Im having trouble trying to figure out the best way to set up a table that looks at 3 things instead of 2. For example I have a table that has all my branches and the columns are all the programs. Then I use a dlookup using the branch and program to find the number I need. Now I have a third one...

I have a split database with the backend on our server. When I go to my server and look at all the open files on the network everyone who is in the backend shows up twice. One has zero locks and the other has multiple locks. Just wondering why it's doing this and/or if it's a problem.

Not sure where to ask this question so ill put it here in general. Im trying to get windows server 2012 task scheduler to open my access database. When the task runs all that I see happen is the locking file will appear on my desktop and I have to go to the task manager and kill it to make it...

I have a split database with the backend on our server here at work that has several users in it all day. Since I'm still developing it while others are using it I have to announce to everyone to get out of the database to go in and add a field to a table or make any changes to the table. Was...

Today and yesterday I added new fields to a table and they are showing wrong when everything is right. I added yes/no fields and a combo box look up and when I drag them over to my forms they are just showing as textboxes and not a checkbox or combo box. When I look at the backend and look at...