Search results

No it was not. But is there anyway to control the filename of the pdf ?

Hi All! I have a button on my form that opens outlook, and attaches the report for that form. In the "Attachment:" on the email, it will always read: "Sales Order.pdf". Currently, the button is a VBA onclick event, which goes thru the event and sends it to a Macro. Is there any way that I...

Hey thanks for all your help friends. Turns out I just had to put the Nz([Taxes,0]) in the form unload event and now it works like a mint. thanks again!

Hi all! I'm having a minor problem.. in my form, I hit the "Update" button(code below) and it works fine, but if the taxes field is Null (there are no taxes) the Total does not save when I exit the form. It does, however, when there is taxes. I just don't want my users to have to hit the...

I have a certain user in a specific group, "Sales", I set it so the user can Read, Update, and Insert Data, but NOT delete data. When I go into the program to test it, the user can easily still delete data off that specific table... what am i doing wrong??? any help would be glorious!! thanks

Hi all, I have run into a new problem, I have been updating and modifying my database for some time as the Administrator and everything seemed to be running smoothly. When another user tries to open a sales order form, an error message saying, "You can't go to the specified record" pops up...

HI All! On my sales form, the user will fill out the appropriate fields, but if the user goes to the next sale item, which event would I use to prompt them to do something that they forgot to doa in the first record? Any help would be great thanks

I want to create n New Records and have the serial number be an autonumber that fills in for each record. so it is basically on the fly, we are not worried about the metal stamp at that point in time. I basically need one new record for each unit that we make/sell so each unit has a different...

Hi All! I am trying to create a query to add in Serial numbers. In my Sales Order Details Sub form, I choose the Product, and the Quantity of that product that I am going to sell. I basically want a new form to open after that product has been selected, and in that form I want one record...

Would there be a code that, if a condition is met, then only print page 1 of the report??

I just tried that, it seems to do the same thing, it's definitely not showing up on the report, but still printing a blank 2nd page.

I have it on Load. It makes it not visible, but the last page still prints out as if its there, but it prints a blank page.

Hi All, I am trying to add a code to my report to NOT print a text box if a certain condition is met. It is the last text box in the report footer, and it takes up basically the entire page, I have tried using the: If form!combo122="Sales Order" then Textbox300.visible=false end if the...

and should this be done on the before update event on the form?

Hi all! I've been searching high and low to find the right code for this: In a form, if combo316.visible=true AND combo.316= IsNull Then, i need a message box to pop saying 'Please select a choice for this combo box'. and then go directly back to that form and highlight that combo box...

Hi All! I have created a code to say that when a certain combo box is left blank, and the user goes to close the form, a msgbox pops up saying, "fill in this information" : Private Sub Form_AfterUpdate() If Combo223 = "Inventory Removal" And Combo316.Visible = True And Combo316 = IsNull Then...

Thanks for your help, I played around a bit and found that this code worked perfectly for what I need: Private Sub Combo223_Change() If [Status] = "Inventory Removal" Then 'show this picture' Image318.Visible = True Combo316.Visible = True Else 'hide this picture'...

Hi, I have tried to play around with this code, but nothing seems to be working for me. I am also trying to use vba to show/hide a control on a form. this is the code I am using: Private Sub Combo223_AfterUpdate(Cancel As Integer) If [Status] = "Inventory Removal" Then 'Show Inventory...

Hi Everyone! I am just wondering if it is possible to create a conditional statement either in VBA or the expression builder, to control the visibility of an image on a report. Basically if text187 = "Dan" then I want the image visible. If text187 = "JOHN" then I want the image invisible. If...

Thanks I will give this a try, I am new to MS Access and have not used very many codes in VB, could you suggest what I might need to use, or where I might find some examples of some? Thank you kindly