Recent content by Emily

Can you uninstall the Access app from Office 365? I thought you cannot do that with Office 365? or is there?

oh my source is in a different drive which the users have no access to it. I have to manually move the compiled version to the user's drive, so there is no way the user will have access to the accde. thanks

Thank you everyone who have replied to my post. I learn a lot from you all. You are all my lifesaver ! thanks!

Thank You Pat! I just tried renaming from accde to accdr. It works !! thank very much!

My DB is properly split into FE and BE. I normally compile the App into ACCDE when deploying new version. However with Office 365, users will get full version of Access, meaning they can click on the left pane and open tables to change data. How can I prevent that?

Hi, I am currently running Access 2010 on Win10. Users are using Access runtime 2010 to open the App because they don't have ms Access on their pc. We are planning to switch from Win 10 to Office 365. My questions are 1. Can Access 2010 runs on Office 365 without problems 2. Office 365...

Oh yes BOB!! YOU DID HELP ME A LOT!! I was running around and couldn't figure out what was the problem. Knowing the cause, is problem half solved. If it wasn't for you, I wounldn't be able to come up with a work around solution and I probably be still looking at my syntax. Thank you again!

Thanks Bob, Finally decided to go for a work around solution to change my query to based on one single table instead. Now the audit trail works fine. Thank you so much for your help.

Hi I am getting the same error ! How did you change your query to work? I did a Msgbox in the OnCurrent event, the rs value showed up ok. Just that in the before update, it didn't like passing the recordset to the function. Do you think I can get around by using global variables, by setting...

Hi Bob, I added the Dim rs as recordset in the Form declare section and added set rs = me.recordsetClone and rs.bookmark = me.bookmark on the form OnCurrent event. On the form Before Update event, I tried to pass rs to the AuditTrail function by Call Audit_Trail(Me, "id", Id.Value, rs)...

Thanks Bob, I will give that a try. Do I just declare the Dim rs as Recordset in the Form and set rs = Me.RecordsetClone in the OnCurrent event in the Form as well? Then how do I get the oldvalue to the AuditTrail function to do the compare? Do I have to modify the AuditTrail function?

Hi, I am very new to VB and I am using Access 2010. I've copied the code from this forum on AuditTrail. I followed all the steps, imported the tblAudit and the two modules. However when I run it, i keep on getting 3251-Operation not supported for this type of object. Somehow it doesn't...

Thank you guys for referring those useful sites!!! I am so excited and looking forward to really learn some VB. This forum has really help me so much and I just want to thank all the people who posted in this forum. It is amazing how much one can learn by just reading these post !!! thanks...

Thank you both, I expanded the insert statement and played around with the syntax on the literals and comma and finally got it working. Thank you so much!!! I always have problem not knowing when to use a single quote ' or double " and when to use ampersand &. Do you know of any good site to...

Thanks for your quick response. I needed to write the same record in Timelog onto the History table. If I don't use the select statement format, how do I assign the values of the timelog table to History in the format you suggested? would it be something like INSERT INTO table_name...