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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MikeSawt
  • Content: Threads
  • Order by date
  1. MikeSawt

    How to clear data in a CFForm after submitting

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

    Incomplete Data for double "On change of" Bar graph

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

    DateTime field conversion from Access 2003 to SQL 2000

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

    Compile Error: Can't Find project or Library

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

    Code for getting data from last into the next record in a query

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

    Setting focus from one sub form to another subform

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

    Avoid multiple enteries of the same information or subreport

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

    Excel Activecell Right Click Menu Issue

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

    Access Security wizard mistake

    I made the mistake of using the security wizard to protect a database that I was still developing. I am now no longer able to gain access to this database. For a while it was asking me for a password, but it no longer asks for a password and I now get the following message when I double click...
  10. MikeSawt

    Need help setting up an autofill field Access

    I am able to set up a combobox for a field so I can choice the value from a second table list. I can also create a querry that will lookup the fileds. The problem is, I can not get the secondary fields to autofill from the combobox. Is the an step by step instruction avaiable? The first...

Part and Inventory Search

Back
Top