Search results

I would like to move up to front-end web development. I have 25 years of experience with Access. I am not giving up on Access and will continue to use it. Maybe some of you can point me in the right direction. What should I learn to make the transition from Access to the web? The web is full of...

Here is what happened. After the upgrade I contacted IT to see if they had encountered the problem before. They had not. After listening to how they are getting rid of Access (not true), I needed to move on quickly, so I asked him to restore it back to 2013. I later posted the question in a...

Thank you.

It is a Software Center with a list of the programs available to your license. He selected Office 365 2016 and installed it.

He just installed the new one over the old one.

Nothing happened when I did anything. I have several Autokeys functions that would not activate. No buttons would respond to clicks. I mean it was dead. Thank you.

That would be great. I support quite a few people here and they are trying to isolate Access and get rid of it. I don't want to give them an excuse. So, thank you very much.

I just had a post that seemed to stop. I found a solution but have a question that wasn't answered. I upgraded from Office 365 2013 to Office 365 2016 and Access would not function. The Autoexec macro would open my programs but no other function would work after that, i.e., button clicks...

I never checked that. Do the Trust settings go away if you upgrade?

The database opens to the correct form. None of the buttons work. The code is there and everything seems to be in order. I checked the references and nothing is missing or broken.

The IT Department upgraded my computer from Office 365 2013 to 2016. Now, nothing in my Access program works. Does anybody know what is happening?

Thanks for your help.

I can't seem to get the following to work. Can anyone help? DoCmd.RunSQL "UPDATE tblLogins INNER JOIN tblLogin ON tblLogins.UserID = tblLogin.UserID" _ & "SET tblLogins.UserPasswordChanged = 'Y', tblLogins.FirstLoginDate = Date(), tblLogins.FirstLoginTime = Time()" _ & "WHERE...

That worked. Thanks very much.

Can anyone tell me why this doesn't work? DoCmd.RunSQL ("INSERT INTO tblLog ( UserID, LoginDate, LoginTime, DB") _ & "SELECT tblLogin.UserID, tblLogin.LoginDate, tblLogin.LoginTime, 'SOL' AS 'DB'" _ & "FROM tblLogin" Thank you.

It is not read-only in the properties. I copied it from one folder to another. I disabled the shortcut menus and it got rid of the right click option. Thanks.

I copied a database and am making changes to several things within the copied DB. One of the things I am doing is removing the right click option. I am using the following code: START OF CODE Public Function doRightClick() Dim obj As Object Dim frm As Form For Each obj In...

I am not very good at reading some code. I inherited a database and found the following code in a module named modSKDisEn and need someone to tell me what it does. START OF CODE Public Function SetProperties(strPropName As String, _ varPropType As Variant, varPropValue As Variant) As Integer On...

I have created several Access databases on a shared drive. Here is the way I currently have it set up. Folder 1 - Shared folder on the network Contains four back-end databases DB1 – data for Program1 DB2 – data for Program2 DB3 – data for Program3 DB4 – holds deleted data for reports...

Let me clarify what I need. The user will send these records over to the other DB to be used later that day or sometime on the succeeding days. I am not trying to transfer the CustID. I am using it to isolate the corresponding files. When the record(s) is transferred, the Windows Explorer...