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

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

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

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

Hello All This is my first post on this forum. I have found some very useful information here to complete this task, but being a noob to VBA, can't put the pieces together. (Sorry for the wording, English is only my third language.) Your help is much appreciated. _What I would like to do_...