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!

Register Log in
  • Congratulations Rhinorhino 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: Grandkathy
  • Order by date
  1. Grandkathy

    Can I change the width of a field in an event?

    Thanks for you help. Yes you can change the size of the fields on a report, dependent on another field. I thought I'd checked the actual name of the field, when in actuality, it was named "text15"....... Oops.
  2. Grandkathy

    Can I change the width of a field in an event?

    I have a field that for some of the report will be the default width, but for one specific section of the report I need that field to be wider and the next field to be narrower. Such as: Me.RecommendYesNo.Left = 270 Me.RecommendYesNo.Width = 600...
  3. Grandkathy

    Data Shaping Question

    I have an ASP page that I am trying to show a list of someones Level 1: Direct Report Level 2: Their Direct reports Level 3: Their Direct Reports, etc........ I'm going to be able to go 5 different levels. I've been able to get the page to run beautifully finally...
  4. Grandkathy

    Table field Defaulting to an Open Form?

    This would be great if I hadn't been sleeping when I wrote the message, I goofed. The field I want a default value in is in the table design, and I want the default value to be derived from a form that is already opened. Thanks for taking your time to answer this.
  5. Grandkathy

    Table field Defaulting to an Open Form?

    Woops, "Unbound
  6. Grandkathy

    Table field Defaulting to an Open Form?

    No, it's an unound field called ConfIDHold
  7. Grandkathy

    Table field Defaulting to an Open Form?

    Is it possible to have the default value in a field default to an open form? i.e., forms!frmMain.ConfIDHold Thank you.
  8. Grandkathy

    Finding Out if a date is a Holiday/Weekend

    HolidaysTemp holds 2 fields: HolidayDate HolidayName 3/19/2005 Weekend 3/20/2005 Weekend . . 9/5/2005 Labor Day ShipHold is a Global Variable rst2 is for this function the recordset Set rst2 = New ADODB.Recordset 'sets the recordset to a...
  9. Grandkathy

    Finding Out if a date is a Holiday/Weekend

    Yes, I do intend to add DateAdd to the last for date additions. I've tried some msgboxes, but evidently not in the correct place. Thanks, I'll try putting more message boxes in and see what I get.
  10. Grandkathy

    Finding Out if a date is a Holiday/Weekend

    Sorry about that. If Weekday(ShipHold) = 1 Then 'if '5 **** weekday 1 = Sunday Forms!frmreservations.ShipDate = DateAdd("d", -2, ShipHold) Forms!frmreservations.ShowDate = DateAdd("d", 3, ShipHold) Forms!frmreservations.ShipBackDate = DateAdd("d", 10, ShipHold) Forms!frmreservations.DueDate =...
  11. Grandkathy

    Finding Out if a date is a Holiday/Weekend

    ...End If ' if 1 While Not rst2.EOF If ShipHold < rst2.Fields.Item("HolidayDate") Then 'if 2 Exit Function Else ' if 2 If DelivTyp = 1 Then 'if 4 *****1;PickUp If Weekday(ShipHold) = 1 Then 'if '5 **** weekday 1 = Sunday Forms!frmreservations.ShipDate = DateAdd("d", -2, ShipHold)...
  12. Grandkathy

    Sending E-Mail from Access

    ...not putting the message text into the message. The code is as follows: DoCmd.SendObject acSendReport, "rptinttng_equipment", "RichTextFormat(*.rtf)", [Forms]![frmIntTng_Classes].[LogonIDHold], , , [Forms]![frmIntTng_Classes].[TngCourseNameHold], [Forms]![frmIntTng_Classes].[MsgHold], False...
  13. Grandkathy

    Invalid Qualifer Error Message

    That got rid of my error messages, thank you for your help.
  14. Grandkathy

    Invalid Qualifer Error Message

    Okay, that makes sense. I'll try and fix it. Thanks for your time.
  15. Grandkathy

    Invalid Qualifer Error Message

    DateDueOut, DateDueIn, TimeDueOut, TimeDueIn. RDO = rst.Fields.Item("DateDueOut") RDI = rst.Fields.Item("DateDueIn") RTO = rst.Fields.Item("TimeDueOut") RTI = rst.Fields.Item("TimeDueIn") Thanks
  16. Grandkathy

    Invalid Qualifer Error Message

    Hi, This code is the first step in verifying availability of a piece of equipment on a certain date. I keep getting an error message "Compile Error:" "Invalid Qualifer" It keeps stopping on the RDO, RDI, RTO and RTI variables, I've tried commenting them out, and it compiles okay...
  17. Grandkathy

    Cant' generalize code to use with different forms

    I have the following piece of code which I use to verify that a user has entered a video id accurately. I want to be able to generalize it more and use it on more than one form, I have 3 or 4 forms which use the Video ID field. I’ve tried using me. Instead of the form name, but it gives me...
  18. Grandkathy

    SignIn Form Timing Out and requiring re-signing In for No Reason

    I'll check that out. Thank you.
  19. Grandkathy

    SignIn Form Timing Out and requiring re-signing In for No Reason

    Thanks, I'm not loosing network connections, I have a dozen databases and this is the only one that this form does this in. I use the same log-in process in all of my databases, and I've imported the form into all of my databases. I'm one of the users that it's doing this too as well, there is...
  20. Grandkathy

    SignIn Form Timing Out and requiring re-signing In for No Reason

    HELP! I have a database that three different people use, 2 of the people have it open most of the day. In order to get into the form, I have them go through a Sign-In form I've created. Which enables me to keep track of who's in the database and who made waht entries. Now, for no reason...

Part and Inventory Search

Back
Top