Search results

I have a form where a different form opens up when a user clicks a certain button. What I’m trying to do is assign field values from form1 to fields on form2 and it’s telling me that I can’t assign a value to this object. Could someone please tell me what that means and what I’m doing wrong. Thanks.

thanks...will try

On my form i have a couple of fields that shouldn't contain a Null value. I can't seem to figure out where to put my code with displaying a msgbox if a value is null. I tried the Before_Update event, but nothing ever happens. I want this msgbox to pop up right after a field is bypassed and not...

that worked! thanks again for all your help.

Thanks...will try that.

If FTE1.Value > 1 Then MsgBox ("FTE can't be greater than 1 for any given day") Cancel = True FTE1.SetFocus docmd.SetWarnings False ExitSub End If DoCmd.OpenReport "rptPersonCheckAvailability", acViewPreview

that didn't work... i put it right before my exit sub...and it still brought up that message. any ideas?

I totally agree! And you helped a lot, not a little! :p

I have a Before_Update event and I exit sub if date is not right. If everything checks out I open a report. Now if some data needs to be corrected before that report is open, is says DoCmd action was cancelled and I need to click OK. Is there a way suppress those informational messages to the...

Thank you...that worked... And thank you for all the help on the other piece. I finally figured it out over the weekend.

When i use my calendar on a form, it gives me an error: Run time error 438 - Object doesn't support this property or method. What does this mean?

Also, I'm wondering if I can have a conditional statement within DCount function. Because this date checking criteria (qryStartdate < formStartdate And qryStartdate < formEnddate OR qryStartdate > formStartdate and qryStartdate > formEnddate AND qryEnddate < formStartdate and qryEnddate <...

This is what I could come up so far. It’s not working, but I think that this is the beginning of what I need. I check (by pushing the command button for now) each and every new date that is being entered into the database. There are 4 conditions I check against: (anything starting with qry –...

Thank you. I didn't even think about looking at it in SQL fromat. Thanks!

In the query that is on the screen print there is criteria for start date and end date. I’m wondering if there is an operator between those 2 and what I mean by that - is there an AND or an OR? startdate criteria AND enddate criteria or startdate criteria OR enddate criteria Thanks.

For some reason I don't think this piece is working correctly. So all I am doing here is saying how many (DCount) records (ID) within (qryStaffActivityChk) which have a (ActivityStartDate AND StaffID) equal to the current record (Forms!frmStaffActivityDetails!ActivityStartDate). I don't think...

Is there a way to debug the following statement: If DCount("ID", "qryStaffActivityChk", "ActivityStartDate = Forms!frmStaffActivityDetails!ActivityStartDate AND StaffID = Forms!frmStaffActivityDetails!StaffID") > 0 Then I did a msgbox(DCount(...)) and that works, but it only gives me a count of...

When i added some msgboxes to see if the values are correct, it seems like the activitystartdate is being picked up from the form both times. I don't think it's picking up values from the query. Am i wrong? Clikc to cmd button to see msgboxes (both dates are the same)

Thank you for all your help! I will try and figure out how to make this work from here... Again, thanks for all your time and efforts!

I tried this and it didn't work :( "Let's say I have 01/01/05 - 01/10/05 already scheduled and then i come in and try to add something for 01/07/05 - 01/20/05. Would that work?" I'm hoping that because of the StaffID situation - it's not working correctly. And yes, each member should have a...