Search results

I need a Select Query to display data on a form. When an order is appended to my table the field named Printed is updated with the time it was appended. When my form opens it needs to display the field Printed and a field I call MinutesFromPrint. This field needs to display the total minutes...

You helped me figure it out. I used =Count(IIf([FieldName]>0,1)) and got the correct count. Thanks.

What I meant was I need to count the items in the column that are greater than zero.

I have a report based on a table. In the report I sum the columns. In a textbox ControlSource I use "=Sum([ColumnTotal])" and it works. Some of these numbers are zeros. I would like to exclude the zeros in the total. How do I do that? Thank you.

In answer to your questions, read this. How was this project organized? By people that had no part in the outcome. Who was project lead? A guy that had no part in the outcome or set up and testing. Who set up the contract? A Supervisor that had no idea what was going on, but had a deadline...

I understand all that. The problem seems to be that somehow SQL is holding my resources in some manner and I need it to let go.

I was included in a project where an outside vendor was brought in to set up a SQL Server backend for an Access database I developed. Since it has been running, all my Access databases are really slow, with some of them not even wanting to close. I have developed several other Access databases...

In the beginning it wasn't. Someone else was brought in to do the SQL part and this began showing up. Why they did it that way I don't know. I am now dealing with the leftovers in the project. I will see if I can find that. Thanks for your help.

This worked great. I was able to make a few adjustments and now it seems to be going well. Thank you.

I am involved in a project that is using a SQL back end. I am having issues with "unable to save" messages when I quit the application. I have noticed that if I close a form to look at something, on many occasions the select query behind the form or subform is open. Is there a way to close all...

This got rid of the Write Conflict error. Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 7787 Then Response = acDataErrAdded End If End Sub I am still getting the message that you can't save the record at this time when I close the database with DoCmd.Quit, or...

I posted this on 6/12/2014, and got no resolution. START OF POST I have read several posts concerning Write Conflict errors. I have tried several options and am still getting the error message. I am using SQL Server as the back-end. Are there any special considerations I should know of to...

I have read several posts concerning Write Conflict errors. I have tried several options and am still getting the error message. I am using SQL Server as the back-end. Are there any special considerations I should know of to prevent the Write Conflict errors because of the SQL Server? Thank you.

I don't know if this will help anyone but here is what I found out and was able to fix the problem. In the main form, the Record Locks setting was set to Edited Record. I changed that to No Locks and it worked. Thanks.

Let me add this. It is linked to a SQL Server.

No. It is patient data.

The form and subform have AllowedEdits set to Yes

They both do.

I have a combo box that won't allow me to select an item. The box is on a subform. When viewing only the subform, it works. When viewing the subform from the main form, it won't work. Any ideas?

These are the references I currently have checked. Visual Basic For Applications Microsoft Access 14.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library Any suggestions?