Search results

I'm trying to generate a total sum in Invoice report. It does not seem to collect the right data. Can I use multiple Criteria in a Dsum? TotalExpenses: DSum("[tblExpenses]![ExpDeclarationValue]";"queInvoiceExpenses";"Month( [tblExpenses]![ExpDate] =1) And [tblExpenses]![EmployeeID] =1")...

Hi Linq, worked like a chame!!!

No, It provides me with the same error. I can see the Where clause is converted fine.

I want to copy the record as there is just a minor difference between the first and the second. After copying the record I'll edit it and correct the difference. I've removed the ProductID field , but the result is the same, the translated message reads like: in the Query INSERT INTO you can't...

Hi Guys, I'm trying to copy a record to a new record and copy ALL data from that record. What I've found so far is the Insert Into, append query solution, but I thought there should be an easier way to do this as the record has a large number of fields. The SQL code does not run and I can't see...

So if the WHERE claus is the same as the Where clause in the selection, It would be fine. I assume I can update both fields in the same DoCMD as that would change one of the factor in the Where clause, like below? DoCmd.RunSQL "UPDATE tblMileage SET MileageClaimed = {the value} SET...

Yes, the report can be produced via VBA. I do have to find the details, but I think I'll run this from a centralizes file library. I'm reasonable familiar with VBA, just don't know enough of the details

Hi Guy's How can i run an update query after I've ran a report for for instance mileage reports? To explain more clearly: SELECT tblMileage.EmployeeID, tblMileage.MileageDate, tblMileage.MileageDetails, tblMileage.MileageDistance, tblMileage.MileageClaimCost, tblMileage.MileageClaimed...

If I'm not mistaken: The part within () runs before the main query is executed? I think that'll sort my problem best.

Hi Arnelgp, I'll give it a shot in a test. I assume this can be part of a larger database as well? I'll check out the Dsum() on this forum. I think I'll find lost of information about that. Just did not know this was the function to use. Thanks

Hi, A sample set is not simple as this is part of a very large database. I do have the potential to order the data as in almost all tables I have the posibilety to add the order ID. As I need to do this on many tables, the qustion was intented as a general one. What do I need to do to...

Hi guys, I've to make a running sum in a query that makes a value based on exchange rates. Meaning I have to calulate a GBP value first and than add up these values to have them displayed on a form. I have to do this for multiple tables as I have to store multiple fact's, Labour, expenses...

And indeed that solved it!!! THANKS!

And indeed that did it!! thanks very much, I've been looking for a while, and so simple solution!!

Can anyone explain why this code generates an error 438 every other time on the past line? Function DataToExcel(strSourceName As String, Optional strWorkbookPath As String, Optional strTargetFileName As String, Optional strCallingForm As String) 'Use this function to export a large table/query...

Hi JHB, I really appreciate your patience with me. Problem is, it still crahes every other time on the past line. The copy line works fine all the time. The past line provides me with error 438 property or methode not supported. I can't find out what's causing it.

Oops! I'll hav a look! But it does not explain why it's running the first time but is generating an error the second time it's running!

Yes, There is in principle no difference betweeen With Selection .Copy .PasteSpecial Paste:=xlPasteValues End With and: Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Why do I get an error message, on both codes by the way: Object variable or block variable with not set.

I must be doing something wrong as the copy past routine is inconsistent. It Always works the first time. The second time it Always crashes with a the message: Object variable or block variable with not set. The Excel file is closed 100% sure. I don't know what's going on. thit is the part...

Hi, Indeed I'm copying the page over its own, but now without any calculations, just data!! Just two other questions, This information, where can I find this, is there any source I could find for this to improve my scills? Second, can I use this to save the current workbook with a known...