Search results

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...

May I ask what the significance of the aposterphe and quotations marks are? I am referring to the aposterphe and quotation marks around the fOSUsername() function. The code seems to be working great now...! Thank you very much for your help :)

@vbaInet DLookUp("FieldName","TableName","CurrentUser()") or DLookUp("FieldName","TableName","fOSUsername()") where fOSUsername() is a function defined in a module that retrieves the user's Windows NT User ID

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 understand where you are coming from; however I really have no experience with SQL Server. One of the great things about Access is that it lets you rapidly develop small and simple applications; however that simplicity is what I am trying to overcome right now. I have, via XML, been able to...

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?

Thank you very much for your reply; however I really did not understand your reply. I have attached the file that I have been working on. Can you please help me with this attached file?

The code being used right now is as follows: Private Sub SendFeedbackForm_Click() On Error GoTo Err_SendFeedbackForm_Click Dim stDocName As String stDocName = "Feedback Form (Report)" DoCmd.SendObject acSendReport, stDocName, acFormatPDF Exit_SendFeedbackForm_Click: Exit Sub...

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...

Okay great, that works like a charm! Thank you.

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...

I have already split the database into Frontend and Backend. I was definately looking to have more than 10 to 25 concurrent users. Where did the 255 figure come from? Is that something Microsoft says Access can do?

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

Thank you very much jzwp22. You have been a great help! :)

jzwp22, thank you for the detailed reply. I have actually spent the past couple of days trying to do what you suggested; however I fail to see how that will allow me to accomplish what I am aiming to accomplish. I am sure there is something that I missed or I simply do not understand how to do...

Thank you very much for the warm welcome and replying. I have went through the attached link and I think I need to provide more details as to what I am actually doing. I have created this template (the template is attached) that will help you better understand what I am trying to do. The...

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...