VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have an access form, "frmCompetition" with a subform, "sfrmDogBrace." This is a database for field trials for bird dogs.   I would like to filter the contents of the subform based on selections I make in 3 separate comboboxes in the main form.  Any advice?  I've tried makeing the underlying query of the subform reference the contents of the 3 comboboxes as criteria.  No luck. Is there some vba code I could use?  My comboboxes are cboyear, cboday, and cbo brace.
0
Prep for the ITIL® Foundation Certification Exam
LVL 11
Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.


I am using macro & pivot table  and I have variable dates and time as (06/03/2016 11:27) ,  now I want to filter data based on date & time ( for example yesterday 11 PM to today 7AM) .

Can someone give vba code for this.
0
 
LVL 34

Expert Comment

by:Rob Henson
You have created a Post here. You will get better responses from EE Experts if you raise a question. Use the big blue button at the top of the screen or this link:

https://www.experts-exchange.com/askQuestion.jsp
1
I seem to recall that it is possible to get instant help from an expert via Experts Exchange.  Is that still the case?  What I need is MSAccess VBA and SQL.
0
 
LVL 22

Expert Comment

by:David Atkin
1
 
LVL 17

Expert Comment

by:Kyle Santos
Hi Biggles1,

You are correct and the two comments above mine are where you would need to go and create a new request to get 1:1 help.  =)
0
Hi,
Every week, I need to run 7-8 reports from external software for same week period for almost 8 branches, is there any VBA codes which can help me to automate the process, where it saves all reports automatically from external software on network directory just by adjusting dates? Your help will be appreciated.
0
 
LVL 25

Expert Comment

by:Brian B
You have entered this as a post, but it looks like it is a question. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the screen, or this link: https://www.experts-exchange.com/askQuestion.jsp

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
 
LVL 25

Expert Comment

by:Brian B
0
HI I would like to make a simple excel vba to create outlook e-mail. I basically know what to do but I want to know how I can setup "sender".  I would like to set sender different address but not me. would you please help?
0
 
LVL 34

Expert Comment

by:Rob Henson
Hi Luke, you have created a Post rather than raise a question. For better responses from Experts, please use the big blue button at the top of the screen to raise a question.
0
how to find the hanging space in the n number of bullet text i.e. show the space in between text and bullet for each paragraph and also find the font size in the bullet text in power point all slide using VBA.  Any help me that it is very useful in my environment?
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi Satishkumar,

Welcome to Experts Exchange.

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
I had a need for a “colour picker” for the nice original Windows Phone colour palette. The codes are impossible to remember, so I was looking for a method to point and click to copy a value for later to be pasted into a property pane.

As I wanted all values presented in the three often used formats for CSS, VBA, and as hex values - and had the colour values as an enumeration – I also needed some converter functions. Not much, and with a simple loop all field values could be set.

However, writing code for 63 fields looked like a daunting task. This is where WithEvents came in and solved that with a few handfuls of code.

I wrote it all up here as there are so few examples found demonstrating WithEvents:

    https://www.experts-exchange.com/articles/29554/Create-Windows-Phone-Colour-Palette-and-Selector-using-WithEvents.html

with a reference to John Colby’s old tutorial on WithEvents for the interested reader. The only principal difference to John’s example is, that I didn’t use 63 variables but a collection (as I learned from Shamil Salakhetdinov) to hold the controls.

The colour palette of Windows Phone I have previously used here:

    https://www.experts-exchange.com/articles/17684/Modern-Metro-style-message-box-and-input-box-for-Microsoft-Access-2013.html

/gustav
3
 

Expert Comment

by:Daniella Barion
That's great. I am sure it will help a lot of people.
0
Helen Feddema is one of our resident Microsoft Access experts.  She just published two new articles today.  If Access is something you're interested in knowing more about, then follow Helen!
https://www.experts-exchange.com/members/Helen_Feddema.html
2
New member today got a solution today.

After searching the net for help it became apparent that there were professional contributors on your site willing to provide expert advice. The advice given was very fast and first class.

Fred
This was their question that was answered.
https://www.experts-exchange.com/questions/29012797/Create-Dynamic-Range-Via-VBA.html
3
4
 
LVL 52

Expert Comment

by:Jackie Man
You need to install software like sophos intercept x in computers inside your network to block it.
3
 
LVL 7

Author Comment

by:Brian Matis
Personally, I'm just avoiding opening any Word docs from anyone I don't know... And to some extent, even from people I do know... Most of my document usage these days is with Google Docs, so it's pretty rare that I need a Word doc!
1

VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.