Recent content by michaelH

Hi all, I just wanted to post an update here on my status. Even though I was unable to get the form to function as expected I was able to create a separate form for my new data entry and it works fine. Unfortunately, I was unable to utilize the already built form but in the end, it works how...

Thanks, isladogs, I have already seen and been through this list and none of which I have identified as the cause.

In short, yes this is my underlying issue at this point. I uploaded a short video showing my primary issue and the source.

Hello all, I am back, and still no resolution/solution for my issue. CJ_London, I have done what you asked, when I add the code msgbox me.recordset.recordcount to the current event it displays the recorded count correctly when accessing the linked access table, however, when I switch the...

Thank you for your response CJ... Your understanding of the issue is correct. Good call on the vba functions that are not recognized by SQL server, I did not catch that. Unfortunately, that did not resolve the issue. I replaced the calculated fields with "" in order not to break anything due...

Yes, I can add/deleted/modify in the table and the source query directly when opened. Yes the form values are set to yes.

I managed to make the video shorter and I was able to upload it.

Trying to upload a short video showing and describing the issue at hand.

Thanks for the response, I have check these several times and it is not the case.

As I mentioned the control source is a query that references the one table. Here is the SQL from the query. SELECT tblAccomplishment.Date, tblAccomplishment.[Date (Numeric)], tblAccomplishment.[SF/MC], tblAccomplishment.District, tblAccomplishment.Coordinator, tblAccomplishment.[Man Days]...

No apology necessary, it happens. I am using one form that reads/displays the data from the source control query and the user should be able to select the new record button and get the 4th snapshot to enter a new record just as they would if the linked table was Access.

Do you mean when I am connected to a SQL backend table only? This works fine when linked to an Access backend table so I am not sure I understand why this is. My apologies also when I ask for clarification on what you mean by a subform? I am only using one form for the process, there are no...

As I mentioned, I can add/delete/modify through the source query just fine. I have checked the form properties and it allows edits and allows new records just not when I connect to the linked SQL table.

As I mentioned, I can update, modify, delete, and add through the source control query and the table directly, I also posted all the permissions for the table showing I have full permissions.

Thanks pbaldy, I just tried that, and unfortunately, it is too large. I will work on getting it smaller to upload. Thanks for the tip on the upload.