Search results

Hi all, I'm trying to attach a invoice (pdf) to an email with vba and I want the code to grab the invoice regardless what else might be in the document name, such as "Invoice 1" or "Invoice approved", etc.. The invoice is always a pdf file. This code works. It grabs the invoice as long as it...

I've searched and searched, but not sure if I'm using the right search terms... I have a search form that looks up records in a table and displays them on a subform (maybe I should display them in a listbox instead). Anyway, I want to be able to look down the list of results and click on...

Hello all, I have a user input form with a text box that stores a number. When the user inputs the number, I'd like it to display the comma separator (e.g. "1234" becomes "1,234". I've tried putting "#,###" and "#,##0." into the format property of the text box, but I still get 1234. I've...

Hello, Thank you in advance for your help. I have a Main form with a combo box that pulls names from a table. Alongside the combo box is a command button that opens a form which allows the user to edit the names in the table. The problem: When a user edits a name and closes the edit form...

I've searched several formus with no luck. I would like to have Access launch an Outlook email with a specific font (Arial). How could that be accomplished? Here's my code: Private Sub cmdEmailAO_Click() On Error Resume Next Dim OApp As Object, OMail As Object, signature As String, Email As...

Greetings, In an Access 2010 db, I have a Web Browser Control that displays the contents of a network folder. ="\\Net1\Data\Clients\ClientFiles\" As the user clicks on subfolders in the browser, they may have the need to go back (up) to a previous folder. I need a "back" button. Is it...

I just upgraded to Access 2010. I can't delete or paste database objects in the table, form, query lists, etc.. Is there a setting that allows this? :banghead:

Before I start asking a lot of fool questions, I thought I'd do some research. But I don't know what key word(s) I should use. I'm building a "management page" (for lack a a better term). It's a form focused on a table that contains custom information that can be referred to and used by the...

I can't seem to find the right answer.... The following code puts the text box contents in the "To:" section of the email. But on the form, the text box only includes the person's last name and I want it to go to a table and pull either FullName or Email and put it into the "To:". (it's not a...

Hello, I am a relative novice in Access, but have successfully built several functioning databases. On my current project, I have a search form with multiple search criteria that displays the results in a subform. After inputting the desired criteria into several text boxes, the user clicks a...

Hi, I am more or less a beginner in Access. In my db, I have a search form with two input criteria (cboYear and txtInput) that populate a hidden text box (txtSearchString). The search results are displayed in a listbox (lstSummary) based on a query (qrySearch). The OnChange events allow...

Greetings, I have finished creating a new database (my third) for my company and I am about to add user security. On start up, I would like to have a macro open one form for one department and a different form for the other department. I don't even know where to start. Can you point me in a...

Hi, I'm having trouble finding the correct code to open a network folder by double clicking on a record in a listbox on a form. The folder names are the record IDs. Any help is appreciated. The code I have been messing with is: Application.FollowHyperlink...

Hi, Novice question: Is it possible to have a query be the control source for a text box on a form? The code I have been trying to implement is: SELECT Table2.FirstName FROM Table2 WHERE LastName = "Anderson"; If I could figure that much out, I would replace "Anderson" with another text box...

Several command buttons on my switchboard open a search form. (The OnLoad event of the search form runs a filter with the matching product results displayed on a subform.) Depending on which switchboard button is selected, I want each one to set a different BackColor of the search form as it...

I have spent all afternoon trying to solve this one. Bigtime rookie. The record source of my report is a query. I want my report to display data from the query that fall within two dates on a form. The Filter property is set to read: = "BoardingDate Between Forms!frmReports!txtFrom And...

Thank you in advance for your help. I have a filter that uses multiple criteria to produce a report. It works great with one exception. When the Between function is followed by another criteria (such as "Action" required) I get an error message: Run-time error '3075': Syntax error (missing...

My access database opens with a search form that allows the user to enter multiple criteria into various fields. A command button then builds a filter based on the user’s choices and displays matching records in a list box on a subform. The On Click code is: Private Sub btnSearch_Click()...

Thank you in advance for your time and help! I have a command button on a form that has the following code: Private Sub LibraryFile_Click() Application.FollowHyperlink "\\Server1\data_admin\Library\2007\" End Sub This opens a folder containing separate folders for each record, which contain...

I want a command button in an Excel form to clear dropdown fields on the form. Can anyone tell me why this simple VB code will not work?: Private Sub CommandButton2_Click() DropDown4 = "" DropDown7 = "Choose from List" End Sub