ahh, makes much more sense now.
one last question ( i swear this is the last question, because i can see very clearly now how to solve the problem).
how do i go about selecting a textbox, and then upon this, populating/changing/clearing the text currently present in the text box? thanks!
it isn't my data, just some sample data i am learning off of.
i understand what you are saying , but the data must be presented in the way listed above.
i basically just need to know how to print data into a report in a way that you can dictate where and how it prints.
that is my main issue.
this is access, sorry. the excel was to demonstrate my train of thought.
Region City Month Rain
NE Maine Jan 2
NE Maine Feb 4
NE Maine Mar 2
NE Maine Apr 5
NE Mass Jan 2
NE Mass Feb 4
NE Mass Mar 2
NE Mass Apr 5
SE...
okay let me reword and stop trying to rush through.
basically, i need a way to create a parent child and fill based report as above.
basically:
header=region(1)
col(1)=month....col(n)=month
row(1)=city(1)
and then fill based off those selections. i'm just really unsure how to do this. i was...
not really.
i'm very new to this. i basically just need to know how to navigate a report form and be able to print things in an algorithmic way.
as in
Cells(1,1)=1
cells(1,2)=2
this is for excel. is there a way to navigate the sheet and print things? that is basically what i want to do.
Basically: I have weather data broken up by region, state and month
I want to make a grouped report in the following hierarchy/grouping
Region
-State (on the "Y axis")
-month on the "x axis")
And then weather filling inside
:: As in ::
New england
Aug Sep
NY. 10...
okay, silly error, i did not check that. my location was office10, now 11. that is solved.
yet still,
i am being told that my macro is not being found.
Modules: Module1
Macro Name: Data
harley,
i mean that i ran my vba coding within access, and it executes my desired task correctly (some ground up debugging), yet when I attempt to run the .bat code, it is unsuccessful at running the macro (access does not open, there is no action aside from the command line opening for a...
thank you for the very helpful post found here:
http://www.tek-tips.com/viewthread.cfm?qid=1364093&page=1
my .bat file is below
"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\Documents and Settings\Administrator\Desktop\simplestaticsimple.mdb" /x Data
i see the command line pop...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.