Search results

I guess I should have mentioned that the second attachment is causing issues with some of our customers, so I'm looking for something I can do to prevent the attachment from being created. I am not including any images in the emails that are created. Thanks!

Hello! I have created a small application which generates PDF invoices and emails them to our customers. In many cases, these customers have a system on the other end which accepts the PDF and enters it in to their AP system. We send invoices to about 150 customers a day, and most report no...

The subform is on an order entry form, and it's used to enter the order lines. The specific field that has the LostFocus event that's firing is for item discount percentages, and it recalculates the line value and updates the total field on the line (if the discount is greater than zero).

This is what I tried after reading jdraw's comment, but it still didn't change anything. Thanks, though!

Hey all, I'm kind of stumped with this one. I have a parent form which is being refreshed from another module using the following: frmParent.Refresh Immediately after the line of code above, the code jumps to a LostFocus event on a child form belonging to frmParent. frmChild is in datasheet...

Hey everyone, Thanks for the responses. Turns out that this was an issue with the table in the database. When the table was created by the DBA (scripted out from the original that was working), the primary keys were not defined. While I defined them in Access when I linked the table, I was...

Thanks for your reply - I get the same error, but just on the following line. The code for that line is just assigning a variable to a field, but here it is anyways: !STATUS = m_strStatus

I did a search, and found some results, but none seemed to address the issues that I am having. I have two database tables, which have identical structure. Each table is hosted in a different physical and virtual location. My application connects to both databases. Editing table 1 works just...

Thanks! I ended up doing exactly that.

Okay, so I figured out what the issue is.. I think. First, I checked the relay server's email logs, and noted that when I was receiving a fail, nothing was even getting to the server. I was using the same email address when stepping through the code, and when executing the whole thing. Both...

You're correct, it did fail. I understand that it could be a permissions problem, but I'm going to have difficulty explaining that to my network admins when I've successfully sent to external email addresses (as noted in my examples above). Can you help me understand why this might be happening...

Thanks. Here is the main procedure: Public Sub Prep_Daily_Summary(strDate As String) strSender = "email@email.com" strRecipient = getEmailsForDailySummary(TargetCompanyID) strSubject = "Email title " & strDate strAttachment = "\\CSVPath\" & strDate & ".csv" strMessage = ""...

Hi everyone, I am working with an Access 2003 application, and one of the functions of the program is to create a csv file, and then send it to a list of email addresses which are stored in a database table. The procedure that creates the csv file works every time. The csv is created, and it...

Thank you!

Hey all, I am working on an order management system where a user can enter an Order ID into a text field, tab out, and it will load the order. This is done by using the LostFocus event to call a module which loads the order. It works as intended - I have no problems whatsoever with loading...

Hopefully you're able to get the data from the bar code scanner to access? I've never done that before. There are some tutorials if you google "using a barcode scanner with access". After you are able to get the input from the scanner, you'll need to load the EnterInventory form using the code...

I just got your private message.. but since I don't have a high enough post count, I can't respond to you. I'm just going to grab a bowl of cereal, and then I'll write you a proper response. Thanks!

A simple way to do this would be to use the AfterUpdate event for the textbox to load the EnterInventory form, and pass the barcode value to the form so it can be used in your query. You can set the RecordSource property of the EnterInventory form to your FindProduct query, and use the value you...

Thanks, everyone. I'll give these options a try.

So I kind of figured out a solution to this. I pop the report using the acViewPreview parameter, and then right click on the report header or hit Ctrl-P to print. Does anyone know if I can get a print button to show up at the top of the preview? I suppose I could code a button into the upper...