Search results for query: *

I have set up a three page web application. Page one has a cfform and fields to be completed by the user. Page two displays the values for review by the user prior to submission. Page three submits the data and prints a coupon. The application is working correctly and submits the data to my sql...

Got it. That's great Thanks for your help LB

Yes ascending order. The legend was supressed. I showed the legend and it was colored by group. Only the MD names showed. I changed it to colored by series. This show all the MDnames followed by the months. They are out of order. Smith 11/1/09, Smith 7/1/09, Smith 8/1/09. I think the...

This is the formula with my table name {FirstCaseLateReport.SFN} & " " & date(year({FirstCaseLateReport.SDate}),month({FirstCaseLateReport.SDate}),1) but with my data, it still was out of order. I had to removed the labels. I know it is out of order because I have a Pivot Table below the...

Chart Specific Options Type) Bar: side by side bar chart Data) 1)On change of MDname ascending order 2)On change of DateofSurgery ascending order Show Values) Avg of @percentdetail Options) Show label The lable for the month will show in the graph NOT on the axis. The Axis displays the...

I tried three different ways. I tried it as a Datetime field, a String field and a Number field. It did not matter. The sort for the date would come out wrong on the second MDname if the first MDname had missing data.

DateTime 6 months Jun - Dec The date is entered using an Access front end, as a date format "yyyy-mm-dd-hh-mm-ss". Although it only displays the "mm-dd-yyyy". The user enters "12/1/2009" but it is stored in the table as 2009.12.1.00.00.00. I used on change of MDName and then change of...

The dateofsurgery is a DateTime Field. In a process of trying to correct the issue, I convert the datetime field to a text field with a formual using if statements. I then used a specific order on the text field Jan Feb Mar..... It did not matter. The Month would still be out of order. I...

I am using Crystal 11 and a SQL database. My data is for On-time starts in an Hospital Operating Room. Data includes: DateofSurgery, MDName, SurgeonType, PercentOnTimeStarts. I am doing a six-month report. I am grouping the graph "On Change of" by Surgeontype first and then MDName. The issue...

I am new to SQL and I am trying to convert an Access 2003 database to Microsoft SQL Server 2000 backend. I am using combo box in Access that is linked to a SQL table/query with the time information. I have the properties in Access set to “Medium Time” and this displays as 8:30 AM once the...

I know how to get to references but I don't know which check box should be checked? Mike

Here is the problem! I have a MS Access 2000 DB that was work earlier. The Network Admin moved my domain. The DB is no longer working. I get, Compile Error: Can’t find project or library An example of the code: Private Sub Last_Name_Change() Mneumo.Value = Left$([Last_Name], 3) End Sub...

I am using Access 2000 I am trying to calculate a turnover time between surgeries in an operating room suite. I have multiple Operating Room. I am running a query which will sort by the date and by room number. The Table Name is: SurgLog The two field names that I am interested in...

I am using Access 2000 I have a main form: PateintDemo I have two sub forms: SurgeryLog and OR_StaffRolesub The last field name in the SurgeryLog subform is WoundClass The first field name in the OR_StaffRolesub subform is Mneumonic I want the tab control to go from [SurgeryLog]![WoundClass]...

I have an Access DB and I am trying to do a subreport. I have created the sub report and linked the fields. And used the select expert, I have filtered down to the correct information. However, when when I view the data I get the same subreport printed five times. (there are five values in...

I found my problem!!!! I did not have the "add context menu item module" check box checked in the addins menu from the tools menu. It works fine now. Combo, Thanks for the help Mike

The code below is all in the same workbook: VBAProject(Personal.xls) -> Microsoft Excel Objects -> ThisWorkbook For some reason it is not recognizing the Delete Code????? Private Sub Workbook_Open() Dim NewControl As CommandBarControl MsgBox "Control added&quot...

I don’t get that error because I have created a form called “frmCalendar”. I have a procedure to open the calendar called openCalendar1 ____ Sub openCalendar1() frmCalendar.Show End Sub ___ The only Enable property I could find was in the frmCalendar and it is set to true, the default setting...

I removed the 'On Error Resume Next' line and I did not recieve an error message. However the menu items is not removed, and appears multiple times.

I have written the following code in personal.xls to add a pop up calendar First to add the menu item. ___ Private Sub Workbook_Open() Dim NewControl As CommandBarControl Set NewControl = Application.CommandBars("Cell").Controls.Add With NewControl...