The vba tag has no wiki summary.
-1
votes
0answers
10 views
How do I append several fields as one indicator in continuous Access form using SQL Server [closed]
Please all, I need your help on this!
As you can see below, I have 3 OR search conditions, 4 in total. I just added an OR feature to this filter form and whenever I do a search beyond 4 rows, it ...
4
votes
1answer
112 views
Is there a difference learning VBA on Mac vs Windows
I'm a programmer who'd like to learn VBA, but I don't have a Windows box. However, I have a MacBook Pro with the latest version of MS Office for Mac on it (2011 I think). Since I work in a .Net shop, ...
0
votes
1answer
65 views
Guidance on Excel VBA resource scheduling algorithm?
This was posted originally at StackOverflow though suggested to post here instead.
I am looking to create an Excel VBA solution that will create a rota/schedule allocating staff to service users ...
1
vote
0answers
34 views
Visual Basic Excel Function - Range Offset Error [migrated]
I'm trying to create a function that will select a cell at an offset of (1,1) from the cell currently selected in Excel.
My subroutine is as follows:
Sub RangeOffset()
...
2
votes
0answers
224 views
Implement FBP / Dataflow programming in VBA?
Intrigued by Flow Based Programming a la J Paul Morrison. I wonder if one can implement FBP in Excel/VBA. I searched quite a bit for a Basic-Lang FBP implementation to no avail. I've looked at some ...
1
vote
1answer
149 views
Enterprise application with lots of SQL queries
Context:
I'm working on a fairly large Access database (which I inherited) that has its interface and tables separated. In order to make this work together, we have a lot of SQL queries (dozens). ...
-1
votes
2answers
732 views
What's the difference between VBA and VB Script? [duplicate]
I need to get VB Script training so I think it's a good start point.
2
votes
3answers
768 views
Query regarding VBA as career option [closed]
I am a dot net developer, with over 7 years experience in VB, Vb.net, C# and Asp.net.
Would it be worthwhile to learn VBA/VSTO? Would it be adding value to my career?
Would there be any companies ...
0
votes
3answers
220 views
Which programming designs leads to more problems?
As a fresh programmer, one of the first thing for me to learn was to learn language and its syntax. Now my next training issue is to design my code heirarchy in such a way it is simple to maintain ...
