Search results for query: *

I wanted to give the users the opportunity to edit and modify an activity, if needed be. I just assumed that could only be possible using a Listbox.

So I have a button called Add Activity which is on the main form, that opens up the Training Activity form. My expectation is that once I create the record in The training activity form, it should automatically populate the activity table. I think I may have made this more complicated than it...

I didn't think about that. I assumed it captured the value automatically, My question then is how do I capture the Event.ID to the Activity table/form?

My apologies that was the wrong command. Actually I have no code behind the Save button. I thought I did. - Can you make a suggestion please? Thanks.

That seemed to fix it.. At least to ensure that the listbox is empty when creating a new event. But when I create the activity it does not create the entry in the listbox. Here is my code behind the button' Private Sub Command16_Click() Saved = True DoCmd.RunCommand (acCmdSaveRecord)...

So I added the training table to the SQL Design. and the query now looks like this. SELECT tblTrainingActivity.[Activity ID], tblTrainingActivity.[Activity Type], tblTrainingActivity.[Activity Start Date/Time], tblTrainingActivity.[Activity End Date/Time], tblTrainingActivity.Integrator FROM...

No it doesn't. i have a table called tblActivities which stores the data. The Primary key Events Id from the Training Events table is a foreign key on the tblActivities table. Now that i think about the filter makes no reference to the Training Events table. SELECT...

Yes, when I open the main form Training Event it still shows records in the Listbox, even though the form is opened to add a new record. The listbox should be empty.

No there is no lookup table. This is freeform. I slso want to make sure that an activity can only be created only after the Event record has been created.. I want to avoid orhpan records, if you catch my drift....Here is the code that is behind the add activity button. Private Sub...

I have a listbox that would list activities related to a training event. The event is the master record, while the activities will be the child record based on the tables relationship. i have an "Add Activity" button that will create the related activity and populate the listbox instantly. How...

I am attempting to filter out a subform when I select a value in a combo box, My problem is that whatever value I select I get the following error message: - RunTime error 3464 - Data type mismatch, and the debugger points to the 4th line in my code. Not sure where the data type mismatch is...

Thanks for your response. The tricky thing is that the main report is not really the issue. I have four subreports within the report that need pull that data. How can I use your suggestion for the subreports?

I want to know how to pull data for a all the months so far this year meaning April, March, February, and January. As well as December,November and October of last year. The tricky part is that I have 4 sub-reports that need to pull information based on this criteria. This is a one time report...

Got Ya!. SQL Server 20008

Not sure what you mean by that.

I need to create a report that would run quarterly. The report would run as follows For cases that were created between October 1 to December 31st first the report will run Jan 1 For cases that were created between Jan 1 and March 31st the report will run April 1st For cases that were created...

I keep on getting there must be a group that matches this field. Should I be putting the group names in the formula or the formulas themselves.?

I created a formula to capture the weekending of a specific week. I then created a group based on this formula. I want to be able to give a percentage of cases resolve within each week.. The problem i have is that it is giving the same percentage for every different week. What should I do to the...

Ok. I created a new one. Thanks..

I am having serious difficulties in trying to do a percentage of Resolved Cases. My report pulls all cases within a specified date range. So far I did the following. Created the following formula - //Resolved If {HPD_Help_Desk.Status} in ["Resolved", "Closed"] Then 1 Then I created a...