Search results

Actually, I think I've figured it out! I put my code into the Load event and it worked perfectly. Thanks for your help, Paul!

Paul, so sorry for the late thanks and response. I've been out of the office. I'm actually not very familiar with the format event. I think I've made the change you suggested, but now the report is opening but the fields aren't populating at all. Any idea what I've done wrong? Private Sub...

Wow...I actually had no idea about that. I guess that's something I carried over from Java. Thanks for pointing that out. I made the change you recommended (which in retrospect was a no-brainer...d'oh), but I'm still getting that error. Here's my current code: Option Explicit Private Sub...

Thanks Paul. After fooling around a bit that was the solution I came to, but now I'm getting an error that states "You can't assign a value to this object." Here's the code that I came up with. The error is happening on this line: txtPmtInst.Value = payIL Option Explicit Private Sub...

I have ten queries that I run at the beginning of each month that identify different transactions run by my team during the previous month. I'm trying to put together a report that lists each of these transaction types and the number that were run. It feels like this should be a super simple...

Here you go. Private Sub Worksheet_Change(ByVal Target As Range) Dim inputRow As Integer Dim dataRow As Integer inputRow = ActiveCell.Row dataRow = inputRow - 5 If Target.Column = 6 Then If Target <> "Partial Payoff" Then Sheets("Data").Range("AS" & dataRow & ":AZ" &...

Oops...sorry for the error. I should have been a bit more aware. Thank you both for your help and the tip. I'm still a novice at this stuff, obviously. I'd actually tried something similar to your suggestion prior to posting, but I made the changes you recommended anyway. At first it seemed...

I'm having a problem that is driving me batty. I have a workbook that has two worksheets with corresponding data, named Input and Data. I've written some code that is designed to update a particular cell in the active row on Input (using data from a cell in the corresponding row on Data) when...

Ah-ha! That did the trick! Everything seems to be working just fine now. Mark and CJ, thank you both very, very much for all of your assistance with this. I understand how frustrating it is to deal with someone who hasn't got a clue, and I appreciate that you've taken time out of your day to...

Mark, To answer your first post, my unfamiliarity with some of this led me to believe that you had omitted an End Sub somewhere, but I obviously goofed. I guess what threw me off was that Sub Save_Click had a header and an End, but I wasn't sure where to put the code you listed above it. As...

Yikes! You are correct. I fixed that, but the problem remains.:banghead:

Mark, I tried your ideas and I'm getting error message "Invalid attribute in Sub or Function" from cmdSave_Click. I obviously made a mistake adjusting your code, but I can't figure out where. Any pointers? Here's the code I used. And FYI, Code_1 in the table is a boolean, so I added a variable...

CJ and Mark, thanks for your help. (To answer CJ, RESPONSE_TYPE is a text field.) I rewrote the code several times before posting and while I could find the general area of the problem, the actual cause eluded me. Mark's comment made me facepalm, because of course he's right. Thank you so much.

Hi everyone. I have an unbound form in which a user enters data relating to a credit dispute, and when they hit the Save button I have a sub that is intended to insert that data into a table. This is a bit out of my comfort zone, so I found some code from another forum and adjusted it to my...

Gasman, THANK YOU. That did the trick! I knew it had to be some silly little thing that was easily overlooked. And thanks to all of you, for all of your suggestions and replies.

Nope, at least not originally. I did create one at Mark's suggestion though. The strange thing is, the problem is still happening even with the Function that Mark wrote. Even stranger, elsewhere in the sub I use the same method and the same variables to construct the name of the actual file...

Rookie and Dave, No such luck. The changes don't seem to make a difference. This is so strange, but I won't dwell on it, as Mark's suggestion to make my own function works quite well.

Thanks, Mark. It's so strange. I'm using Access 2010, but I had the same problem when I used similar code in Excel a couple of days ago. My backup plan was to build my own function like you suggested, but I wanted to run it by you folks first to see if there was an obvious goof on my part. :)

I'm having a strange problem using the MonthName function. I have code that (among other things) checks to see if a directory exists and then creates it if it doesn't already. The thing is, it works correctly for every month except June; for some reason, the MonthName function spells the month...

Thanks a lot for your help and welcoming spirit, guys! vbaInet's solution was ultimately what led to success. While removing the file extension resulted in more errors, changing acSpreadsheetTypeExcel12 to acSpreadsheetTypeExcel12Xml did the trick!