Search results

I've been working on a large database. I have to export some data as an Excel file . so far I've used the Excel.xlsm format as their where Macro's on the file. Recently I've had some issues with some clients not receiving my files (due to their Outlook settings I presume, deleting the e-mail as...

Hi, I need to make a comprehensive line query of our order book. The query should list the following Order number (easy) Order description (easy) Order Value (easy) total Invoiced value (multiple invoices) Total cost of time spent (multiple visits) Total cost of mileage (multiple...

I've created two query's generating the total order value and total invoice value for a year. The query is fine and generates the correct value. Now I want to display these values on a dashboard providing me an overview of my year to date results, but the values are not displayed but an error...

Hi, I've made a report with 3 Large Text fields. When I fill the report I can fill in all data as required. When I want to print the data, only part of the data shows in the print out. I've set the fields to grow and shrink. I've plenty of room on the sheet, but it just does not show up...

Hi, Today I had to reinstall my office 365 after getting rid of Windows 10 from my system. Now it turns out my database is missing some files of links, I don't get it. It has been working for months really good and now it plays up. It most have to do with the reinstallation. After opening the...

I need a conditional format on a report, depending on the type of quote I want to show or not show some fields. I've programmed a tempVar to achieve this. If I test the value it works fine, but when I run the report I get an error: Can't find the methode or member, what's going wrong here...

I have a form based on a table. The moment I open the form and change one value, a record is created in the table. I don't want the record being created after the first field change, but only after the last field has been changed. How can I arrange his to happen?

I'm trying to retrieve a value from a query and put this on a form. In order to do so I've build a query that provides me with the correct data. When I put the query to work in VBA it provides me with error 3061, to few parameters. strSQL1 = "SELECT DISTINCT TOP 1...

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 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...

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...

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...

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...

I want to see the data in an unbound calculated field change after I've changed the value in one of the calculations. How can I do this??

I have data copied to an excel workbook. In the book I do some pasting of values. These are copied by formulas in another sheet. To get rid of the calculations I want to copy and Past the values on the same sheet. That's where things go wrong. Set sht = excelApp.ActiveWorkbook.Sheets(1)...

Hi, On an invoice I have a selection field Language referencing a table with Languages. I store the LanguadgeId in the field. While making the Query to print the Invoice I need to select the Select the The Invoice description from a table that has the translations in the fields. How do I...

Running the following recordset generates an error 3061, to few parameters. When I run the Query by inself it does run and generates the required single opject I'm looking for. What do I need to do to solve this one?The problem is in the Where clause with the TempVars. If I delete that, it runs...

Operator missing error I've set up a query to filter the results of the second Combobox. this works fine it I write the code by hand. When I use the query with a variable, it does not work anymore. the problem is probably the where clause, so I focus on that one: "WHERE tblCompany.CompName...

To save and send a report I use: DoCmd.OutputTo acOutputReport, "rptReportName", acFormatPDF, strFullCurPathFile, False The variable strFullCurPathFile is the full path and file name where I want to have the file: "C:\Users\...458\CES3458.pdf" I do get an error processing the line: Error 2059...

I've found some code to find a directory with a browse function. It comes down to the next line: sBrowsingPath = strDefaultFolder Set objShell = CreateObject("Shell.Application") Set objfolder = objShell.BrowseForFolder _ (WINDOW_HANDLE, "Select a folder for exporting...