Search results

I rely heavily on Microsoft Access in my office environment and there are multiple applications that have multiple concurrent users. End-users always seem to find a way to use an application in a way other than actually specified. Attrition here is high so people keep changing and simply...

I want to create a command button that will "print" the current worksheet (i.e. an evaluation form) an evaluator is working on as a PDF and attach that PDF (i.e. the evaluation form) to an e-mail that will be sent to the person he/she is evaluating. The command button should also pick the name...

I was successfully using a front end and back end setup for the past two years. Today I needed to push through some changes and "deactivate" the previous back end database and setup a new back end database. The new back end database has been sent; however the front end is not recognizing the...

The following code, in red text, is giving me the attached error: Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long Set cn = CurrentProject.Connection ' The user roster is exposed as a provider-specific schema...

I have been trying for the past several hours to get this work but for some reason I am not getting the same options that are shown on Microsoft Office's website (i.e. the tutorial) on multivalued fields. Supposedly, as per Microsoft, there is an option when you select "Lookup Column" in...

I am having some trouble with the DLookUp formula. It seems to be entered correctly; however I want to use either the CurrentUser() function or the WindowsNTUserID as my criteria (i.e. the third (3rd) part of the DLookUp formula. Can someone please help me here? Is this even possible?

I am making an Attendance Management System (AMS) and I need to distribute the "front-end" of the application to several employees. One major concern I have is the security that I can or cannot place in the "front-end" file. Is there anyway to disable Design View, the right-click menu, and the...

I want to update two fields at the same time. The user will enter data into a particular field and I want that entry replicated into the other field automatically. The entry will be text. Please help. I have tried using the "Default Value" property; however I have had no luck.

I want to use Access 2007 to enter data directly in Excel 2007. This feature was available earlier with Access Links in the earlier versions of Microsoft Office; however I have not been able to find it in Microsoft Office 2007. Can you please help me with this?

I want to be able to send an e-mail automatically with an attachment with the press of a button. When the user presses the button, the application would search the e-mail address in the system based the name of the agent who was being evaluated, attach the report in PDF format, and then send...

I have a form which is basically used as an Evaluation Form of a Contact Center Agent. The form and the calculations work absolutely fine; however I want to add something that will make this form great. What I had in mind was having a subform within this form that would ultimately display the...

How many people can use Microsoft Access in a multiuser environment at any given time (i.e. the maximum number of concurrent users)?

I am creating a Database in Access for a Contact Center. A big part of Contact Centers is Quality Control Evaluations. I am having some trouble creating a form where the evaluation would take place and as it is taking place maintain a field that would automatically calculate the score and then...