Search results

The Clients prefer Sharepoint so that is what I am having to use as the "container" of the data. That is the reason that I want my own unique field for linking tables.

All tables in this huge database is linked on a number field that is unique. This is a structure that was established way before my time so I don't really want to change in mid stream, even though I know the recommendations to do otherwise are correct. To that end, is there code that will do...

Thanks plog and I'm sure you are probably right, but it seems like the IDs that Sharepoint assigns each record are not easily manipulated. At least with my knowledge level, I would not be comfortable with such a migration. The ID_Activity =ID is basically making the OldID as you suggested, but...

In our case it was Sharepoint. We moved all lists from one Sharepoint account to another Sharepoint account. It created all new primary key IDs for each record and none of them matched their previous relationship.

All of my tables are linked by a field that is not the primary key ID. The reason for this is because in the past when we relied totally on the primary key ID for all linking, when we once had to migrate from one server to another, new autonumber ID's were set by the server. This messed up all...

I have a Main Form CAD_CallEntrySplitF which is bound to table ActivityT (which has ID as its primary key). There is another field in the same table called [ID_Activity]. I cannot rely just on the ID alone; I need the ID_Activity number archival purposes and related tables. I put If IsNull...

Great video Pat and Tony. I will now be using BeforeUpdate the proper way.

Thank you again Pat....You answer my questions pretty plainly so I can understand being a newbie to vba. I will watch the video and mark this thread solved.

Thank you Pat. That seemed to work. I will close this thread out now. Again, thanks.

Tabbing through all the fields to the first field in a new record, I would think it would fire the After Update event since I did change the fields from nothing to having data in them. Am I thinking wrong. Thanks. Mark

gemma-the-husky Thank you for the response. When I tab all the way through my form and land on the first field in a new record, the record that I just left has all the data I entered minus the value that I needed in the Employee field from the LocalUserT.EmployeeID.

Run-time error '-2147352567 (80020009)': The data has been changed.

It errors on Private Sub NowAndSaveB_Click, more specifically the DoCmd.GoToRecord , , acNewRec

I hope I understand your question. The LocalUserT.EmployeeID is already set. It is left alone. I have just entered a record in the subform CAD_Log_DispF by tabbing all through the controls. My thought was that after I exited out of that record by tabbing, that it would invoke the Private...

On Form called CAD_CallEntrySplitF I have a button named NowAndSaveB which has an Event On Click. I have two other buttons on the same form that have an Event On Click. They all work fine until I put an After Update event on the form itself. The code for the After Update event on the form is...

I am designing a db to be used for dispatch purposes. There is a parent form CAD_DallDispSplitF linked to its subform CAD_Log_DispF via ID_Activity. Works fine. The subform CAD_Log_DispF, shown below, gets it data from CADLogT (linked to Sharepoint). I have table name LocalUserT which...

Thank you for the quick response. I was thinking that the date/time without any formatting might be okay since it would be highly unlikely that one of only two employees on duty at a time would update a record at the very same second. I will do some reading on how to make a composite PK...

I am very green at VBA and designing Macros so hopefully this can be done without either.... but if not, I can certainly give it a try. I have created database in Access 2013 that is intended to be used to record the employee's activity for the shift. Each employee has their own laptop and on...