Search results

Does anyone know of an easy way to set 3 different text fields to automatically fill with the same info? I have an online store database, and would like to have certain postal fees and charges to automatically fill in because they never change. Also, I have a lengthy refund policy that i would...

Thanks Bob, I'll try it and let you know. I fixed this problem on 1 computer last week. I believe you helped me with that one too. Now it's doing it again on another computer, only with this new error I posted about. So, I'll try to fix this other machine too.

Does anybody have any idea what this may mean? "Compile error. can't find project or library." This function is supposed to launch emails from outlook. Thanks

Thanks for your reply. Apparently there are some freebies out there. I was wanting to learn this to help me design better access databases.

Is VB a language that can be learned, or is it an application only? What I mean is, everytime I search it on the internet, it's a "buy this program" type thing. Is it a language I can teach myself with a book, then use notepad like I would html, or do I need an actual program? Thanks!

Is it possible in access to create a search box that not only finds documents by title, but finds them with a "contains" criteria as well? Also, when I use a combo box and type in something that doesent' exist, I get the "end" or "debug" message. I believe I can solve this by setting a "null"...

Somebody built a database that I'm trying to fix. It pulls information from an online spooler service and processes it into access. However, it's giving me this error message now. Does anybody know what it means? Thanks!

I finally figured this out if it helps anybody in the future. The reason access wasn't including attachments, and giving me an error code was because the subject header was shortened with ... added. Example: Dear Cust.... I went through and finished all the subject headers like: "Dear Customer"...

Unfortunately I can't, the company won't allow it (for now anyway). I will try to muddle through and if i absolutely can't, I'll get permission to post it. Thanks, I appreciate it.

Ooops, spoke too soon. Now it's not adding the attachments-which are only links, not actual attachments. This is hard to figure.

Fantastic tip! It still gives me an error that it "can't find the attachment", but at least it's sending the emails. And it is sending them with the attachments, so I'm not sure why I'm getting the error. Yes, there was a .dll missing. I'm not sure what you meant by VB editor, so I went into...

I'm pretty new to Access, and we normally have a system where emails are automatically pulled from the database and sent thru outlook. Now, a problem has occurred, a computer died, and I need to set up the same system from another machine. When I try to send the email from another machine I get...

Okay, thanks, that's great info about uploading a db. I never knew about the compact and repair feature. I know about zip files and how to save and upload, but not the other, so thanks! I can't upload this database because it has confidential records in it, but on the next one I will.

Actually, I don't know how to post the database.

Thanks for all the help, but again, the combo box does not work. I'm using MS Office Enterprise, maybe there's a bug, or a necessary service pak. In any event, I think I've wasted enough time on this form as it just not going to work. I'm thinking of starting over. If I find a cure, I'll post it...

Yeah, that's one of the variations that I tried. It doesn't work either. It's a real tricky one, that's for sure. I'm sure it's some little hairline difference between the 2 program versions, I just don't know what.

the highlighted text is this: rs.FindFirst "[ID] = " & Str(Me![Combo71])

Well, let's see if I can explain it better. I've built one form for advertising. I use the combo box to find advertising contacts. This combo box works fine. So, I built a second form for printing costs. I have several records that I need to access (pun intended), which is "print projects"...

Okay, well thanks to statsman, I got the query and text box idea to work out better until I can find a way to make the combo boxes actually work in access 2007. I have several forms, but only on one form does the box work. I actually prefer the combo boxes, and used them on many previous forms...

I was wondering if there was a better way to find records other than a combo box-or the search at the bottom. I'm wondering if I'm making too much work for myself, or if combo boxes are the way to go. I have several forms with lots of records. I use control buttons to go to each form. and on...