Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by akins4lyfe

  1. akins4lyfe

    Crosstab Query

    I have finally figured this out, here is the magic query that did the trick: TRANSFORM Sum([Logout Time]-[Login Time]) AS HoursWorked SELECT [First Name] & " " & [Last Name] AS [Agent Name], Sum([HoursWorked]) AS [Total Hours] FROM tblEmployee INNER JOIN tblTimeSheet ON tblEmployee.[LAN ID] =...
  2. akins4lyfe

    Problems Formating Time In Excel

    I currently export an MS Acess crosstab query into excel spreadsheet, in order to calculate total hours worked by each employee, every week. Time format within each field is similar to numbers e.g, 0.32869213. Formatting 0.32869213 into short time within excel, hh:mm, equals 7:53 (7 hours 53...
  3. akins4lyfe

    Crosstab Query

    Hi Skip, Thanks for the useful advice. I thought i could get away with the Format function by appending "h\hn\". i have removed the format function, and changed "Date to Dates", but still can't figure out why TRANSFORM ([Logout Time]-[Login Time])*24 returned decimal numbers again...
  4. akins4lyfe

    Crosstab Query

    i have designed a crosstab query from a table with fields containing DATETIME datatype, to produce a report showing employee start time, and end time, for sets of specified dates, e.g "Current Week". here is my query: TRANSFORM Sum(Format([Logout Time]-[Login Time],"h")) AS HoursWorked SELECT...
  5. akins4lyfe

    Unexpected error, description 3061, Too few parameters. Expected 2.

    hi, yes I am opening a record set from the query, in order to view calculated totals, based on dates. e.g monthly total. my recordset is below: Dim rstReport as DAO.Recordset Set rstReport=dbase.Openrecordset("qryReport") rstReport.Findfirst("[order_date]='"& me.txtdate &"'") If Not...
  6. akins4lyfe

    Unexpected error, description 3061, Too few parameters. Expected 2.

    hi all, I have a SELECT query (qryReport) based on two tables, tbl_Customer & tbl_Order, I am using this query to generate a routine calculation, of total cost and profit, from periodic sales transactions. I also set up a form, with two textboxes and a button, for users to enter dates and...
  7. akins4lyfe

    Execution of this application has stopped due to a run-time error

    hi PHV, Thanks for your response. This database was not splitted into BE+FE, a single compiled .mdb file was installed inside a network folder. A hyperlink of the database path, was sent to all users, to access it at the same time. Thanks.
  8. akins4lyfe

    Execution of this application has stopped due to a run-time error

    Hello all, I have an application running on Access 2003 version, installed on a shared network folder. The database is accessible to more than 15 employees at a time. We have installed the full version of Access 2003 on all workstations. Therefore, i don't believe it's a reference or run-time...
  9. akins4lyfe

    Option Groups

    @dhookom yeah, i know that, not a common or best way of doing things. But what you have to understand is this, the main purpose of this project is to create "new notes" ...something like an "Auto Noter", whereby entries by a user changes every minute. So, what i did was to collect those...
  10. akins4lyfe

    Option Groups

    @dhookom. I decided to nest my data inside my codes because of the following reasons: I have series of notes that needed to be concatenated together with sets of other values, to produce dynamic results. For example current date, current time, 5point signatures of different employee across...
  11. akins4lyfe

    Option Groups

    Oh yes, absolutely correct, i have multiple 'option buttons' and they are all in separate groups. See, the problem with Check boxes is this, there's no way to code the "Onclick" Event of a check box. That would have been the smartest way of doing things. Well, problem solved now :) Thanks
  12. akins4lyfe

    Option Groups

    this has just been resolved, i tried something along this line, Select Case True Case Me.OptionTerminate1.Value And Me.OptionOther1 Me.txtNote = Tc1 &" "& Other1 End Select Where Tc1 and Other1 are variables, with different values assinged. And it worked, perfectly!
  13. akins4lyfe

    Option Groups

    hi Andy, Thanks for sharing that neat trick, Now, what if i am selecting more than one option, at a time? for example up to 5 options. Any clue as to how series of results may be generated?
  14. akins4lyfe

    Access Option Buttons

    Hi TheAceMan1, Thanks for adding your thoughts, regarding this issue. You are correct, i initially had series of independent option buttons placed on my form, as specified within my first post. I chose to use each options independently because of the nature/specific requirements of my...
  15. akins4lyfe

    Access Option Buttons

    Thanks Majp, i thought about Using a Case as well, but my project involved selecting not more than one option at a time. Although, strange enough, i have now resolved this issue, by twitching around my code a bit. This was how i did it, Validating each options in the group, so that when an...
See more

Part and Inventory Search

Back
Top