All Questions
6 questions
0
votes
1
answer
99
views
Access-Dynamic Forms
I have a form "alpha", which I am trying to dynamically alter. My code currently is very simple:
Dim frm as Form
Dim strName as string
StrName="alpha"
Set frm = CreateForm(...
- 150
0
votes
0
answers
30
views
Date format in dynamic SQL - VBA in MS Access [duplicate]
In Access I have this code. Variable data is type Date, however, when I insert it into dynamic SQL code as string it formats date to 18.04.1994 whereas SQL date needs to be in US format 04/18/1994.
...
0
votes
1
answer
145
views
How do you write a dynamic MS-Access VBA function call across multiple modules?
I have a scenario where I have multiple modules that contain a "CreateMember" function. I have a single Sub that makes a decision which module to call out to, however the dynamic call ...
- 3
1
vote
2
answers
1k
views
Dynamically Populate VBA Array
In the example syntax below, how can I add each element to a new array instead of printing? I am unsure how to do such as I would not know the size of the array, since it could be 0 (no need to ever ...
- 559
1
vote
1
answer
487
views
Trying to open another form in Access based on a field in the current form
I have a form that's just a list of descriptions (desc.) of other forms. Right now, when you click on a desc., the appropriate form opens; but it's done through a series of if statements in a macro. ...
- 13
5
votes
2
answers
9k
views
How to Dynamically Change the Rowsource of an Access Chart
I would like to know if there is any way I can set the rowsource property of a chart in my report at run time.
I intend to have a chart in my report's group header section. The rowsource of this ...
- 618