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

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

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

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

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

I have a form that has a SQL query with a JOIN of two tables as the recordsource. I have one unbound field, a dropdown, on the form and one bound field, a text box, and both of these fields have to do with the TaskID. The JOIN of two tables is as per the TaskID. Now if I pass a "TaskID" to...

I have been at this a couple of hours and I just can't seem to make any headway. I need to count records based on multiple criteria from two different tables. I have two tables (i.e. "tblTasks" and "tblTaskHistory"). The tables have a one-to-many relationship based on the "TaskID" field...

A subform on a main form is not populating after the user clicks on the subform and then returns to the main form and updates the field which the subform is linked to. The first time the subform populates absolutely okay; however once the user clicks on the subform and then returns to the...

I have tried using all of the help guides provided by Microsoft and several other guides I found online; however conditional formatting is simply not working. I have two fields on a report, the report is based on a query, and the two fields are called "ExpectedCost" and "ActualCost". I want...

I keep getting an error with the following query: SELECT DISTINCT (AssignedTo) AS Expr1, (SELECT COUNT(DISTINCT (AssignedTo)) FROM tblTasks) AS Expr2 FROM tblTasks; The error is "Undefined Function 'DISTINCT' in Expression". What am I doing wrong? The "References" are okay because the...

I have a Main Form which is essentially the based on my child table called tblTaskHistory. The Main Form has a subForm which is based on the parent table called tblTasks. I am using SQL queries to feed the combo box recordsource that is located on the Main Form. The After Update for the combo...

I have spent the better part of this past week developing an application for my staff; however I did so on my laptop and my laptop is currently running a 64-bit version of Microsoft Access. My staff currently has a 32-bit version of Microsoft Access on their computers - what can I do? I have...

I have a table called "tblTasks" and the table allows users to attach files to a task they wish to assign to a resource in their respective department. I have based a query on this table that returns the tasks associated with a given resource; however when the resource tries to view the...

I have been stuck on this for the past couple of days and it seems I am getting absolutely nowhere. I am having an extremely difficult time calculating values which seem, for the most part, very straight forward. I have done quite a bit of debugging and I have been able to isolate the issue to...

I am trying to update values in an unbound text box based on a selection in the combo box on the same form; however whilst I am easily able to display the information for the first selection the values do not update when I change the value in the drop down. What is going on here!? :eek:

Calling on all Access gurus! I have been absolutely unable to figure this out and after 3 hours of "Googling" it seems what I am requesting is simply not out there - at least I have been unable to find anything similar. I want to be able to display the result of a difference between Date/Time...

I have been using Access for quite some time now and I am able to usually work around many of the issues that come with being a small timer, like me, taking his best shot at Access; however one issue I have had absolutely no luck with is auditing a new and/or change made to an "Attachment...

I am using the following code from the Fontstuff website to keep an audit trail in my application. I have been able to substitute the field names with my field names and the audit trail for new records is being maintained; however the audit trail for records I "edit" are not being maintained...