Thank you very much - it worked (with one more modification which was to take the END IF).
So irritating it took me 20 hours to not figure it out.
Thanks again.
JimInAJam
Last Activity: Apr 8 '08, 12:55 PM
Joined: Apr 13 '07
Location:
-
Editing Module - subs are removed from wrong module
Hi,
Please don't stress to find a solution - I've got a workaround I just want to see if I can improve on it.
I'm using Access 2003 and have a form module which I want to edit using a standard module.
Please find below the sub from the standard module.
When this runs the text from the standard module get's eaten up and eventually self distructs and shuts/crashes Access down.
... -
Thanks I was using the wrong event proc.Leave a comment:
-
There is more to it than this but this is an easy way if you are just staring out.
You will have to create a VBA sub (at the back end of a button or on some other form event - basically whatever it is you are using to start the query).
Declare your variables for start and end date + one to build the sql string for your query.
dim stDt as string, edDt as string, sqlSTR as string
Use an input...Leave a comment:
-
Is the data on the form a date type?
Have you tested to see if half of the expression works?
Have you tried to put constant form the form in the select list so that you can check its picking up and evaluating.Leave a comment:
-
select col1, col2, col3, col4
from tbl
group by col1
or it may be the other way round
group by col2,col3,col4
you get the drift.Leave a comment:
-
Control Name relating to a Shortcut Menu
I'm using Access 2003 for an application where intermediate level users are able to change some but not all of the proporties of controls or groups of controls on a form.
After much blood, sweat and tears I've been able to get some Sortcut Menu's to appear and add some of the contols I need (I reserver the right to ask about combo box data sources). First thing I want to do is change the caption on a lable.
The issue...
No activity results to display
Leave a comment: