Hi there,
I have a main form with no data, and subforms on tabs with data. The data in the subforms is not linked to the main form.
I would like the filter by form to pop up based on the subform. But I need to put the button on the main form. I want to keep the subforms in datasheet view...
Hi There,
I have a report that shows totals for each year:
Year Sales
2009 $100
2008 $90
2007 $50
I need to add in a percentage to show the increase or decrease from one year to the next:
Year Sales %Change
2009 $100 111%
2008 $90 180%
2007 $50 ---...
Hi there, I have what I think is a simple question, but I do not know how to write the join statement.
I have two tables:
1) tbl_Customers with the following fields:
Customer_ID Customer_StartDate
123 3/1/2009
224 2/1/2009...
How can I check to see if a table has data? Based on whether or not tbl_Codes has any data in it, I want to run one of two macros. I need a boolean or similar function to let me know if tbl_Codes has data in it or not. I know how to set the macro after that.
Thanks for your help!
How can I check to see if a table has data? Based on whetehr or not tbl_Codes has any data in it, I want to run one of two macros. I know how to set the macro, but I need a boolean or similar function to let me know if tbl_Codes has data in it or not.
Thanks for your help!
Hi there,
How do you continue a line of conde onto the next line. I have a very long line of code, i would like to break it into a few lines. I am using the VB editor in Access 2003.
Thanks,
Jayme
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.