Search results

1. Thanks a lot for the changes made. In the new base type I have 205 text for each category and not 250. When deleting the existing entries from the qryDelHoroscope table when you open the form and pressing the last date button, it automatically takes 17 days with horoscopes. We have 8.05.2019...

1. I attach the last database file to view it and I will try to add all the new codes myself to test if they work. 2. Прикачвам последния файл на базата данни за да я прегледаш и ще се опитам сам да добавя всички нови кодове за да тествам дали работят.

I have 205 texts for each category, but this texts repeat for 2 or 3 days in random zodiac...

1. Can anyone tell me where to make the changes in the code and exactly what to do, so there will be no repetition for 9 days and after the ninth day the texts will pass from one sign to another? 2. Някой може ли да ми каже къде в кода да направя промени и какви точно, за да няма повтаряне за 9...

1. Again, I have a problem. One text of one sign and category is repeated after 2 or 3 days in another zodiac and in the same category. Can not repeat any text for 9 days and only after 9 days pass from one sign to another? 2. Отново имам проблем. Един текст от една зодия и категория се повтаря...

1. I fixed it. I understand where the problem was. Thanks! 1. Оправих го. Разбрах къде е бил проблема. Благодаря!

1. Благодаря. След като създадох нова дата в календара ми ги разменя без повтаряне. Това ще работи ли без ограничение за датите ? 1. Thanks. Once I created a new date on my calendar I exchanged them without repeating. Will this work without limits for the dates?

1. The code is correct and I tested for a new horoscope from today and again repeats the same text from one sign and one category in another sign of the same category, but different combinations should be ... yet it has a database of 615 text for all categories Love, Work and Finance ... Can it...

If you have many texts in the daily horoscope, there is no repeatability for any sign. Even in this document, where there are 90 texts common to all categories there is a repetition of the texts in the different signs: Aries -->Sagittarius; Cancer -->Capricorn; Gemini --> Virgo - Love Repeat...

1. I fixed it. But now I have another question that is important ... I choose to make a horoscope for me on 03.05.2019 and it shows me the same texts in the different signs ... but I have 205 texts for each category ... why the shuffle does not work ? 2. I think the problem comes from a table...

I do not have this menu "Sorting and Grouping" and does not allow me to add it :(

1. Thanks again for the work done! I changed the codes to the places you told me and the buttons are already working. However, there is a discrepancy between what appears in the form and the printed version. Shifts the signs and does not arrange them as they are one after the other ... Can this...

I am very grateful. I personally thanked him for everything, the question is to tell me what to change because I do not understand you ... :( This is the Code that does not work: HasDate = (DCount("*", "tblHoroscope", "HoroscopeDate = #" & Format(theDate, "MM/DD/YYYY") & "#") > 0) And this is...

Can you change the base code to work for export to the documents and not give this error, because I do not know what to change and send me here if you can? Download the latest attachment: Horoscopes_V2

This also shows me the error, so the export buttons do not work in a Word document. See the picture. I tried to change the codes but gave me a mistake. Can anyone help with the correct code to work. Thanks in advance.

Which of the two codes is the correct one and which three places will I replace it to work with the buttons?

Which one and where exactly will I change it?

Is it at all possible to avoid giving this error for the dates? And why two export buttons to the documents do not work?

The buttons on the form do not work after pressing ... After pressing, he writes an error: Run-time error "3075" Syntax error in date in query expression "(HoroscopeDate = #04.25.2019#)"

I will try well. And how do I do with the template, as I showed it in the picture?