user888
Last Activity: Dec 21 '06, 07:52 AM
Joined: Jul 11 '06
Location: Bulgaria
-
I guess in my first post the example i have given was not right. I don't need the active control but any control I have chosen in VBA above. I'm sorry I don't explain right what I need to do, I hope now I'm more clear about my problem. -
Tanx for the reply, but i don't need this to happen for the active control. Any other ideas?
I want to have a variable for example MyVariable = "Me.Text15"
I want to able to do sth like
MyVariable & ".Value=" & some value here
Now i want to execute this and i have no idea how.
text15 is not the active control.
Is it more clear now what i want to do? Can it be done in...Leave a comment:
-
"me." & me.activecontro l.name & ".value = " date()
that line should lokk more like
"me." & me.activecontro l.name & ".value = " & date()
however i still don't know how to make it work.Leave a comment:
-
execute a line
Hi! Does anyone how to make Access execute a line, something like this:
"me." & me.activecontro l.name & ".value = " date()
so, does anyone understand what i want and does anyone know how i can do it?
thanx for the help -
depending on the number of fields that my users can write criteria in, I use 2 approaches
1 if there are a small number of fields I make 2,3, 4 max queries and depending on wheateh the user has writen somethin in the criteria field or not execute one of them
2 if there are more options i write a procedure that generates the sql code of my query. someting like
dim sql as string
sql = "SELWCT * FROM ... WHERE "...Leave a comment:
-
try makind an excel file with macros that will do all the formating and printing you need. Then after opening the query copy all the data, open the excel file and let the file paste /throuth the macro/ the data and do all the rest you need to be done.Leave a comment:
No activity results to display
Leave a comment: