Search results

There doesn't appear to be an After Update on option boxes and putting the code in the priority box isn't working either. any other ideas?

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?

Did you create a field in your table as an OLE object and then put it on your form or did you create it directly from the form? You should be able to use the insert object wizard to bring the attachment in and then view it full page each time its double clicked.

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?

You are absolutely correct!! Thank you so much!

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 used the sql provided by ByteMyzer in the "Max of Count" thread and it solved my problem beautifully!!! Day saved!

This worked beautifully for my max problem also. Thank you so much!!!

Thanks! That at least gives me a work around until we find the absolute fix :-)

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 guess I misunderstood, sorry. I was thinking you could use the search on the main form to take you directly to the record on the main form in lieu of using your current query method.

Excellent!! That fixed my problem. Thank you so much!

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 would place the search on the main form you want to update. Create an unbound combo box on the main form. The data source should be the name field from the table/query. The name can then be chosen from a list in the combo box. Then create an “after update” event for the combo box. Sub...

That appears to have worked!!! Thank you so much!

I removed the line and now the report opens while there is no data.

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'm no Access guru, but I have forced sorts using the following: You could create a field in your query called Sort and assign numbers to each month. Ex: Sort: Switch([fieldname]="January",1,[fieldname]="February",2) Then in the sorting and grouping on your report, sort on the “sort” field in...

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...