Recent content by Raynx

Question from a friend: "When using a macro, when using GoToRecord, there are different options, such as First, Last, Previous, but what does the GoTo do?" Screenshot:

"You shouldn't be here..."? And what does HTH mean? Thank you, though. This does look like it work.

Er, how would I do that? I'm not VBA savvy, particularly.

Hey, I need help with something. I'm putting together a post office database, and the two most important fields for anything in this are "Tracking Number" and "Courier". "Courier" is whichever mail delivery service brought the package to the post office, such as UPS, Fed-Ex, DHL, USPS, etc...

Thanks everyone. We had already tried the button wizard "quit" option, but it wasn't working for us for some reason, which is why I asked for your help. Tried it again, though. Turns out my partner just did it wrong. Fixed now. Thanks again.

Thank you.

Hey, I'm working on a Post Office database and I need some minor VB assistance. I want to be able to click on a button labeled "Exit" that will, easily enough, close out the program. Make work, yes?

I am using a macro. I am using SEND OBJECT. I'm not putting the code into the TO field, but rather putting the code in an email field on a form and having the TO field pull from whatever is listed in the email field.

Nope. Deleted that single quotation mark and...the same error message. Darn.

Wow. That is rather long. Well, this is what it looks like on the display view: mary.sueIIf( [Student Year] = "Freshman", "0", IIf ( [Student Year] = "Sophomore" , "1", IIf ( [Student Year] = "Junior", "2", IIf ( [Student Year] = "Senior", "3", "*"))))" & Right(IDNumber, 2) & "@" &...

I changed up the code a little bit: =[FirstName] & "." & [LastName] & IIf([StudentYear]="Freshman","0",IIf([StudentYear]="Sophomore","1",IIf([StudentYear]="Junior","2",IIf([StudentYear]="Senior","3","*")))) & Right([ID Number],2) & "@" & "students.berry.edu" This works in the sense that after...

Alright, the IIf strings don't work. The last line (the one that designates the last two digits on the right of the ID Number as the last two digits for the email number) does work. So at least there's that.

Yeah, still not working. I tried both of your models for the code, but they did not work. I'm getting the same error message. I'll try simplifying it, going one step at a time. Are you sure that there are not any mistakes as for the spaces or other special characters? I am rather new to this...

Hey, thanks so much for your input. And, yeah, it is frustrating, especially when you're the guy that everybody points at for it. Well, I have a partner, though, so shared responsibility/blame is nice. Anyway, I tried to set it up the way that you showed me, and here's what it looks like...

Hey, I'm not incredibly new to Access, but I do need some help on something that may be simple to you guys. I'm updating/improving a database that a Post Office is using to track packages across a college campus, and they want me to build a button that they can click to automatically send an...