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

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

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

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

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

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, 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 am not sure from where to start. But I would like to create a combobox that the records in this combobox are the different queries that I created. I want when I select a query from the combo, it reflect in the subform. The subform will be a graph. I know I asked a big few questions...

Hi All, I am trying to specify the end date for a query to pull data up to last month and to pull the data that has no end date. So the end date will have criteria of is null.... Any suggestion for last month....

I am working on a database for a clinic that will see patient free of charge and I volunteer to help them witha database. I am working on the appointment scheduling. I want to have a calander. I would like to link the calander to the subform. Basically, the scheduler will pick the day from...

I am having a strange problem. whenever I try to open an acces report in design view, the computer takes forever to load and if i click anywhere in the report while loading, it will even display not responded message, but if you leave it for a minute it will open. Not sure what to do next to be...

Hi All, I am working on a report that contain 3 pages for each client.Some of the clinets will have data in the 3 sheets. the other will have only in 2 sheets. the first and the third. I have to print the report as a set for all client with page numbers. 1-60. However, maybe 15 pages in that...

I have a chart that the the source code to it is the following: SELECT [1Departmentsbyall].Department, Sum([1Departmentsbyall].SumOfAmountReimb) AS SumOfSumOfAmountReimb, [1Departmentsbyall].OrganizationID FROM 1Departmentsbyall GROUP BY [1Departmentsbyall].Department...

Hi All, I have a report that contain 6 subreports. The problem I have is the following: some of the subreport may have no data depending on the client. I want the sub report no to show if there is no data and a massage would show in the location of the subreport indicating that there was no...

Hi All, Just a question regarding the datasheet subform. Is there a way to change the back ground color of the empty space after the form from dark gray. I hate this color so much.....

Hi All, I am creating a table and one field will be month. The reason we are doing this is because the data we get by month and it pertain to the whole month. Should this field be date field? What would the format type for this field be? Later, I will need to report the data by month and by...

Hi, I need to create a dashboard for the company. Is there an easyway to do this. I was thinking about third party software that I can but to do my job....:) Thanks

I am designing a report that I need to have two detail sections. I have about 3 tables as row sources. two of the table relate to the first one (one to many relationships) I need to have the report lookinglike this: Name:John Smiith First table records: There maybe or or few Second table...

Hi All, I have a power point template that I would like all staff to use but I want to make sure no one save on it. I want them to be able to do save as only. is this doable? Thanlk you Tek tips