Recent content by NC1977

It is a command button...Would you this in the Afterupdate property of my field list??? Thanks

I have a form with a field list. Once the user selects from that list, he can then proceed to another form to enter additional information. I would like for it to be impossible to continue to the other form without having selected from my field list. How can I do this?? Thank you

Hello, Here is my script to handle a few errors on my form before the user can print: If De > A Then Msgbox "Your FROM date cannot be bigger than your TO date" ElseIf IsNull(Mandat) Then Msgbox "Please enter the file number!" ElseIf IsNull(De) Then...

Last question, I'm trying to set the output format to Rich text format... How do I put it in my code?? I've tried RTF, Richtextformat, rtf, this doesn't work...any ideas??? Thanks

Remou it worked! Thank you thank you! wonderful!

Actually the subject line reads Forms![Requete Lawson]![Mandat]....But I think what Remou said is correct, I should save the record first however, half of my form is bound and the other isn't...I'm not sure how to save my record to a new table and then run the email code all in one command button???

Good morning, I have a form, with a command button that once clicked sends my report directly to the users email so that he or she can email this report. The following is my code: DoCmd.SendObject acSendReport, "Requete Lawson", , "xxxx.xxxx@lakdsjfl.com", , , Forms![Requete...

I've got OnOpen OnClose OnActivate OnDeactivate On No data OnPage and OnError...That's it. I do have the OnLoad for the form and I did put the statement in a form to test.. This is my code for the onclick event: Dim strSQL As String strSQL = "SELECT " & Me.Combo359 & ", " & Me.Combo361 & "...

Ok, I did what you said except for the onload event as their isnt' one for reports so I put it in the onactive property.. I'm still getting the same error..I tried putting the results in a form so that I could try the onload but it doesn't work. Could it be the Me part of me.RecordSource=strSQL???

Hello Again! Ok, this worked...except for one thing, I've got my statement running and opening in a report. The field list for the report doesn't contain any of the fields requested??? The field list box's title is my sql statement??? I'm soooo close I can almost taste this! I'm very excited

I'm sorry, I'm not being very clear am i? ok here it is: I have a table with about 45 columns. Not sure how to attach a spreadsheet to my email...I'll try to explain: Col: Division - Group - Region - Trend - EBIT - Safety Trend - etc..(45 columns of this) Rows: Fairlfield - Book - USA - 1...

Ok, this works except for one thing, I believe I need to create some kind of relationship between my field lists in my combo box and my table..when I run the report I get the columns I have selected but like this: LEGAL ISSUES TREND SAFETY TEST UNION LEGAL ISSUES TREND SAFETY TEST UNION LEGAL...

Hi Bob, I've created a table with the list of all 30 columns. Then added 5 combo boxes to my form. I really don't know however how to formulate a sql statement? I know how to select fields etc, but only if I name them...how do I pass the argument of " take the field listed in each combo...

Hi! I've got a form, where the user can select a division or Group or region and it runs my query "Pivot Table by Division" with these parameters. Now I have 30 columns in my QRY and I want the user to be able to select up to 5 of these colums (the capital ones, I only put 3 as an example)...

ok, I've linked my table with the picture names to my query. I've found the on format so that I can add code. I now don't know what code to put??