Search results

Hi i'm trying to get a count of all the different lengths of products in my table. I have two columns in the table Site & MaxLength. I want to somehow break up the lengths into increments such as 0-7.999 metres, 8-9.999 metres, 10-12.999metres, 13-14.999 etc then get a count for how many times...

Hi, I am having trouble with getting an on click command button to work on my subform. When clicked it is supposed to run the hyperlink command. I've got the same code on my main form and works fine but on my subform you click the button and nothing happens. Can someone tell me where i'm going...

ok I have now correct, thanks again!

Thanks very much Bob! I had to make a couple of changes to get it to work. see below. Private Sub CmdSwitchMain_Click() On Error GoTo Err_CmdSwitchMain_Click Dim stDocName As String If CurrentProject.AllForms("frmContract").IsLoaded Then DoCmd.Close Else DoCmd.Close...

You say it returns a boolean, does the code still go on the command button that exits the form or do i have to put it on a boolean then write an if statement? Sorry i am a bit confused.:confused:

Hi I got this to work, just had to change dim customer number as string rather then integer.

Hi, When i click a command button to close frmcarriers i want to check if frmcontract is open, if it is open then just close frmcarriers. If frmcontract is not open then close frmcarriers and open frmswitch. The current code i have to close frmcarriers and open frmswitch is: Private Sub...

Hi just tried this but got an error message saying "overflow"... does anyone know what that means? Cheers

ok need your help again on this same code. Some of our vendors are not setup with Email. So i have added an if statement into either print or email depending on what has been entered int he vendor table. This works fine except i can't get the title of the report to shwo up when the print option...

Thanks Baldy that worked great!!

Success! i had the column count as 1. I changed it to 3 and it worked. But that doesn't explain why i was able to change my code to column(1) and get it to work? I also have another problem now, my filter is not working. The report should be filtered as per cbovendor.column(0) but no filter is...

Oops it is sToName = Me.CboVendor.Column(2) Yes i am aware of that. column(0) = Vendor column(1) = vendorname column(2) = email If i change the code to read column(1) it inserts the vendor name in the recipient line of the email so i'm not sure why it won't work by putting column(2)? Any...

Hi there can someone please help me out with this? It is really doing my head in. I am trying to send a order confirmation report to our vendors. Vendor is selected from a combo box then a command clicked to send the report. I nearly have it working (I think) but i keep getting an error...

I'd prefer not to have to send each one individually. The parameter for the report is in my query isn't there some way VBA can tell it which criteria to enter? Cheers.

Hi there, I have a code that sends my report to recipients that exist in a query. At the moment the report has a parameter query where you have to enter the receipeients name to get the results for that recipient before sending. I want to be able to get rid of this part and not have to write in...

Hi I have a union query with a parameter box used to select the branch (POP) I want to query. I have no problems querying one branch e.g "A". But is there a way i can query "A" & "B" or "A" "B" & "C" or "All"? I have searched everywhere but cannot find a way to do this. Any help would be much...

No good! I can't get it to work. I keep getting a VBA error message, "you canceled the prvious operation" Private Sub TxtInvoiceNo_AfterUpdate() Dim stDocName As String stDocName = "FrmBlockedInvoice" 'Checks the table for duplicate entries prior to passing OpenArgs array if true goes to In...

I have a database where I enter in invoice details. I am trying to get a dialog box to pop up on my form advising me if I have keyed the same invoice previously once i tab out of the invoice number field. Because there are multiple vendors who may have the same invoice number i want to...

All good... fixed now. Thanks!

Hi, I'm trying to get a ExpConnote field in TblExpresPost to be the default value of InvConnote field in Tblinvoice. ExpConnote needs to remain as the default for any new entries in TblInvoice until a new ExpConnote is entered. Can this be done? I've tried searching other sites and I saw...