Search results

arnelgp Tried both - no luck isladogs Well, it actually only prints up to the offending record, so it doesn't really print correctly. Yes the rptToDoListNotes is a subreport.

Yes, I have that control; it is a subreport. The issue is only effecting one record. This record has long list of related records in the subreport "rptToDoListNotes" If I run the report filtered for just this one record, it works. However, when I run it for multiple records, it...

I think I found the issue. The report has an On Print event: Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Const DS_Invisible = 0 ' set line draw width Me.DrawWidth = 10 ' set drawstyle mode Me.DrawStyle = DS_Invisible ' ' Assume ctlBoxName.height...

pbaldy: yes the report opens with data in it. The e-mail does not open. JHB: I will add a space. And no, the other report has different criteria.

I can't get this code to send the report. The code creates the report, but does not get past the send command. It never gets to the close report line. If I modify the code to send a different report, it works fine. Private Sub cmdOrgPrint_Click() Dim LResponse As Integer Dim hours As...

Thanks! It is really coming together. Been tinkering on and off with Access for almost 19 years, and I think I finally made the killer app! (for me anyway)

The right form is open. Again, the problem only occured when adding an additional field to the combobox recordsource. I just tried it again (for the 10th time), without making any other changes, and it worked/did not do the same thing. Real head scratcher for me. :confused: Thanks...

There is a field Job in the recordsource. The problem is not in the reference; the reference works fine up and until I add the 5th field to the cmbWho Row Source. Here is the recordsource with the 5th field added; this doesn't work: SELECT DISTINCT tblToDoList.Who, tblToDoList.Job...

Sorry for the confusion. Yes, I get the prompt when using the combox in the form with the added column in the second combo box. As soon as I remove the added column, the problem goes away.

No. If I remove the phone field, everything works great.

I have 2 unbound combo boxes on a form. cmbJob cmbWho The after update event for cmbJob requeries cmbWho (as well as a subform). All this works fine. Here's the problem If I try to add another column to cmbWho, the row source no longer recognizes the cmbJob Criteria. I've attached 2...

Thanks arnelgp! Works like a charm.

I am trying to modify a hyperlink based on user input from a form. I want to add a date from a text box to the end of a url. Here is the code: Private Sub Weather_DblClick(Cancel As Integer) Dim strLink As String Dim strDate As String strDate = Format(Me.DateOfReport, "yyyy-mm-dd")...

Cool! Thank moke123. Used your method to call the function, and got my code to work. Here is the call code I used: Dim frm As String Dim ctl As String Dim ctlv As String frm = Screen.ActiveForm.Name ctl = Screen.ActiveControl.Name Response = EnterNewJob(NewData, frm, ctl)

Thanks for the tips on posting too. I'll prepare a db for up loading later this week.

I've got the names of the objects and controls down, my trouble is with the NewData and Response: Private Sub Contract_NotInList(NewData As String, Response As Integer)

I would like to use a function for my not in list. I use the combo box on may forms, and would like simplify things by using a function. Here is the code I've tried. It works as a subroutine, but when trying it as a function I am not sure how to transfer the NewData and Response: Public...

Thanks Mike. Point 2 sounds worth investigating. Many downsides I did not even know about.

Thanks Mike. 1. Not sure I understand this point. Some tables I get using an autonumber for the key field. Why is this always the best method? Do you just force other field to not allow duplicates? 2. I like using the look up at the table level - minimizes the work when making forms...

Thanks Paul. The code I have is for closing the input form after the new data is entered and going back to the form that called the Not_In_List event. I like your idea about passing the combo box name. I've got it to work. Attached is a piece of my database for reference.