I have figured out how to build a custom toolbar that opens tables, queries, and forms within the access database. But how do I program buttons that will open word and excel docs related to that database but not IN the database?? Thanks.
How do I prevent my numbers from rounding in tables, forms, and reports? I have specified standard format with 1 decimal place. However, Access keeps rounding up/down and giving me a 0 for all decimals...
Is there a way to link a form field for another form in the same database (similar to a hyperlink or OLE to another document)? For example, the first form is a table of contents and the second form is the first item in the table of contents (so you can open the second form without going to the...
I have designed a very eye-pleasing report in access. However, it must be exported so that Officers and higher-ups can read it (asking them to use Access is not an option). Is there a way to export the report, format and all? Rich text, text, and html disregard colors and backgrounds, and...
Is there a way to change the font color on a single record for changes made to the text field (to track changes in form from year to year.) I coded the onchange event for a field and it did change, but it changed the whole field for every record. I just want a portion of the field changed and...
I have multiple records in my database, of which different fields for each record are null. I want the report to show only fields for each record that are populated. For example, fields: a, b, and c for records one and two are 1, 3, null and null, 5, 7, respectively. How do I make the report...
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.