I have 2 option boxes, impact and likelihood, with a numerical value. I would like the calculation of impact * likelihood to be updated in a text box for severity. Is this possible?
I am able to successfully import all emails into a database, but so far have not found a way to import the attachments. I can manually add them as OLE objects, but I'd like to grab everything at once. Is this possible?
I'm having a problem with a date reverting to 12/30/1899. I have a form set up so that when I click the checkbox the date field displays. I enter the date mm/dd/yyyy and it displays correctly on both the form and in the table. But if I uncheck the checkbox and click again, the date changes to...
I have 2 tables related by Project_ID. Table 2 has a text field for status and a date field for date of status.
I want all of the fields in Table 1 and the status from Table 2 with the most recent update for a report.
My query has all of the records from Table 1 with "Group By" in Totals. It...
I have a table named tblhistory that I have added a new field called FieldB. Either FieldA or FieldB can be null. One has to be null. I have the following code to update tblhistory with values entered on a form, but I am unsure how to make it accept nulls. it keeps giving me an error because...
I would like a date field on one form to automatically update with the date value from another form when I click a checkbox. I've tried using the default value on the propery sheet to no avail and get an error each time I try building the code on the checkbox.
Any suggestions?
I currently have a form with various reports. I am using the OnClick event with a command button and want to combine code to cancel the report when there is no data. This is what I'm using but I get a runtime error 2501 "the openreport action was cancelled". Any suggestions would be most...
I currently have a form with various reports. I am using the OnClick event with a command button and want to combine code to cancel the report when there is no data. This is what I'm using but I get a runtime error 2501 "the openreport action was cancelled. Any suggestions would be most...
I am trying to change the default for my checkboxes so they are not shaded. I'm sure there is a very simple solution and I'll feel silly once I receive the answer, but can anyone help? It would be greatly appreciated!
I am having issues with checkboxes not holding their value and have been told that this is a known problem that has to do with shading. How do I change my checkboxes so there is no shading?
I have a combo box that inserts data into an unbound list box and table. This works great but I am having trouble with the deletion part. I want to be able to dbl click on the item in the item list and delete it from both the list box and table. Currently, my code is deleting ALL items, not just...
I am trying to autofill a field based on the value of a previous field on a filtered form. I think the fact the records are filtered is throwing me off. Any help for me?