Search results

I am using the docmd.sendobject command to send a report as an .snp file. What I would like to do now, is to send .snp files for two reports. Can I do this with the sendobject command?? My code is: DoCmd.SendObject acReport, stDocName, "SnapshotFormat(*.snp)", , , , stSubject Thank you

I have a database that I would like to set up three levels of security (something I have never done before). Admin: Would have full permissions to modify anything in the database. User: Would have permisison only to enter data, use command buttons, view and print reports. Viewer: Would...

Thanks Shay. Works perfectly.....

Can I tie several option buttons on a form, into a single field in a table (i.e. depending on which option button is selected, that will set the value in the table & visa versa)? Thank you in advance...

Is your invoice report based on a table or a query???

Is your invoice report based on a table or a query???

In order for the code to work, the report needs to be 'associated' with the same table that your form is. Then, you need the field that your checkbox value is stored in (cboPreNoteType) on the report. You can set the visibility of this field to 'No' if you don't want it to show up on the...

I have something similar, this is the code that I have for the command button, and I have never had the report open in design view. Dim stDocName As String stDocName = "Report1" DoCmd.OpenReport stDocName, acNormal Good Luck

Go the the Detail Section Properties in your report and click on the Code Builder in the On_Format Event. Enter the folowing code (adjust as needed to fit your exact application). If Me.Box1 = "Text1" Then Me.Check3 = -1 Me.Check5 = 0 Me.Check6 = 0 ElseIf...

Check the Table/Query that the data is being pulled from for your report. Are you sure that the Size field is entered for every record?

If you code was always the same number of characters, let's say four, then you could use the LEFT function to truncate your entry, and compare to your list. However, since the code can be of different lengths, I am afraid this one is beyond my capabilities. Sorry, and good luck.

Is your code always 4 characters (i.e. "HP-A")?

BAzZ, Try this, just fill in your own information where applicable. If Me.Combo0 = "Your Choice" Then Me.Text3 = "Your Result" Else Me.Text3 = Me.Text3 End If You should be able to manual update Text3, and it will only be overridden when the Combo0 condition is...

BAzZ, What I meant was to keep the code in the Form_Current as well as the After_Update. Then use the IF statement to determine if you actually want to code to run and update Textbox4 (If [Land Trust] = "Your Condition").

BAzZ, In that case, I would leave the code where you have it, but modify it to only update textbox4 when the condition on textbox2 is met. If [LandTrust] = " ???? " Then [textbox4] = " ????" endif Try something similar to this... Good Luck,

BAzZ, I appoligize, I miss understood that what you wanted. However, by having the code in Form_Current, it will overwrite anything that you manually enter in textbox3. What are the scenarios when you want textbox 3 to be filled. By your last response, I am assuming that one is when you add...

Thanks againg Pat....

Icline, How are you defining CStr?

fmm, My bad. I had the: tempNew = ![New Parts] & tempIG = ![IG Number] on the wrong side of the With rst statement. When I moved them, the code ran fine. Thank you for your help!!

fmm, Thank you, but I tried that one. When I ran the code I got: "Compile Error: Invalid or unqualified reference" Any other thoughts???