Search results for query: *

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...

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?

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.

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

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

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...

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

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...

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]...

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

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

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...

Thank you so much dhookom. you are the man!

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...

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...

Hi All, I am trying to summerize data in a table. I have two check boxes 1) Travel and the second Hotel and there is start date. I want to be able to count how many checked box for travel and how many boxes are unchecked from the total. Same for the second box(hotel). I will need to report...

Hi All, Any idea what will the after update event would look like that will update the subform. Thanks

Hi All, I would like to create a report dashboard. I am planning to create a report that has about 6 subreports and would like to create six comboboxes so each one will control one subreport. I have no idea how will this work in a report but I have an idea that this might work. What is your...

Hi All, I created the table, the query, the combobox linked to the table with all the queries. Now, for the subform that is connected the combobox, what will the record source will be. ....................... BISTeam, If I would like to implement your suggestion, where will I use the code...

Thank you for all the suggestions. I will work on it this afternoon. god willing. I am specificaly working on a dashboard. the form will contain 5 subform/charts.....