Recent content by drjohn61

For anyone interested, I have come up with a solution. It is a work-around kludge, but it works until I can find a better solution. I created a dedicated table in SharePoint that I write a record to, check to see if the ID is <0 and then delete the record. If the ID is <0 then SP is offline...

Hi all, OK, I have searched and searched... I have a few tables set up in Access 2007 that are links SharePoint lists. I have successfully found the code and set it up to toggle SharePoint on- and offline (as well as sync when offline). When using the toggle command, it shows in the status...

I guess I am confused. This is the code: (it is in the "PDD Schedule" form code in the zip file I uploaded) Private Sub txtScheduleDate_AfterUpdate() On Error GoTo txtScheduleDate_AfterUpdate_Err On Error Resume Next Dim rs As DAO.Recordset If...

OK, I cleaned up a test version. There are two tables in this DB. The Calendar Extended actually exists in the real one. The ScheduleDate one actually is a query generated from several other tables and queries. I made a table for simplicity sake. It did not change the outcome; I checked. Use...

no, it is not a calculated control. It is pulled straight from the table. I will see if I can pull out the forms and a sanitized table to upload (sensitive info and a HUGE DB :) ). It will likely be tomorrow.

Thanks. While we were discussing this, I actually pulled out my work laptop. I tried this, but it still hangs. I think I know of some other workarounds that will complicate the whole form, but this is FRUSTRATING. It should work! :)

I used expression is. [status] is a control that has a text value in it. It actually holds a person's attendance status for the day (In, Out, etc.) If the person is out, it is one color, on travel a different and so on. The condition works fine if I just load the form or move through the...

Thanks, I will use the IsDate()! Yes, the field and control names are different. and, yes, it shows that it is calculating when it hangs--until I click on something; then it is fine. I don't have the exact conditional formatting here, but it is an expression and something like: [Status] like...

My exact code is at work, but this is pretty much it (the find record version, which is my preferred method): Sub txtScheduleDate_AfterUpdate () Dim rs As DAO.Recordset If txtScheduleDate & "" <> "" Then Set rs = Me.RecordsetClone rs.FindFirst "[CalDate] = #" & Me.txtScheduleDate & "#" If...

OK, an update on this. I tried all sorts of variations and combinations of repaint, setfocus and refresh. nothing worked. There is no problem if the form does not have conditional formatting, so it has to be an issue with that--still not sure why only if filtering or finding from the main form...

OH..... duh! Thanks! I will give it a shot tomorrow.

Nice resource thanks! I will keep that one handy. I am not sure how that helps here though. I don't ever leave the main form. I guess maybe I did not get all of the info down. Sorry! The main form is linked (datasource) to a query off of table one. The subform is linked to a query off of table...

Thanks! I will try it again when I get back tomorrow (it is at work). I tried refresh, requery, repaint... nothing worked. I also tried various setfocus scenarios. The other weird thing is that certain fields on the main form don't update either (until I click on something) and the status bar...

Hi All: I have a form that has a data source set to a simple query off of a table. The form has a subform that has a child/parent relationship (date filed). The subform has conditional formatting set for all of the fields. Moving through the records with a simple DoCmd.GoToRecord , , acNext (or...

OK, Bob. That still did not work. I am attaching the DB. If you go to Article Info Form and then to the second tab (Details), you will see the CBs I am talking about. The Db is still fairly early development, so don't laugh TOO hard! :D Thanks for taking the time to do this, John