Search results for query: *

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.

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

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

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.

Woops, "Unbound

No, it's an unound field called ConfIDHold

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

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

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.

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 =...

I have a database that is used for reserving videos from our Safety & Health Video Library. This db after a video id is entered, checks for the next available date it could be sent out. After that, it checks to see if the shipping date is a weekend or a holiday. if it is, it changes the...

I am using SendObject in order to send an email from access. The To: CC: BCC: Subject: is pulled from a form, and the message text is also on that form, but it's not putting the message text into the message. The code is as follows: DoCmd.SendObject acSendReport, "rptinttng_equipment"...

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

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

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

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

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

I'll check that out. Thank you.

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

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