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!

  • Congratulations strongm 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 EasyOnly

  1. EasyOnly

    New record

    OpenForm: ProjectSub_tbl, Form, , ="[ProjectID]=" & Nz([ProjectID],0), , Dialog SetTempVar: ProjectID, [ProjectID] SetTempVar: ProjectID, Nz(DMax("[ProjectID]",[Form].[RecordSource]),0) Requery SearchForRecord: , , First, ="[ProjectID]=" & [TempVars]![ProjectID] RemoveTempVar: ProjectID I...
  2. EasyOnly

    Time

    I see... I went to reference and did not find control Microsoft Date and Time Picker Control 6.0. do I need to add it somehow?
  3. EasyOnly

    Time

    hahah...Now that i read it again, I should be looking in Pet store. I am fine TheAceMan1. But I need one for hours and one for minutes since some meeting start at fraction of the time.
  4. EasyOnly

    Time

    Hi All, Is there a way to have a time picker for field just like the date picker.
  5. EasyOnly

    Dates...

    So if the query name is Posttrip_qry. in this query I have multiple table witd different field needed for the report. SELECT.....ProjectID FROM Posttrip_qry WHERE 201003 Between (100*Year([start date]+Month([start date])) And (100*Year([end date]+Month([end date])) I am not sure what is 201003
  6. EasyOnly

    Dates...

    Hi All, I have start date and end date in a table. two different fields. I need to run report with all events that is accosiated with one month. started or ended in a specific month. I have some events that start in March and end june... some other events that start in Feb but end in March or...
  7. EasyOnly

    Access 2007

    Hi All, For soem reason the small square that you click on to go to the source record disapeared. now the form or the report when clicking od design view, it shows first thing details. Any suggestions on how I can restore back the form or the report? Thanks
  8. EasyOnly

    No activities.....

    dhookom, Sorry for not being clear here. organization is the coustomer table and activites is projectsub_table. We have some coustomers who has no activities for months. we would like to have a list with the names so we can call them to make sure they are benefitng from our services. When I...
  9. EasyOnly

    No activities.....

    Hi All, I am not sure how to do this but I want to be able to run a query to find any coustmer who did not have any activities since 2 months for example. The tables involved will be in the following: SELECT Organization_tbl.OrganizationName, ProjectSub_tbl.[Start date]...
  10. EasyOnly

    If statement....

    MazeWorX, thank you so much. it worked. now if I want to add conditional format to the comments field if the checkbox is checked the comments box will turn yellow till we have some comments, then it will turn white. Thanks
  11. EasyOnly

    If statement....

    I used the code below but yet when I closed form, it closed without forcing the field. Private Sub Form_BeforeUpdate (Cancel as Integer) If Me!Travel = True And Trim(Me!Comments & "") = "" Then Me!Comments.SetFocus Cancel = True End If End Sub
  12. EasyOnly

    If statement....

    I am trying to get this working correctly: If the user click on travel, then msgbox will say comments required. then the focus should go to comments field and user will not be able to move out of the field till they write comments. the code I am using: Private Sub Form_BeforeUpdate (Cancel as...
  13. EasyOnly

    Count checked and unchecked boxes

    Thank you so much dhookom. you are the man!
  14. EasyOnly

    Count checked and unchecked boxes

    This is the SQL statement: SELECT Organization_tbl.OrganizationName, ProjectSub_tbl.Description, ProjectAct_tbl.StartDate, ProjectAct_tbl.Travel, ProjectAct_tbl.Hotel FROM ((Organization_tbl INNER JOIN Projects_tbl ON Organization_tbl.OrganizationID = Projects_tbl.OrganizationID) INNER JOIN...
  15. EasyOnly

    Count checked and unchecked boxes

    The query will have the following fields: OrgName from Org_tbl, Description from Sub_tbl, the two fields travel and Hotel will come from Project_tbl then finally startdate. Example, the trip on 07/08 have 40 traveler. we booked 99% for travel and 95% hotel and so on. For the month of July, we...

Part and Inventory Search

Back
Top