Recent content by brichard

hello I am looking for a script to replace all accented ISO 8859-1 characters with their equivalents in a textbox in excel. After entering text in a textbox, I would run a script replacing all accented characters and symbols as follows: ö -replace-> ö © -replace-> © Would you have an idea...

I have found the answer: financial_year: IIf([invoice_date]>CVDate("5/4/" & Year([invoice_date])),Year([invoice_date])+1,Year([invoice_date]))

Hello I would like to create a query to see what transaction has happened in which tax year. Transactions -Transaction ID -Invoice date - dd/mm/yyyy -Tax year yyyy Tax year: calculated, as follows If Invoice date is between "Invoice year"/06/04 and "Invoice year +1"/05/04 then = Invoice year...

Thank you John This looks promising, but the queries containing references to tables I can't see in the database. I can see it is working, but not getting the concept behind. Something like "we are looking for the Dmax value of the numbers filtered based on the selection and adding one to that...

Hello I would like to ask your help with auto-numbering. My database contains project details. A unique number is assigned to each project. When adding a new project through a form, I would need an automatically entered project number based on which partner is selected. The project number needs...

Hello I need to get data from an online mass mailing service through SOAP and update an Access table with the data. Here id the SOAP request I need to use. http://api.jangomail.com/api.asmx?op=GetUnsubscribeList I need to download this unsubscribe list on a daily basis and append it to a...

I have changed my IDs to numbers instead of text as of your recommendation (50+ relationships). Now my queries are leaping up with a touch, like frogs in a dynamite pond.

Sorry, I wasn't clear enough. The context of the mail merge is related to the following: -class of the student -primary language of the student -financial category of the student Need to filter the database to only get the students -attending certain class/es (done) -their primary language is...

Only one, it's their primary language. Thank you for the modified export code, implementing it now.

Now it's perfect, thanks a lot! I have an other table tblLanguage LangID - 1, 2, 3 Language - English, French, German No other values, only this three. LangID is a foreign key to tblStudents Would like to add this same way as we did the classes. Also one question about the export to excel...

It works! But if de-selecting everything to zero selected value, I have the same error message for .Form.Filter = strFilter Thank you for both of you for the advice, I will consider a new design. I am wondering if I can add an other listbox following the same procedure or they would...

In my main database I got the following error when trying to select items: "Runtime error '3464' Data Type mismatch in criteria expression" for the line: .Form.FilterOn = True I suspect this is because my IDs are texts, no numbers. Is there a way around or do I need to change them to numbers...

Thank you :) Office 2010, everything

Thank you for helping me with this. All of your versions are great, but for my task the one in #11 is the most suitable. I really don't want to abuse your time, but moving forward I am facing even more issues and would be grateful if you could have a look at the following: Some students have...

This is amazing. My brain is too flat for today, will try to implement it tomorrow morning and get back to you.