Search results

  1. S

    A better date picker

    Million thanks! Should be a sticky so as to be easier to reach :D
  2. S

    A better date picker

    Absolutely meets the requirements I had in mind. Can that other topic be sticky'd or somehow made to stand out? (This topic is resolved and can be closed, AFA i'm concerned )
  3. S

    A better date picker

    Unsure of where this should be, I generalize (Mods, feel free to transfer if you feel the need to) How would any of you go about replicating a windows-style date-picker to MS Access? I know the integrated date-picker works pretty fine, but what if I had in mind to build a date-picker where you...
  4. S

    Calculation

    Write queries directly without any support-wheels, therefore making sure you can only have less-than-enough brackets :D
  5. S

    Calculation

    :banghead: What he said :D This is the beginning and the end of your problem and it states the priority of operation in mathematics, and OF COURSE, programming All of us at one time or another make mistakes and stumble somewhere, but most commonly it's either "BEDMAS" or missing syntax...
  6. S

    SUMIF or Sum(IF(( neither working

    IIF isn't a thing in Excel, as untill recently, I had worked with the same version of Excel as the poster My suggestion, if you want to expand upon this and learn for future reference, use the formula builder popup, because it will show you errors immediately before finishing up the formula...
  7. S

    SQL to VBA and back again

    Simply awesome! If I only had this earlier, it would've made my life so much easier! Thanks a bunch for this!!!
  8. S

    The reason I decided to meet you all

    Dim rs As DAO.Recordset Dim qry, points, pp As String Dim pts As Integer pp = Me.Form.cbo_query_picker.Value Set rs = CurrentDb.OpenRecordset("SELECT DateDiff('n',IIf([Arrival Date]<=(SELECT Start_Date FROM Events WHERE Descriptive_Name='" & pp & "'),(SELECT Start_Date FROM Events WHERE...
  9. S

    The reason I decided to meet you all

    Project update: This is the VBA I came up with after nearly two days of :banghead: Dim rs As DAO.Recordset Dim qry, points, pp As String Dim pts As Integer pp = Me.Form.cbo_query_picker.Value Set rs = CurrentDb.OpenRecordset("SELECT DateDiff('n',IIf([Arrival Date]<=(SELECT Start_Date FROM...
  10. S

    The reason I decided to meet you all

    How would that change anything, and how would I put that together in syntax? [FONT=Palatino Linotype]I meant, suggestions for other work-arounds for that minute interval, instead of in a query? This system will contain multitude of Events, and up to 100 different participants for each event...
  11. S

    The reason I decided to meet you all

    How do I get to do this then??
  12. S

    The reason I decided to meet you all

    SELECT DateDiff ("n", IIF([Arrival Date]<=(SELECT Start_Date FROM Events WHERE Descriptive_Name='First_recording'),(SELECT Start_Date FROM Events WHERE Descriptive_Name='First_recording'),[Arrival Date]), IIF([Quitting Date]>=(SELECT End_Date FROM Events WHERE...
  13. S

    The reason I decided to meet you all

    The minute interval is a requirement and i fixed that part already... UPDATE Customer INNER JOIN tmp ON Customer.Customer_name= tmp.Participant SET DBZ=DBZ+tmp.Pts why does this produce an error about non updateable queries in access??? tmp is a name for saved query that produced datediff and...
  14. S

    The reason I decided to meet you all

    Thanks for observing that I copy-pasted this problem from somewhere else, when in truth, I simply like how everyone nearly forgot about Palatino font. No, I wrote this post with my 10 fingers. Yes, I posted a similar problem to StackOverflow, nearly a week ago, but no solution so far...
  15. S

    The reason I decided to meet you all

    Got a problem here! Table Events containing ( E_Name,Start_Date,End_Date) Table Participants containing (Event_Name,Participant_Name,Arrival_Date,Quitting_Date) E_Name is a unique index for its table (Event_Name&Participant_Name) is a unique index for their table Start_Date and...
  16. S

    Greetings

    Hi everyone! I'm new to programming and DB's in general, wanting to learn every day. I should've started this career LOONG time ago, but I guess life had other plans until now. I signed up to learn, get tips&tricks and to share what I already know of related and not-so-related topics.
Top Bottom