Search results

I have been using this code for adding new records from another form. Anyway to adapt the syntax to EDIT a Record based on a specific field (WorkerID)? - Private Sub Form_AfterUpdate() Dim db As DAO.Database Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT * FROM ClientNotes")...

Yea. Believe me, I thought that for a long time. What happens is that sometimes we have Employees (Workers) who are NOT assigned to ANY Clients BUT we have other reports/queries in which having that Employee (Worker) appear is important. My solution to this was to add a Supervisor Field to...

Both Client and Employee Tables have a Supervisor field. Relationships between clients and employees is dictated by the Client form/table. CLient is assigned a Supervisor and subsequently the Employee is then associated to the Supervisor based on the Client assigned. We assign workers...

Yes, CLIENTS have a ClientID field. I included the relevant fields but CLIENTS and EMPLOYEES are separate tables that both have their own FORMS. As i mentioned, they are Joined by EmployeeID and WorkerID.

Hello all, I have been trying to find a way to update a specific record on one table when there is a change on one of my forms. The form I have is a Client Form that has combo boxes for the worker(s) assigned. after update causes the worker ID to be updated, I would like to include in this...

The fileds in question were set to Plain Text and have now changed them to Rich Text but despite this the cmdSpelling option is not available for the field. Any help would be greatly appreciated.

Now I created a NEW query with the same exact info from the tblAuditTrail and am opening that with the onclick event of the Switchboard button. The issue is not coming up again. it seems that the new query is the best route. Interesting situation. I couldnt understand why that was happening...

I think i resolved the issue: I just changed the onclick event to open the table in read-only mode. This seems to have stopped the issue. I dont need to open the information as a query or a form, I was just trying to lock it down so no one could edit in the information if they clicked that...

Would you need the front-end and back or just the front?

The back-end alone is more than 500mb and the front end is about 150mb. Not sure if this would impact anything but my front-end is .accdb and my back-end is .mdb - I did this recently to use updated features on the front-end but maintain the user-security. A little more on our set up: Runs off...

qryAuditTrail SELECT tblAuditTrail.DateTime, tblAuditTrail.UserName, tblAuditTrail.Action, tblAuditTrail.FormName, tblAuditTrail.FieldName, tblAuditTrail.OldValue, tblAuditTrail.NewValue, tblAuditTrail.RecordID, tblAuditTrail.AuditTrailID FROM tblAuditTrail ORDER BY tblAuditTrail.DateTime DESC;

Any thoughts about the error or anything i may be missing?

Yes. I can edit it directly through the linked table.

Understood. I used the AuditTrailID, Im assuming that would be the field name needed for that part of the statement. Run-Time error '-2147217911(80040e09)': Cannot.update Object Its erroring on the following line (in red): Case Else With rst .AddNew...

in the "WHERE" statement what field name are we looking for here? I just tried the AuditTrailID as the KeyFieldName and no such luck, I still get a read only error when I save.

I should also mention that the code is built into the front-end of the my database but I have the table on the back-end. Should the module and/or the form/query be on the back-end as well?

Im not 100% on that. How would i go about checking if it is open with optimistic lock?

Hello All, I have a module that is called in the BeforeUpdate event of most of my forms (See code below) There is a button that will open a query with the table information so i can see the log entries. I've noticed that when I have this query open it will cause a read-only error when there...

I understand that. I have a button that locks/unlocks the form. Essentially what happens is the form loads, locked, the user unlocks to edit (including the subform) and theyre good to go. Despite being unlocked and the subform allowing for edits I am unable to get the code to work. It just...

Hello All, Back again with a new problem I hope you can help me with: I have a Form that has onload event LockBoundControls with a subform for notes. I am trying to add spell check feature to the notes field in the subform, which is a memo field, but I keep getting the error message...