Search results

Sorry, no. It's a continuous form (not a subform, it is it's own form), and it is populated by a query of a table which holds all of the Agents, Agencies, and e-mails. Then the query is instructed to filter the form based on a combo box which lists all of the agencies (I removed the other combo...

Hi all, I wasn't totally sure where to post this, because I'm almost positive I'll need to use some VBA to get it done, but I have form that it is running from, hence the post here. I currently have a multiple item form which is populated by Agents and their Agency. Currently the form can be...

David, You sir are a life saver. Thanks for the knowledge spike, I'm new to VBA so that's nice to know :)

Sure, I'm using the SendObject command, so my code currently reads like this: DoCmd.SendObject acReport, "", "PDFFormat(*.pdf)", [Email] & "; " & [Email2] & "; " & [Email3] & "; " & [Email4], "", "", "First Quarter Invoice", "", True, "" There are no variables other than the fact that there...

Hi all, I have a report which users of the database need to be able to email. I have the SendObject all set up, minus one little problem I'm having. The e-mails that the report has to be sent to are entered into the database, and there are up to 4 e-mails that the report may have to go to at...

Hi all! I've been asked to create an 'undo' button for any changes that users may make to the database I'm building. The way I went about this was creating an "Archive" table. When the user tries to edit information through the form, all of the information for that client is automatically...

Thank you so much Bob! The more you know.

I am not good at VBA at all. I have dabbled a little bit building this database, but I still can't even really read it, I just know what certain strings mean. I'm trying to get a list box populated with names and e-mails to return the e-mails in a list, and separated by semicolons. Microsoft's...

I have a form which lists names of Agents and the Agencies which they work for. I currently have a combo box which allows the user to pick a specific Agency, so they can view only those agents, and a list box which I want to list the name of the Agents so the user can choose some of them, but...

Thanks a lot for the list box tip Mr. B, I just have a couple of questions regarding it (I'm pretty new to Access). Firstly, is there a way to filter the list box? For example, my fields in the list box are agent | agency | e-mail. Could I create a combo box (or something similar) to filter by...

Hello everyone, and thank you in advance for your time and help. Just ahead of time, I am using both access and outlook 2007 I'm currently building a database for a company, and something that has been requested is confusing me to no end. The users would like to be able to send mass e-mails...

Hi all! I recently designed a number of reports for a company to use as invoices. They run the invoices quarterly so there are 4 separate reports, 1 for each quarter. I wrote code for a button on a form which will run a specific report based on what month the button is clicked in (i.e. if it is...

Thanks, but I don't want to send an object, just want to extract the email address from it, but I'll go look/post in VBA. Thanks again.

Is it possible to extract just an e-mail address from access, and insert it into the 'To' field in outlook? For example if 'Email Address' were a control on a form, or a report, could code be written to extract just that? Thanks for any help!

Is there a way to do this with a command button, instead of through the ribbon? My database will be designed for a number of end users, and I have disabled the ribbon for most FEs due to security concerns.

I'll answer my own question here for the benefit of anyone who comes looking for an answer to this question. The trick is to use the MonthName() Function. Combining this fucntion with the Month() and Date() functions will produce simply the current month. In other words, today the function...

Hi all! Just wondering if it is possible to take a calculated field from a report and use it to populate a field on a query? I imagine the name for the field would look something like FieldName: [reports]![rptName]![FieldName], but I haven't been able to get it to work, so I assume I'm doing...

Thats really helpful! Thanks for the thorough explanation too! I love these forums because I always learn instead of just being given the answer :D Thanks so much!

well like i said, I've just barely started using VBA and Access, but what I tried was along the lines of If [cboA]="Yes" And [cboB]="No" Then DoCmd.OpenForm "A", acNormal, "", "", , acNormal If [cboA]="No" And [cboB]="Yes" Then DoCmd.OpenForm "B", acNormal, "", "", , acNormal If...

Hi all, I'm really new to access, and even newer to coding. my basic goal is to have a button open 1 of 3 forms based on some criteria on the current form. I have 2 combo boxes on the original form which can be either a yes or a no. I would like the button to open 1 form when 1 is yes, 1 when...