Search results

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.

When I say blank form I mean blank as in no controls or fields when the source control query has no results. See Snapshot 1 when sorce control query has data. From here the user can modify or delete the record. See See Snapshot 2 When I change the dates to a date range when there is no data the...

No that is not it., There are no records for 12/09/2020, so there is no date, and if there was it would not have a time stamp. The control source form works fine for ALL other date ranges except a range where there are no results in the control source query due to no records for that range.

Thanks, Isaac, The datasheet is updateable directly in the table and the control source query for the form, this issue is when the results of the control source query return 0 records (no records for the current day have been entered yet) I am unable to make any updates or changes via the form...

Thanks, Gina...I have done what you suggested.

I am starting a new post per the advice of another user as I posted on an 8-year-old post without a resolution to my issue. So here it is. I am in the process of transitioning my Access Backend database to an MS SQL database and I am having a couple of issues. My primary issue is stated below...