Search results

Gemma-the-huskey: I just wanted to compare the 2010 data vs 2011 data in a pivot chart. x axes being the weeks from 1-52, so I assumed the table should be in order :S I grouped by date and by weeks (making date unchecked) - the result is displayed like week 1 2010 week 1 2010 week 2 2010...

I thought so that too, but using =Cint(format([dte], "ww yyyy", 7, 1)) gives an error "data type mismatch in criteria expression"

Hi bob, thanks for helping me out here as well. I did that but the sorting doesn't change. I still see the entries as follows: 1 2011 102010 112010.. how can I fix that? Also, I want to make a pivot chart comparing 2011's week numbers to 2010 week numbers. thanks again bob!

=format([dte], "ww yyyy", 7, 1) query displays the weeks and the year - but they are not displayed in an ascending order. When I try to sort them, there is no option of "smallest to largest", rather "Sort A to Z" appears :S. data appears like this: Week 1 10 11 12 .. 19 2 21 thanks!

thanks for the reply guys. I do not have hex editor and I cannot download it (need Administrative permissions) - basically, this is the story: I have a front end and a back end. Everynow and then I would make changes to the front end, but then I would have to go to every employee's...

Hi bob, You are right. I can open the files wit notepad. I change the directory folder (wanted to open a different .ini file), but my .exe file still refers to the old one :S

Hi guys, I want to edit a .bas file, but I don't have VB6 or any visual basic editor. I read it somewhere that I could import it to notebad etc but I cannot change the code. I just have to make a slight modification by putting a different path of the database. - any suggestions??

oh yay! fixed that part - I will post further questions so I dig down into these reports further - have a good weekend :)

SELECT tblAfternoon.Week, Max(tblAfternoon.[Caseflow Shelving Available]) AS [MaxOfCaseflow Shelving Available], Sum(tblAfternoon.[Caseflow Shelving Actioned]) AS [SumOfCaseflow Shelving Actioned], Max(tblAfternoon.[High Cube Available]) AS [MaxOfHigh Cube Available], Sum(tblAfternoon.[High Cube...

Hi, I have a table which has list of activities that a user has done over the years. The following fields exist in the table: ID dte Week# EmployeeID Activity1 .. .. ..Activity10 how would i use develop a query that would give me the sum of records for Week 10 (for example) and sum of...

Phew! these small things sometimes. thank you for being so patient :)

Runtime Error '3075' Syntax Error (Missing operator) in query expression 'Sum(Email SPP Actioned)'

It still gives an error :S If Nz(DSum("Email SPP Actioned", "Copy of tblActivities", "dte=Date()"), 0)) = 0 Then

Private Sub Form_Load() If Nz(DSum("Email SPP Actioned", "Copy of tblActivities", "dte=Date()"), 0) = 0 Then MsgBox ("SPPs have NOT been Actioned today!") End If End Sub this gives an error saying "missing bracket"

I have uploaded a stripped version. Thank you for your time. basically, I want an alert system which pops up when the user opens the application. It will tell them whether records have been added today or not - If added, what are the values - and the last time a report was actioned. Any...

Hi - that displays the msgbox even if the sum is not 0 :S

I used If Me.text2 = "" Then MsgBox "No records have been added" End If but that displays the Msgbox everytime (no matter values are in the text box or not) :S

Hi, I have a text box which shows the sum of numbers for today - the text box is located in a form which is based on a query. I want a pop up message to appear if the sum of records is zero (meaning no entries were added). My code works for a simple (empty) text box, but doesn't work if I...

Hi, I have this access application which is ready to go and will be used by multiple users sharing a common server - Right now I have the backend and the front end on the common drive. I copy the front end from the common drive to every user's trusted location and create a shortcut on their...

Yeah I do - Here is the code: Private Sub Combo109_AfterUpdate() Dim rs As Object Dim dteDate As Date Set rs = Me.Recordset.Clone rs.FindFirst "[ActivitiesID] = " & Nz(Me.Combo109.Column(1), 0) If rs.NoMatch Then dteDate = Me.Combo109 DoCmd.GoToRecord , ...