Search results

Hi I use this beat of code and returns the results i wish. If country - "China" then msgbox = "something" elseif country = " Japan" then msgbox = "something else" else msgbox = "something more" Endif I would like to add the "and" and make the code as below but the syntax is not...

Hi, since i am the exclusive user, no , there isn't any FE, BE. I will implement this in 2023 db

Hi, .accdb (not mdb, (.accdb) I use memory stick because this is the most convenient, i work from office and home., Yes i know , there is a risk if disconnection but i can't find any other safe way to work. That's why i am full with backups.

Hi there Thanks for your input. I have fixed my database. After she crashed, I continue working with a backup that was created just before corruption- no data or workflow loss but I was afraid that I am working on a minefield since all backups would have inherited the corrupted records and...

Hi, i have removed all relations from ALL tables since i didn't know which table/tables causes the corrupt. I still got the I get the error "id is not an index in this table" Then i deleted ALL data from ALL tables , still I get the error "id is not an index in this table" plus another error...

Hi there My database crashed, doesn't open anymore. I get the error "id is not an index in this table" Then i continue on the back up, i lost no data but i am afraid . that the backup database, has inherited all the "errors" from the original one Is there any way i could find out and fix the...

Hi , in my outlook account, i host two email address. The personal and the business. When i use the docmd.send object method from ms access, then the outlook captures as default email sender the personal email address, then i must change the sender to business email manually. Do you happen to...

Hi everyone I have found and created the below code in which we can convert an sql statement to VBA. I have added my owb line which i just want to replace the ' ' S = Replace(S, "'", """") Now, the question is , if we have a very very long sql statement, how could we break it into...

Hi, i will go through this one later today, if one hour long, i need a weekend .

Yes, but this will allow export as RTF document and several report properties will be gone, the document won't look the same

I have back up, however, is there any way we use just ONE application? I may move the application to another driver, for example.

Hi there, with the code i display below, we can export data from access to excel by using VBA. In this link, someone can find the sample database. https://www.access-programmers.co.uk/forums/threads/extract-excel-from-access.324274/ I need to do the same with MS Word. I need to export data from...

Many thanks Arnelgp I got the point, i will test it and i am sure i can adjust it to my real environment

Here you are our sample database In the same form, there are two buttons The first button returns the desired results and it is there just for back up On the second tab, i have added the piece of code you wrote and indeed i get the same report with a second tab. The question is how to bring in...

@arnelgp This is a new thread, continued from this one https://www.access-programmers.co.uk/forums/threads/format-multiple-currencies-based-on-a-value.324037/ but since subject has changed, i open this new here. With the below code, we can retrieve from access tables, one report in excel. One...

Hi arnelgp With the below code, (the full code can be found in previous post) we can retrieve data from any access table/tables and build ONE excel with ONE spreadsheet. What syntax should we use if we want to build ONE excel with TWO or more spreadsheets ? Then, with the syntax, "With...

Hi, in the attached file, there is accdb with one table, one form, one button , behind the button is the code you have helped me to extracts the excel. We want, at the bottom of the report, at cell C8 in this example, the sum of USD , cell C9 the sum of Eur.

Yes but the currency S or E, now is not listed in any column, it is only as format in the cell. So, I can't tell to the code, sum up this column if the value in that column is S because that column doesn't exist in the excel. Okay, i could list that column and do it , however i change the...

Hi, There is a code from which i export excel report from access tables. With your help, the task works just fine. The last detail. I need to apply "sumiffs" at the end (or at the top) of the report With the below piece of code, i can do it if all parameters are displayed in the excel...

Hi, The tables behind form subform are linked through id and fld0, not appeared on the image. User can relate form subform with a second pair of fields, such as field2 to fld2 on top of id-fld0 but IF i change the field2 then we get "orphan" records that disappear. Dlookup from subform...