Author: TGoldenEye

How to Generate Email List from Excel

TGoldenEye

How to Get Email List from MS Excel using MS Access There are many ways to get the email list from the Excel list for sending email to those people. Many people may just copy the email from Excel then paste it on the Outlook new mail one by one. You cannot copy one time from the column C shown on the picture below then paste it on the Outlook mail To, because Outlook needs a semi-colon(;) between each email address. Also there is a blank email for some customers…

Read More

How to Change a Form Title or Caption

TGoldenEye

How to Change a Form Caption/Name When MS Access form is opened the caption or title of form will be the same as a form name that shows in the Navigation pane. Sometime many developers name their Access forms like “frmMain, frm_User, or CustomerEdit.” For an example below, I name my main form as “Main Form.” When this main form is loaded the caption or title of this form will display as “Main Form” on the top left hand corner. If we want the form title to change to something…

Read More

How to Create Report with a Link to Another Report

TGoldenEye

Report links to another Report The purpose for this How To is to create a summary report that has a linked field to open a detail report of that summary field. Example below will show a report summary of total sale for each month. There is a link on the total field that will open all list of sale for that month. This How To will provide step by step how to create these two reports. Creating Queries Step #1 We need to create a query that make a summary…

Read More

Function Clear Listbox()

TGoldenEye

Function Clear the Selected Items from the List Box VBA Code: Public Function ClearSelectedItem(lst As ListBox) As Boolean Dim varItem As Variant If lst.MultiSelect = 0 Then     lst = Null Else     For Each varItem In lst.ItemsSelected         lst.Selected(varItem) = False     Next End If End Function How to Use It: Put the VBA code above in the Module and call it on the click button anywhere on your Access file where you want to unselected items from the listbox. Example: if you have a list box names “lstCustomerType” then put…

Read More

How to Create a Split Form: MS Access

TGoldenEye

How to Create Split Form A split form is a new feature that introduced in MS Access 2007 that gives you two views of your data at the same time: a Form view and a Datasheet view. The two views are connected to the same data source and are synchronized with each other at all times. You can select a field in a record on a datasheet view then a form view will change to that record. You can also add, edit, or delete data from either part. Working with…

Read More

Function Open Image File – VBA

TGoldenEye

We use this function to open the image file. You can put this function in the module then call it anywhere in your Access database. Function OpenImageFile(ByVal strFilePath As String) As String  If IsNull(strFilePath) Then     MsgBox “File Not Found”, vbExclamation, “Action Cancelled”         Else         Application.FollowHyperlink strFilePath    End If This was made when President Barack Obama was also endorsed by cheap sildenafil no prescription the newspaper in the 2008 presidential election. Erectile dysfunction can cause a whole host of things you find to trawl through from footwear viagra uk…

Read More

Function to validate a Start and End date

TGoldenEye

*****Function to validate a Start and End date *****   This function is to make sure the information entered on these fields is a Date format and also to ensure the Ending Date is greater than or equal to the Starting Date. You should have two text boxes or two fields with a data type as Date/Time for the Start Date and End Date. Name two fields as StartDate for the Starting Date EndDate for the Ending Date call this function on the After Update Event of the EndDate as…

Read More