how do you turn on the dashed guidelines that help you line up things to another object? For example if I want to draw a line and I want the starting point to be at the intersection of a point on an object above and to the side of where the line needs to go. How do you turn on the feature that...
Is there any way to update a DateModified field in a table if a record is changed? I know this is possible when the data is changed in a form but what if someone changes the data directly on the table. Is there any way to record this?
I have to setup a system to track our loans. Need it to work like a bank would handle the loans. Here is what I have so far.
Tables
LotInfo
LotID(primarykey)
LotLoanRef
LotID(primarykey)
LoanID(primarykey)
LoanInfo
LoanID(primarykey)
LoanType
Bank
LoanNumber
Interest Rate...
I have a Vendor field for each Vendor and a cost code field. What I need to setup is when a vendor is chosen only the appropriate cost codes for that vendor are available to choose from the combo box. How do I do this on my form. We are having problems where the data entry person enters a cost...
I have a table that I want to lock the data once it is entered so that it cannot be changed. The data in the table however needs to be modified when errors are found and a history of the the changes, who changed them, and why needs to be recorded. What is the best way to go about this kind of...
I have a record that excludes one record using this code
<>"4097"
I now need to exclude a few more records as well. I tried to use
<>"4097" And "5002" And "5474"
This did not work. It only excluded the 4097 .. so what do I use to exclude more than one non-consecutive record.
I have a report that has various grouping for subtotals and a grand total at the bottom. Is there a way to total a range of items at the bottom of the page that is not influenced by my grouping? The range of items i need a total for falls into many of the different groups.
I have a report that has different sorting and grouping levels. The group names come from a group name table.
How do I get the report to show a group name in the header for a group that does not have any records? It works fine for any groups that have at least one record but I need it to show...
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.