Search results

After I've added an invoice, I need to create a report sending the Invoice details to the accountant. In the report I need to mention the percentage invoiced to date, not including the last one. This is on a subreport, but I need to prevent the last invoice to be added to the list. I know what I...

I had this in the Page footer, not in the report footer!!

InvoiceValue is not a calculated field, it's a table field. I've tried to sum up in the query, but it does not want to do that as well?? It's not the name of the field, it's Tekst14. How can I use a hidden field to keep the running total?? How can I sum the total of a calculated field, I do have...

I'm trying to add up the total for individual invoices sent to a client. I've set the subReport to work out the calculation in the report footer as =SUM(invoicevalue) The idividual values are correct, the summation gives me back an #Error Please advise

Thanks, That worked!

How can I automaticly update my exchange rates in an Access database. I know there are sites out there that provide current Exchange rates (like XE Currency Converter), bu ti want to automaticly update my current exchange rates so I don't have to type them each time over. Anyone been there...

How can I declare a Thread as SOLVED?

Hi Gizmo, Indeed it is. I've implemented it! Thanks!

Hi Gizmo, Thanks for your reply. I'd seperated the steps, and found the solution for the default save Directory. I've not implemented it as priorities shifted!

Hi, I might have been not exactly clear. I'm filling fields in the tblOrder by a form, frmOrderAdd. One of the fields I need later is the excDefaultID. this guides me to the current exchange rates defaults. I don't want to fill in the ID number, nor do I want to select this in a drop down, I...

Hi, In my effort to reduce the input for my user as much as possible, I'd like to use as much default values as possible. Now I want to set the default value for a field to the last record of a table. How can I do this on the form. I assume the code has to run when the the form opens or...

I meant I want to save my files in default directories, so one directory for 2015, one directory for 2016. in 2016, 12 directorys for each month one directory. I want to be able to automaticly create the directory if it does not exist and I want to automaticly save the file in that month for...

Hi, I've just downloaded the sample database Browse [Find a directory or file], 97787 browse I do like the set up of it, but I need to use a default location as that is based on year and month. Can I use a string that would land me on the default location first?