Activity Stream

Sorry, got ahead of myself here. I had already deleted tbl_OrganizationContacts from the query when I posted #14, so it is the same query.

I will try. A driver calls in saying he needs to go from point A to point B with a load. Permit agent creates a new order The order states is...

Hi The Relationships must be set in the Backend

We have a moving target here. That's not the same query that's in the DB that you posted. If there are no fields from tbl_OrganizationContacts...

relationship between tables.

Mike60smart, I am confused. When I look at the relationships I do not see a connection between tblErrorIncedent and tblIncidentStatus. If my...

Hi Can you give us an example of a Route and the Permits required for that Route?

Davergi, The qry_appendNewIncident has a little more text in it than you circled for deletion: Do I delete the part that says From...

No resolution yet to the current database issue as described above, however I went to a copy saved in May and I was able to copy/paste the "problem"...

Agree with the advice but I suspect the procedure doesn't know what this is Form.Recordset.Fields

Thanks again for your input! I will go through the tutorials you suggested and continue to design the model. I'll keep the forum updated!

I tested using an external path as ControlSource of BoundObjectFrame and it fails. I could not see any way to use UnboundObjectFrame to...

To determine relationships you have to understand the business and the business rules/facts. Too many think that by buying Access (or any DBMS...

I've checked with my partner, she's the one that issues the permits for drivers and she said it will always be just one load/equipment per order. So...

Ajax, I think I was looking for clarification on that too in post 9. Didn't get it...

How is it different?

If it was created with Access 2010, why does it show mdb file extension?

works perfectly, thanks Paul

Which form? That makes sense if you mean they change or enter a value in the subform but don't complete it before activating the main form. Lots of...

This is awesome! This is extremely helpful. I've started writing facts down like this for other information we'll need when I get to making reports...

ranman256 -- so, are you suggesting to replace the BeforeUpdate with the IsValidForm() function? If yes, where do I place IsValidForm? Also, is...

your comments and seem at odds with each other - are you expecting a user to scroll through a thnumbnal?

Ajax, this is strictly for viewing the content as they scroll through it. The flicker would unfortunately be undesirable. Micron: The form...

One way If Month(Forms!!) = Month(Date()) and Year(Forms!!) = Year(Date())

Thank you. Will amend and see how it works.

The before update event is very commonly used for validation. It can be cancelled, where the after update event can't. You also can't examine the...

If that's directed at me, either get rid of the spaces in your object names (preferable) or put square brackets around any table/query/field name...

Hi You have the same problem between tblErrorIncident and tblIncidentStatus Unable to enforce Referential Integrity Also your...