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 SkipVought 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: rccs1
  • Order by date
  1. rccs1

    Boot up Compaq nx9110

    When I turn on the laptop nx9110, the screen shows HP logo and "Esc.. to change boot order - etc, etc", checks HDD then screen goes blank and Windows XP doesn't start. I have to turn it off again, then turn on, press ESC, select boot from Hard drive. I then receive SMART failure Predicted on...
  2. rccs1

    SQL update time field with iif statement

    Thanks TheAceMan1. Fixed the job.
  3. rccs1

    SQL update time field with iif statement

    I have the following vba sql statement to update and table with fields in time format. Every time I run it, I get Run-time error 3464. Data type mismatch in criteria expression. The code is - strSQL = "Update TempSchedfunction set " & _ "[EndTime] = '" &...
  4. rccs1

    How do i remove a page break or field if null

    I have a report where the main data is on the first page, however, one field I want to print on the second page if it is not null.I have set up the report with all the fields on the first page except for the particular field - "Additional Info". If "Additional Info" is empty, I don't want to...
  5. rccs1

    How to print Report that has 1st page landscape, 2nd page protrait

    I have a report that requires the first page of the report to print in landscape layout with certain data fields and the other data fields to print after the inserted page break of the report in portrait orientation. So when the report is printed there will be Page 1 - in landscape layout and...
  6. rccs1

    Place Calendar Control value into combo box to search

    Thanks Lonnie. Yes the combo box is bound to a table by the BookingID field. Not the date. The date is the second column. eg. Column 1 Column 2 Column3 Booking Id Date Room Hidden/Bound Search The combo box is a search facility on the form to find specific records for the...
  7. rccs1

    Place Calendar Control value into combo box to search

    Can anyone help me. I have a combo box looking up a table which has following fields- BookingID Date Room The BookingID field is hidden in the combo box so the user types the date in the box to lookup the room. Howver to ensure the date is entered in correctly, I want to use the calendar form...
  8. rccs1

    Print image control

    I have an image frame on the access form and the control looks up the address for a image in the database which shows on the form, showing a different image for each record, similiar to employee's photos in northwind. I want to be able to click on a button to print the image displayed in the...
  9. rccs1

    Schedule reoccuring Dates

    Hi Remou Sorry can you give me an example. Thanks
  10. rccs1

    Schedule reoccuring Dates

    Can anyone help me. I am trying to write an Access2003 db based on events. When the user enters a date for an event, I need to give the user the option of a once of event or option to create reoccuring events like MSOutlook recurrence where the user can say the event is every day, or once a week...
  11. rccs1

    How to show data in report related to label caption

    Thanks dhookom. Fixed my problem.Brillant thanks again
  12. rccs1

    How to show data in report related to label caption

    Sorry, I did not state all the fields. The fields are - EventID Date Time EventName RoomName I want to include all rooms even though there is no event in that room on that day. eg Week beginning ##/##/## Monday Room1 - eventname Room2 - no event recorded Room3 - eventname Room4 - no event...
  13. rccs1

    How to show data in report related to label caption

    I am trying to set up a report where data is displayed only that is related to the label caption value for a weekly schedule report. eg. Label Data Room1 eventname Room2 eventname Room3 eventname The data has been assigned to the rooms however, I need to repeat...

Part and Inventory Search

Back
Top