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!

Search results for query: *

  • Users: akins4lyfe
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. akins4lyfe

    Access Option Buttons

    Hi, I have a form containing 5 option buttons, to check for series of specific validities, 1 command button, and a text box to display validity notes. I would like a user to select an option by checking the option buttons, then click on the command button, and place a note inside the text box...
  6. akins4lyfe

    Option Groups

    Hi, I have a form containing 5 option buttons, to check for series of specific validities, 1 command button, and a text box to display validity notes. I would like a user to select an option by checking the option buttons, then click on the command button, and place a note inside the text box...
  7. akins4lyfe

    Boolean Data Type Conversion

    How do i convert the "Boolean" Datatype in a Make Table Query pls?. I set up a make table query, based on a table which has one of its row data type as Yes/No. When the Make Table query runs, i noticed the results inside the Yes/No fields appear as 0 or -1. How do i convert this field within...
  8. akins4lyfe

    Ms Access SQL Query

    hi I am new to Access SQL query. I have a table with the following fields & data types. Fields Datatype ReadDate Text Micro-Business Boolean or Yes/No I'd like to design a query and update some data within this table, based on the...
  9. akins4lyfe

    MS Access SQL

    hi I am new to Access SQL query. I have a table with the following fields & data types. Fields Datatype ReadDate Text Micro-Business Boolean or Yes/No I'd like to design a query to update some data within this table, based on the...
  10. akins4lyfe

    Publish Option MS Access 2007

    I am trying to publish my database to web, but the "Publish" option button is grayed out in Access 2007. How do i enable this, pls assist. Thanks
  11. akins4lyfe

    Method or Data Member Not Found Error

    i have a listbox control placed on a form, "frmEmail". Users can select email address and click on a button to send email to a selected contact. I keep getting the above error, on these lines .To = strEmailRecipient .Subject = StrSubject .Body = StrBody .Display kindly assist...
  12. akins4lyfe

    Emailing Access Query

    I have a query which update on a daily basis. and i am currently using the Docmd.SendObject,,,"MyQuery",,,myname@mail.com,,True. To email this query to some managers. the criteria of the Date field of "MyQuery" is set to Date()-1. This ensure previous day queries are emailed out the following...
  13. akins4lyfe

    Calculated Fields In Access Queries

    My question is based of Access Database. I have an application that calculates total hours and breaks for employees within my department. The database has an action query, "QryTimesheet". This contains three calculated fields, and the criteria i used for displaying results are: Total Break 1...
  14. akins4lyfe

    Too Few Parameters. Expected 2. Run Time Error "3061";

    I have an unboud listbox control, placed on a form, it collects membership informations e.g firstnames, lastnames & Membership Numbers from a query called "queryFindMemberWildcard". I would like users to select a member from the listbox by double clicking a MemberFirstName or MemberNo. Then...
  15. akins4lyfe

    Type Mismatch Error 13

    Pls assist, I have a SQL query with wild card criteria. I am Using the SQL with VBA Codes. I want users to type in values into text boxes on a form, then populate a list box with related values (if available) from query results. I am getting the Type Mismatch error 13 when i do the search...

Part and Inventory Search

Back
Top