Search results

When I press F8, nothing happens. If I try and run the sub, following window appears, asking to save macros:

I do that if I have to use VBA for Excel but in Access, it asks you to save macro before you can run through the code line by line. Or am I being very daft here?

It sure is! Its amazing even in this day and age there are people helping other strangers and expecting absolutely nothing in return. Makes you feel a lot more upbeat in the midst of chaos around us all.

Awesome. Sorted. Thank you :)

Can you please guide me where I have to put Exit sub line?

Hi I have the following code in one of my forms: Private Sub CloseBtn_Click() On Error GoTo Errhandler If Not Me.Dirty Then DoCmd.RunCommand acCmdClose Else Select Case MsgBox("Do you want to save changes before closing the form?", vbYesNoCancel + vbCritical +...

this is very helpful! thanks!

Yep, I got the message loud and clear about the db bloating :D thanks to you, and everybody else for your time and input :)

After reading your comment, I had actually decided to store the link to the server folder. I have removed the "Attachment" field completely from the db. Thanks, as always, for your input Pat :)

Makes sense. Thank you CJ, this gives me another option to work with. Much appreciated.

Apologies, I completely missed your comment, Pat. Stupid question; can I store documents as OLE in another table as well, just as images? And would I link each document to an employee by introducing EmployeeT PK into this new table as FK?

Would you be kind enough to guide me how I can implement that into the following code? Private Sub Form_BeforeUpdate(Cancel As Integer) DoCmd.RunSQL "INSERT INTO ChangeEmployeeT SELECT * FROM EmployeeT " & _ "WHERE EmployeeID =" & EmployeeID End Sub

As for audit trail attempts, I have tried Scott Gem's method re data macros, and also one advised by Richard Rost which is using before update event to copy data being changed to a separate table using INSERT INTO commands in vba. Neither works for MVF :(

Thank you for both for your responses. I have gone through the (https://learn.microsoft.com/en-us/office/vba/access/Concepts/Data-Access-Objects/work-with-attachments-in-dao) and it looks like a good solution. My only question is if it will work for different people on different machines? I'm...

Hi all I have tried to search for a possible solution to this with no luck so far. I need to attach documents to people's records in the database. With a standard MVF, you can use an inner join between two tables to make it work for you but what can we do with attachments? I am having issues...

Much appreciated, Pat. Will bookmark this thread for future reference. I specially like the idea about the Quotes. It drives me crazy sometimes!

Thank you, both. You are right. However, at this point I am not sure myself what I was doing wrong. I was trying to use following two ways: Method #2 here http://allenbrowne.com/casu-08.html Using docmd.openreport and passing date requirements With the first option, the code was reading the...

Hi I have spent half a day looking at various solutions with no luck. I have a report based off a query which shows expired training courses for each employee. Everything works fine until I try to filter the report with date ranges. Mainly, I have tried working with the following 2 ways...

Exactly what I needed!!! Much obliged, arnelgp!

Thanks for your response. Query1 does not take into account a role assigned to more than one employees, which in this case is PositionID 48 assigned to EmployeeIDs 17 and 14.