Search results

Jessa, I had the same thing happen to me when I updated my Adobe Pro X. I restored it back to the original version and it returned. Other than that I have noticed some weird behavior and simply rebooted and everything returned to normal. (we do not shut down computers, just log off) Good...

It seems as though it is all working correctly. I can't thank you enough, I would like to understand it all. Some things just loose me all together!:p

Ahh, IT WORKS! Thank you so much for the help, I think the Option Explicit may have been the initial problem as you pointed out. 'Check TM Rate for a value If ((Me.Project_Type) = "1") And IsNull(Me.TMRate) Then MsgBox "Please fill in the Time and Materials Rate before proceeding"...

TM Rate is a currency field would that have an effect?

It is a text field and I even refer to the same control further down in the code 'Set introduction line budgetary vs contract If ([Project_Type]) = "4" Then Introduction = "would like to submit the following budgetary costs." Else Introduction = "proposes...

Perhaps I should tell you that Project_Type is a combo box based on the table tblProjectType and I am wrong the source of the form is a query combining several tables. So, you think I should go back and refer to the fields using Forms!Formname.Control?

Yes Changed Code to: If ((Me.Project_Type) = "1") And Len(Me.TMRate) = 0 Then MsgBox "Please fill in the Time and Materials Rate before proceeding", vbOKOnly Me.TMRate.SetFocus GoTo Exit_Procedure End If Still Executing as though the cell has a value?

Okay got the Option Explicit at the top of the module it was Option Compare Database

Option explicit should be the first line in the code previous to anything else, correct? Private Sub MergeBttn_Click() Option Explicit That is giving me a compile error: invalid inside procedure?

"I found one problem, by the way: are you using Option Explicit? If not, you should." No, I don't think so. Most of this code is borrowed from here or there. I have seen the statement before but have no idea really.

Frothingslosh, Where would I run the code at in the Immediate Window?

Thanks for the response! I made the changes as specified and commented out the first If, then block. It still skips right over the code and continues to execute. I posted more of the code thinking it may have some indication of what the problem is. No errors are thrown. Private Sub...

I am running Access 2010, and don't do this enough to really know what I'm doing. I have googled this and searched these threads for most of the day in an attempt to solve this issue. Frankly, I could be going about it completely wrong. In laymen's terms I am attempted to run this code on a...

nanscombe, You are right the name of the form was spelled incorrectly :eek: rookie mistake. Thank you for all your help. Samantha

Thank you for all of the responses, frmLookupServicesAddress has a search feature built into it so it can be searched when the user returns to the form. I haven't even thought about how to delete from that same form. I always reverted to an additional continuous form to delete. This started...

I know this must be something so simple That I am missing. I have the following code attached to a button on a modal form. My thought is that when a user clicks okay a message box will open for the user to select yes or no if they select no I want the message box to close allowing the person to...

The field structure is different for the queries, any other ideas?

Hi all, I am learning and have been for a few years so I am familiar with a little bit of everything. I am using Access 2010. I am not quite sure how to complete what I want - I am half way there. With the holidays approaching I am trying to generate a Holiday Mailing Report to make my life...

Thanks, for your response. I am just getting back to attempting to solve this problem. I have been trying to figure out exactly how to use this and the examples I have seen do not exactly fit my problem, or I just cant make sense of it. Would you have an example of using this procedure? My...

Does anybody knows how to control the below message to something like this through VBA: "The Job: " & JobNumber & " already exists in the table." or to open an alternate form where they can make the change. Allowing duplicates is not appropriate for what I am trying to accomplish. I just want a...