Search results

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.

:D It's a bit complicated for me, so I have created this template database (attached) and once I do understand how is it working, I will move on to the main one. Where should I insert this? SELECT * FROM tblStudents INNER JOIN tblStudentClasses ON tblStudents.StudentID =...

Hello Sparks80 Thank you for your prompt response. Can I make multiple selections in a drop-down box? I would like to be able to select multiple courses from the available 70, need to have an option to select 0 to all courses and get all students attending any of the selected courses. I will...

Thank you Pat I knew something was wrong, thank you for pointing me in the right direction. The tables look like this now: tblStudents StudentID (autonumber, primary key) FirstName LastName tblClasses tblClassID (autonumber, primary key) ClassNum ClassName tblStudentClasses StudentClassID...

Hello Could you please help me with the following issue? Please see a simplified version of my database below. (The tables are containing hundreds of records.) STUDENTS (record1) id - 1 name - student1 course1 - 101 course2 - 102 course3 - 106 course4 - 109 course5 - (blank) (record2) id - 2...

I had typos/wrong format, your version is working! Thank you again, it was a big help.