Search results

Hello everyone, I apologize for not responding I was not getting notifications for the thread. The issue was resolved by one of our support teams. Their resolution notes stated they deleted the Citrix profile folder from the the users XenApp folder (XenApp is the application used to maintain...

I have an Access form used to review transactions, and when the user is done they click a "submit" button that saves the review information and sends an email to the submitter to let them know if it was approved or denied. The email is sent using the oApp/oEmail functionality in VBA. One user...

I made a separate Citrix link that goes to a separate copy of the FE database for her to use so it is just her in the database and she is still having the issue. I changed the row source for the dropdown from values list to query results, but that did not solve the issue either.

The FE database is accessed via a Citrix app that links to the file location so all users are using the same FE copy, and the other users are not encountering this error. I tried giving her two new copies of the database but she encountered the same issue in both.

There is no vb for the combo, changing the value from the combo box does not trigger any queries or functions. Clicking the "submit" button is the only action on the whole form that triggers an action. Once the "submit" button is clicked I check to make sure it is not null then capture the...

I have a bound form that is used to approve or deny billing adjustments. I have a simple unbound combo box on the form that has two values ("Approved";"Denied") that was left unbound so that the data does not append to SQL until the user clicks the submit button. This form/database has been...

FlatType is a field on the subform that I wanted to enable, I mistakenly thought control/field were interchangeable which added confusion. I realize I worded it as if FlatType was the name of the subform container when that was not my intention. Also I didn't even consider the...

Yes, I meant to say that the field from the subform that I wanted to reference was FlatType but I worded it as if FlatType was the name of the subform container. Now I understand the correct nomenclature. Thank you

Hi All- Thank you all for assisting, as some of you just pointed out my mistake was with the name of the subform container. I had been referencing it with the name of the subform (ARO_Adj_Details Subform) instead of the name of the container (ARO_Adj_Details Subform(view)). I aliased the...

I attempted this code but received an error stating the "method or data member not found", I assume this is due to the control not technically existing on the main form.

I attempted both versions but unfortunately still received the same error from the initial post. The link you included offered some alternatives but the syntax I found for referring to a control property on a subform if you are on main form was not successful. Code from link...

The current objects I have are: Main form - frmViewAllAdjustments Sub form - ARO_Adj_Details Subform Subform Control - FlatType Would the correct syntax just be "Forms.frmViewAllAdjustments.FlatType.Enable = True" or would I need additional pieces to specify that the control is on the sub...

I have a form (frmViewAllAdjustments) that shows all billing adjustments. Some are pending review and some that are already reviewed. The subform (ARO_Adj_Details Subform) shows the related records. My goal is to make the records on the subform editable if the record of the main form has not...

Unfortunately I am not able to share it as it contains company information. I was able to find a simple workaround however, I was able to unbind the form and still avoid locking/ duplication issues. Not sure what I did differently than last time I attempted to use the form without binding it...

The main issue is that a record is attempting to insert when a blank form is closed, so I don't know if a "BeforeUpdate" event would get the chance to trigger since it hasn't been edited or updated. Just opening and closing the form is causing the error, so it is sometimes occurring without any...

Would BeforeUpdate mean they would be presented with that option before any field on the form is updated, essentially when the form is opened? The option of cancelling a record seems to be exactly what I am looking for. Thank you

I have a bound access form in which users enter new records to a SQL table. The table in which it is adding records to has a few required fields. I am able to successfully enter records into the table, and use VBA to mandate that the required fields are filled out before submitting the new...

Hello Access World! My name is Joe and I am from Rochester NY. I have worked with access databases in the past building simple queries/forms/reports, but recently got my first job as a coder/ developer. I am now getting my first exposure to advances MS access functions and VBA coding. I look...