Recent content by Rob892

I know I have seen posts about this before, but I cannot seem to find them. My problem is that I have a report that reports data on a weekly and monthly basis, but our workweek starts on monday, and ends on sunday. Is there a simple way to get the report to format this way?

Sorry that it took me so long to revisit this issue! The problem was an older version of ADO on my home machine. Once I updated, I was able to recreate the problem, and I worked out a quick work around. Many, mnay thanks for pointing me in the right direction! Rob

I was afraid that the solution would look like this. I was hoping that it was possible to have Access gererate a report for a year, by quarter based on a date other that the first of the year. In any event, this problem has become a bit more interesting. What I am attempting to track are...

Here is what I need to do: Each employee in my department has a different hire date. I need to creata a report that shows any records for an employee by quarter, based upon their hire date. For example, An employee was hired on 09/01/01, I need a report that shows record from 09/01/01 to present...

Both DB's are exactly the same, except that the one at home uses Access2000. Here is the information : Dim rstBusGroupIn As ADODB.Recordset Set rstBusGroupIn = New ADODB.Recordset rstBusGroupIn.ActiveConnection = CurrentProject.Connection rstBusGroupIn.CursorType = adOpenKeyset...

Excellent replies from all! I think I am starting to get a feel for the concerns that our MIS department will have when I ask for the shared folder for this app. I have the DB split into a backend, of course, which will be stored in the shared folder. I have done as much as possible to reduce...

Many thanks..now I have an idea of what I need to ask them to do for me!

I recently had to deal with a similiar situation. I used the split function to split the string I.E. Dim words() As String words() = Split(strInput, Chr(32)) This will assign elements of strInput to the words array, the elements of the array will be split by the space character(Chr(32). A little...

I have developed an Access database to help the managers in my department work with some of their day to day tasks such as Employee scheduling and storing Employee records. They have found the DB to be quite helpful, but they need to access the DB from three computers in the department. My next...

Any ideas on why the following filter for a recordset woks on my home computer using Access2000 but not on my work computer using Access2002? rstBusGroupIn.Filter = "[ArrDay] = " & "'" & ArrOrder(i) & "'" & " And [AssignThisArrival] = 1 And [BellmanArrival] =...