Search results

You can use the DoCmd.MoveSize function to set the parameters of the position. -dK

Needed a comma here ... DoCmd.Close acReport, "RptIncidents", acSaveNo Anyhow, I jumped in here thinking of some possibilities where this could be used for myself. -dK

Okay, think I am with you now. Here is how I have overcame this before using pop-ups in this manner. Create a label control and set it where you want the 'message' to appear. Say call it lblMessage. Then on the OnLoad event use ... If IsNull(Me.OpenArgs) Then Me.lblMessage.Caption =...

Creating some .. well .. what appears to be some circular referencing. You have ... Private Sub Broker_Involved_AfterUpdate() Call Me.Broker_Involved_AfterUpdate End Sub Try ... Private Sub Broker_Involved_AfterUpdate() If Me.Broker_Involved = True Then Me.cboComboBoxName.Enable = True...

Was curious so dropping on the eaves of this thread. Since I had a test db open - I checked it and the requery method works (made some field level data changes) except when you add the reference from the report control (Forms!frm!cnt) to the form control to update the comments field. -dK

Amen! It's definitely going down in my book. I am trying to withhold myself from going through a buncha stuff to see if I can implement right away. :D I am sure someone will want to add something new at which point I can take advantage of it. -dK

Nice nugget there, Bob. Who'da knew? krzysiekk, I just validated this using Bob's post and added a label for visual verification. I added this code on the OnCurrent event of the form so I could cycle through records to see the label caption change as I modified the end time ... Notice that...

You could copy and strip out the unnecessary bits. As an aside, I've posted what I did - perhaps you can do a bit of stare and compare to contrast what I've done verses what is going on in yours to see if anything is amiss. -dK

I've attached a report screen and the original proposed solution appears to work. The first two columns (A & B) are bound and fed from a table. Column X & Y are unbound and calculated (e.g., [A] + 2). Last, column Z is unbound using the IIF in discussion. Perhaps you can post the db? -dK

Ah .. found it. This might be overkill for what you are doing, I am not sure of your underlying structure, etc., but you should be able to get the gist of it. Take a look at this thread. You would definitely have to mod the WHERE statement in the function posted by VBAInet (post #11). The...

Okie dokie ... I have my method of doing it but discovered another way that was posted not too long ago that might be of better assistance. I will have to search through the forums for the appropriate thread - give a few moments ... -dK

Okay ... to surmise so I can stall for time and think :D The IIF is used in a control source of an unbound control in report? The controls referenced [textn]are calculated controls (based on other controls) or are they bound controls (coming from an underlying table/query)? -dK

Errrr .... I was using that as a demonstration that you should be able to use Me.OpenArgs anywhere in the pop-up. :o Now, if you want (because you instantiate other forms using the function) you can set up a (public) variable and assign that variable the contents of OpenArgs for use or...

Hmmm ... that 5|2 definitely doesn't compute. Just for grins ... modify your IIF to this ... IIf(CInt([text1]) > 0, CInt([text2]) - CInt([text1]), CInt([text1]) + CInt([text2])) -dK

Yes, it is possible. The question is - (a) Are you creating the serial numbers on the fly and you create the metal stamp for the product then, or (b) is it going to grab them from somewhere else and then you dig through the boxes looking at the box labels to ensure you grabbed the right...

The only reason I didn't suggest that was if the record was completed, the box would still be grey ... so suggested the coloring happen on the OnOpen event (If Me.NewRecord Then Me.txtControl.BackColor = .... ). I think perhaps the 3 step process seemed to much of a hassle. Now, if someone...

I am not sure why it is not working. I've attached my screenshot where it works. -dK

That looks about right. I would assume most call for the OnLoad because OpenArgs is mostly used to pass something that the db needs to make a decision on about the form and it should occur at this stage in the processing of the form. It should work for by using Me.OpenArgs in your MsgBox ...

Hmmm. So it tested one way fine, but not the other. Might need to use a CInt(...) around those to ensure that they will be manipulated as integers. I will perform a check, too. -dK

Are those numeric fields you are working with? That is, declared at the table level as numbers? Or, are these some unbound controls on a form? -dK