Search results

Hi there, I have a xls with data in the following format JONES*CAITLIN* LUMIÈRE, 17 08191 - RUBI - BARCELONA Hazle un regalo... 936 973 241Ver mapaVer cómo irMi Agenda JONES, A.** RIERETA, 1 08001 - BARCELONA - BARCELONA Hazle un regalo... 934 412 257Ver mapaVer cómo irMi Agenda I import this...

Dear all, I have lost my toolbar, the one with file edit etc, as you can guess this makes things very difficult, and help on getting back appreciated Thanks Geoff

I want to create a customer in invoice numer in the Format YHN 0000 I have a table which contains details of all created invoices so getting the next invoice number is easy using dmax the problem I have is that if I want to print out 10 invoices out at once they all of the same number as...

I can't seem to get the following to work =DLookUp("[RunningSum]","Central_Budget_Utilities_Data_(Comparrison)_Query2","[Utility_Type] = '" & [Reports]![Central_Budget_Comparrison_Sub-Report_(Table)]!Utility_Type & "') And [Month] = '& Format(DateAdd("yyyy",-1,Date()),"yyyymm") & '") Any help...

I have a problem with the layout of a report (dB atached) There is the main report which contains 2 sub reports 1 is a chart the second is a table. I have never had a problem in the past but I can't seem to get the Chart on the first page with the Utility type Header and the table on the second...

Thank you, you are a star

I have a table which contains the following info Invoice_Number *1005016023-012 *2006139784-010 *2006139861-010 1005986795-065 *1005017101-51 1005017112-046 1005017266-047 *1005017354-048 *1005017508-050 *1005518327-047 I need to remove the * from all records containing it the problem I am...

I know what I need to do, but I cant't seem to get it to work, the current formula I have is Unit_Cost: DLookUp("[Unit_Cost]","tblTariff","[Tariff_Name] = """ & [Tariff] & """ And [Tariff_Date] >= #" & [Month_Pres] & "#") But instead of it using [Month_Pres] as the criteria for the date field...

Now I get the following results Month_Pres = 09/10/2001 Unit_Cost = 0.010012 Should be 0.008540 And Month_Pres = 07/09/2002 Unit_Cost = 0.010242 Should be 0.010012 Any other sugestions Thanks Geoff

You should be able to use a query, group on the book title and use max on the publication date etc Thanks Geoff PS. you will need to have the table with the book name included in your query

Hi there, This is probably me just being thick, but I have a problem with the following formula Unit_Cost: DLookUp("[Unit_Cost]","tblTariff","[Tariff_Name] = """ & [Tariff] & """ And [Tariff_Date] <= #" & [Month_Pres] & "#") It should look up the unit cost related to the Month_Pres eg...

I have a sample 2k2 db, Is there some one out there who could convert it to 2k for me, the file is to big to be attached to the post so I would need to e-mail it to them Thanks in advance Geoff

Thank you, Works like a dream Geoff

This should dop the job Option Compare Database Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim lngLen As Long, lngX As Long Dim...

I use something similar if([jobtype]) =1 then duedate = dateadd("d",10,[receiveddate]) elseif([jobtype]) =2 then duedate = dateadd("d",15,[receiveddate]) and so on Thanks Geoff

I have the following code which creates a report, exports it then creates an e-mail based on what report you are sending. I am having problems with the EmailSend.to part of the code everytime I run it it comes back with the error Runtime error '2465' Energy Reports can't find the field 'Forms'...

Thanks for the quick reply works like a dream, I am never going to get use to the syntax in access Thanks Geoff

I have the following formula, which won't work, I have experimented with the syntax with no joy Unit_Cost: DLookUp("[Unit_Cost]","tblTariff","[Tariff_Name] = " & [Tariff] & " And [Tariff_Date] <= #" & [Month_Pres] & "#") Tariff_Name & Tariff are TEXT Tariff_Date & Month_Pres are Date Any...

I use this to open up a document on my network you should be able to adapt. Call Shell("C:\Program Files\Windows NT\Accessories\ImageVue\kodakprv.exe ""G:\E&S\Energy\em\Scanned_Invoices\" & Me.Invoice_File_No & ".tif""", 1) Thanks Geoff

The data types are fine as when i run it as a query it works fine it's only when I try to run it as code thanks geoff