Search results

It's what you want, either you sort on the ID or you sort on date? or use the Date/time format to sequential sort the query.

That worked perfectly!!! Thanks

Hi Steve, I can't use a Macro as I'm doing all kinds of things with the data. The Excel.xlsx does not contain any macro's where the Excel.xls and Excel.xlsm can. So I think the fire wall on the application is blocking all potential harmfull files.

Well Ofcourse, this is what I've used in the past that worked: excelApp.ActiveWorkbook.SaveAs strTargetFileName On Error GoTo Errorhandler DoCmd.SetWarnings False strTarget2File = Left(strTargetFileName, Len(strTargetFileName) - 1) Rem excelApp.ActiveWorkbook.SaveAs strTarget2File...

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 rewritten the report and the problem did not show up again?? Very strange!

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

Please find attached two files one print screen of the report and a pdf of what I get. The full text is: Controle Phoenix Controls regeling voor het BSL3 labo V229. Tijdens de controle is gebleken dat het controlerboard van de POC regelklep van de sluis niet onder spanning stond. Mogelijk is...

Hi, The data is truncated. it's just 2 lines and a bit while the whole data is over 4 lines.

Hi, I've checked the settings, but the Section was set to can grow = yes. Any other ideas? The report is part of a very large database, how can I provide you with the sample of the report?

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

I've installed the older version that worked fine!

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?

the DLookup worked fine!! thanks

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

Hi, I've changed the DSUM to: TotalExpenses: DSum("[queExpensesOpen]![ExpDeclarationValue]";"queExpensesOpen") Found the issue!

Hi, This does provide better results, but it does not line up with the checked results. Is there a way to check what records the DSUM has used?