Search results

Did you add the code to the "On Current event of the form like in the example you posted?

WARNING: This was cross posted here: http://www.accessforums.net/showthread.php?t=66449

Here is another great Access calendar with some other cool code. Proximity Functions

I might. Is this a database for a Human Resources (HR) Department to track resumes for people applying for jobs?

Frist, is the database split with each using having a copy of the front end on their local hard drive? Second, did you convert the front end and back end mdb's to the new accdb format?

I do the same and similar things now in my Accounting systems. There as tow way=s I do it. 1) Use an append query. Great for copying records. 2) Use a recordset. Great for duplicating a record(s) and the related child records. For your example, the way I do it is with a popup form. This...

Paul, Not sure what yu mean by "Azure on the cloud". Azure is a platform with that provides many solutions. My guess is that you want to upsize your back end to an SQL Server hosted on Azure. That wat you can link your Access front end to the SQL Server "in the cloud". Is that what you...

I would recommend using the Form's On Current event and VBA code to enable/disable the buttons and controls as needed. Private Sub Form_Current() If Me.NewRecord = True Then ' new record allow edit Me.TaskDetails.Locked = False Else ' existing record disable edits...

With a ACE/JET back end, the persistent connection keeps the locking database (.ldb/.laccdb) alive (created). It saves on the (small) overhead of creating this file when needed. Curious, what is the benefit of a persistent connection to a SQL Server.

According to the SQL Server DBA gurus I know, they say is totally normally. Not just with Access. AFAIK, I would not worry about the number of connections.

Here is what you agreed to when you install it: "keep the status bar containing the statement "Powered by Microsoft Office Access" displayed in your user interface to be viewed by users at all times;"

I use Crosstab reports a lot. I have an example that I use all the time as a template. See: Dynamic Report based on a Crosstab query

Thanks for the update. Good luck ...

Cross posted HERE

You're welcome. Let us know how it goes with the data macros.

It is very difficult to help you with just general names like tbaleX, fieldY, and valueZ. We really need to see some same data and know what it represents.

Thanks for paying it forward by sharing your solution. Great Job!

Access has added a data macros to the AACE/ACCDB format. I have not tried them but it might do what you want at the table level. See: https://msdn.microsoft.com/en-us/library/office/ff973807(v=office.14).aspx

I think you are wanting to hide the Access Application Window any use only POP-up for. I have been down the rabbit hole. Acess 2007 and after really do not play well when you hide the Application Windows. Things like report preview will not work. IMHO, you should avoid trying to hide the...

Referential Integrity (RI) is enforced by the ACE/JET (the Access database engine). There is NO way to get around it. Add or updating records must follow the RI rules that have been defined. It does not make how yu are adding or changing the records. RI will be enforced is defined. A SELECT...