Search results

Howzit THis should work. Put formula in cell H2 =IF(COUNTIF($B$2:$B$25,B2)=SUMPRODUCT(--($B$2:$B$25=B2),--($G$2:$G$25=G2)),1,2) The formula broken down for informational purposes: Count the number of orders relevant to the current row - Put in I2 =COUNTIF($B$2:$B$25,B2) Using SUMPRODUCT...

Howzit Try the formulaR1C1 to populate excel using vlookup. In this case I Select the range Populate the range with a vlookup, using the iserror function in case of errors Copy the range Paste values - basically to keep the size of the file down ' Get some data using vlookup...

Howzit This is the syntax that has worked for me. You need to make sure you reference the excel library. I have a working example at home but I do not get home until Friday. Re: intMth = WorksheetFunction.VLookup(strmth, myRange, 2, False)

Howzit In D5 fry this formula =if(c5="item",mid(a5,6,len(a5)-21),d4) This will use the part number in the previous row until a new item is found

Howzit Outstanding and glad to help

Howzit THis is what I use to send an email with Outlook. You will need the Microsoft Outlook 11.0 Object Library selected in your references. You will need to modify it to pick up the correct email address for the order andthe email content etc. Option Compare Database Option Explicit...

Howzit See this for a discussion on the problem and where I got the potential solution.

Hi George This is how it works in 2003 as well. Try setting the default value for MName to "".

Howzit What is the SQL underlying the report? It may be just the date format that is causing the problem. You may think you are querying March 5 (5/3/2012), but Access may be interpreting it as May 3 (3/5/2012). Edit: Sorry Spike didn't see your post

Sorry - I am off now for the rest of the day. If you have oither questions I am sure someone else will jump in otherwise I'll pick up again when I get back.

Howzit As an example I have a table called tblCustomers, with fields holding CustId, CustName, SalesTax... When I create a new invoice for my customers I select the CustID and populate the SalesTaxID in the Invoice table using the After Update Event Procedure me.SalesTaxID =...

Howzit The syntax looks correct but you may find that you are having trouble with Reserved words. Name is a reserved words so you should avoid using this as a field name. Also when you refer to Me.Name this will refer to the form name, not the control on the form called name, which is...

Howzit Do you also need to specify the closing column? Something like FolderPath & "\[" & ReportWB & "]Data!R1C1:R" & Count5 & "C7", _

Howzit Thanks linq - didn't spot that

Howzit I use a solution by Uncle Gizmo to filter my forms - see this post - see post 3 for the latest version (i'm not sure if there is one later than that???). I have had up to 7 combo boxes filtering my data on a mix and match basis.

Howzit When you link excel to access, access makes a guess as to the data type (I assume by the first data row) and everything in that column will be assigned that data type. So even though you may have the column formatted to text if it looks like a number to access then a number data type...

Howzit In the after update event procedure of your advert type control you want to assign the fee using a dlookup. Something like the following: If the advert type code is a number me.yourfeectrl = dlookup("[YourFeeField]","tableA","[AdvertTypeCodeField]=" & me.yourtypecode) if your...

Howzit You want a DLookup to get the results. Put it in the after update event of the control that is entered last (either the date or the class control) me.Text478 = DLOOKUP("[Rate]","Lease_Rates","[Lease_Year]=" & me.Text476 & " AND [Class]='" & me.yourdropdownctrlname & "'")

Howzit No it will not matter that your tables are not SQL tables. You still use SQL to query the tables. Good luck.

Howzit The select statement would work just fine - but you would need to assign it to and work with a recordset to return a value. As an example this should also work - but I would stay with the Dlookup in this instance Dim db as DAO.Database Dim rs as DAO.Recordset Dim sSQL as string sSQL...