Search results

I have written the following query and it is taking too long to respond: SELECT DISTINCT (AssignedTo) AS EmployeeName, Workdays(Forms![frmDashboardReports]!txtStartDateAndTime,Forms![frmDashboardReports]!txtEndDateAndTime) AS ScheduledWorkdays...

Thank you very much CJ_London! :)

I am guessing with 43 views and no responses I have either asked an extremely simple question or an incredibly complicated one.

I need to add a column to a crosstab query that counts all of the occurrences of "P" in a particular row in the crosstab query. Basically "P" stands for "Present" and I need to know how many days each employee was present for his/her shift. The SQL for the crosstab query is as follows...

Odd indeed! :)

I am not a big fan of delimiters however here is the solution: DCount("EmployeeName", "tblAttendance", "[AttendanceDate] = #" & Format(txtAttendanceDate.Value, "mm/dd/yyyy") & "# And [EmployeeName] = '" & cboEmployeeName.Value & "'") pbaldy was right about the double quotes; however I had to...

Hi Paul, Thank you for the prompt response. For some reason your suggestion didn't work. I tried removed the double quotes before the "And" first and I got an error (i.e. Error 1 screenshot attached for your easy reference) and then I removed the double quotes after the "And" and I got the...

I can't get the following DCOUNT working for the life of me: DCount("EmployeeName", "tblAttendance", "EmployeeName = '" & cboEmployeeName.Value & "'" And "AttendanceDate = #" & txtAttendanceDate.Value & "#") I have checked this forum along with Google and there seems to be no easy way to do...

Thank you Paul and Mile-O. I guess sometimes you just have to take a step back and see everything because this was fairly basic and I just completely missed it.

Hi Paul, Here is the I am using: Dim ActualManHourstblTasks As Double Dim ActualManHourstblTaskHistory As Double Dim ActualManHoursCalculatedString As Double Dim ActualManHoursCalculatedDouble As Double If Me.OpenArgs = "Edit" Then ActualManHoursCalculatedString =...

I have been trying for the better part of the past hour trying to convert string into double number format. I am running a SQL query in VBA that returns a double number format; however my understanding with SQL queries in VBA is that they return string only. The results are showing up...

I am currently using a front-end and back-end of Microsoft Access 2007 in a multiuser environment. I have approximately 30 users and I make extensive use of the Now() function which returns the current system time. Unfortunately I have noticed that some users have access to change their system...

Hi Paul, Thank you for the quick response. That worked beautifully! :) Regards, Zohair Yousafi

I have one form that is currently being used for two different purposes. The first purpose is basic data entry of a new record whilst the second purpose is to edit and update a specific record. The end-user, for each specific purpose, arrives at the form from a specific route. For example I...

I wasn't able to resolve this in the true meaning of the word; however I worked around this. I created a bound form to one of the two tables and then ran this code and it worked like a charm. I didn't want to have a form bound on a particular table; however I guess I will have to live with it :)

Hi Mihail, Thank you for the response; however please note that it wasn't a syntax error. The issue was that I had set the DataEntry property of the form I was opening up to "Yes" and that didn't allow the form to open up the record I wanted to edit. I changed the property to "No" and it...

Hi JHB, I think I have figured it out. The syntax is correct; however the form I was opening had the "DataEntry" property set to "Yes". I changed it to "No" and it is working as expected now. Thank you for your help. Regards, Zohair Yousafi

Hi JHB, The value of "Me.tblBasicEmployeeInformationID.Value" is a numeric value (i.e. 23, 47, 34, etc.,) whereas this value can be obtained by either including the ".value" at the end or by removing the ".value" altogether. I presume you are referring to the recordsource of the form I am...

No relationships for this particular table; however here is a screenshot of all of the fields in the "Design View" of this table.

I have searched this forum to make sure my syntax was correct before posting; however despite, in my opinion, having correct syntax I am unable to open a form based on a specific record. I have a form called "frmBasicEmployeeInformation". I have another form, the form is called...