Search results

Hi vbaInet - I thought that too but I checked the table behind the query and that field is "TEXT". Also, I will change the name of that field - good catch. Do you have any other idea of why it will not work?? Thanks!

Hi, I am not sure where I went wrong here, but I keep getting NoMatch when there is a match. The record source for this form is a query. Thank you for any help! Private Sub txtFind_AfterUpdate() Dim rs As Recordset Set rs = Me.RecordsetClone rs.FindFirst "[Number]=" & "' &...

I understand - thank you Bob! As always your help is deeply appreciated! Also Bob, the below code seems to work. Do you see any potential for problem with it since it does not reference any recordset? Thanks you again! If IsNull([FinRatio])Then MsgBox "YES" Else MsgBox "NO" End If

Thank you Bob! That is a great idea and I will use it. But just so I can grow and develop, would you be willing to provide any guidance on how I could have done this programatically? I am curious as how one would have resolved this problem. Thank You!!

Hi Bob - thanks for the reply. The control that I would like to change is a label on the form - the actual fieldName is "FinRatio". The record source for the entire form is the Query referenced in the code "QueryName". All I am trying to do is as the user scrolls throught the form, if...

Hi - I am not certain what I am doing wrong here. I am testing this code to find if there is a value in a field - if not - I would like to change a certain control to a red color - but I am paused below because I keep getting "YES". Thank you for any help! Private Sub Form_Current() Dim...

No worries - this can be easily solved. In your code, where you have the line, activeworkbook.close Replace it with; activeworkbook.close False The "false" is the arguement that indicates you don't want to save changes - just make sure that the workbook you want to close w/out...

Hi - mabye, Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveWorkbook.Close False End Sub If you would like to save the changes to the Excel workbook, change the False to True in Activeworkbook.close

Thank you Bob!!!!!

Sorry to impose Bob - one more question - do you think the way I am going about clearing the table and pasting data is a good way to go? Is there a better way to do the same thing?

Thanks Bob - do you have any advice on the "Name Autocorrect Save Failure"? Thank you!

Hello all, I am using the below code to replace data in a table. The data is contained in a stored Excel File. The code works, however, after it runs it adds an additional table called "Name Autocorrect Save failure." - and a new record is added to that table each time I run the code...

I understand. I am sure how to do that - would you be willing to post a sample? Thank you!

Hi, I am using the below code. How can I ajdust the code so that row one in excel is ignored? Row one cell one ("a1") has a date which I want to copy to a textbox in an access form - I am not sure how to do that; Row two has the field names and the remaining rows have the data. Those I...

HA! That makes sense! Thank you good sir!

Hi, I have a form in a db with several commandbuttons. I finished working on the db. When I opened the db in a different computer, everything worked fine except the command buttons appeared gray - as if they were designed in 2003 and not 2007. In 2007 they have the blue-ish tint with the...

Hi all, I am struggling with printing my report. The report was cutting of on the right margin and printing two pages instead of one. I reduced the right and left margin, now everything fits on the report in one single page, but for some reason it is not centered. Can anyone please advice...

Hi - I would like to thank you all for your expert help. I employed your suggestions today and the code is perfect. This board is amazing. Thank you all!

Hi vbaInet - I just didn't want to have to write an if block to check every variable - but if you think that is the best way then I'll stick with it. This means that I will have to have serveral Docmd.openreport, one to activate for each potenial scenario, right? Is there no way to...

Hi all, I have several multi-select listboxes that are used to filter a report. I would like to allow the user not to select anything from the listbox, but that produces an error when the variable is blank? How can I fix this w/out having to resort to a dozen SELECT CASE? So if the variable...