| Recent Answers from Richard Rost |
 |
2008-11-06 Selection from drop down menu un-checks a check box: You can use an AfterUpdate event to set values, change properties, run macros, and do lots of other cool things. Please see the following FREE video tutorial on my web site for step-by-step instructions...
|
2008-11-06 IIf Statement in a Query: You've got too many parameters in your IIF function. It only takes 3: =IIF(Condition, True, False) So you'd need something like: =IIF(EffDate<#1/1/07# OR EffDate<#2/1/07#, True, False) See:...
|
2008-11-06 adjusting one column's data in a report on another column's data size: Use basic string concatenation: http://599cd.com/tips/access/string-concatenation?key=AllExperts Let me know if you have any other questions or comments. Also, be sure to visit my web site and...
|
2008-11-06 Making a query in MS Access 2003: Yes, you will need to get that into a standard date/time format like mm/dd/yy using some string manipulation. This tutorial might help you: http://599cd.com/tips/access/break-up-text-string-instr/default...
|
2008-11-05 Forms: Trish, sometimes depending on the relationships you build with your queries, you cannot EDIT the records those queries create. Without seeing your database I really can't tell what you've done, but try...
|
| More Answers for "Using MS Access" |