Search results

I also agree with Pat Hartman. I never like to try this solution suggestions. You must give precise instructions. The solution to this problem looks like this.

Since each ratio is different, it would be pointless to deduct the repeated dates. Then it will be incomplete in your query result. You can adapt the same information you have provided in your excel example above to the access table.

Thank you. isladogs for the information. I updated my message.

First, make your formatting in the excel table you use as a template and save it, then transfer your data to this excel template file. You can go the shortest way this way. (Excele Data Transfer from Access)

I also don't like tabbed documents or forms. I change this option to overlapping forms with every application I do. I believe this gives users more flexibility.

Then your Table2 should be the one on the left. In this case, you must add Year to Table1 and create 1 to many relations in between.

Check your tables in your current application, open them with the old version and convert your large number data type fields in all your tables to number type. After doing this, your application should be opened.

In which access version does your application run regularly, in which version do you get an error message? It probably works in the old version, if not in the new version, it may be due to differences in data types. It is necessary to examine and analyze DB.

Records are missing due to placing your fields in Header instead of Detail.

VALUES ) Do you think the red brackets are correct? Minty seems to have fixed this issue.

VBA's default Font is Courier New. But this font also differs from 1 to l. but it looks the same. It looks obviously different if you set the Font to Arial if you want.

Have you created msgbox under the error handler?

Yes, I also know that the design is not good. But the user does not want us to examine the design, he just talks about a negativity in his form. He wants the solution to this point. If it were up to me, I wouldn't design it that way.

I made an example of 2 fields on your form and you can apply it to others. It is due to your painting design being wrong. I created a table where you can use yes / no fields and linked it to the relevant fields. The number of options is not limited to Yes / No, you can add another option to this...

I deleted the file I was working on. But after I download and edit it again, I will add it here.

I tried it on your vt. and I got a positive result. As you said, -1 and 0's came out. Yes or No fields appeared when I opened it later from the form.

It caught my attention now! You have defined your Yes / No fields as Short Text for Why. Shouldn't you define it as Yes / No? Change the data type of yes / no fields in your table from short text to Yes / No and recreate your form, the problem will be fixed.

I tried it does not show any problem but Would you try by setting the Show only row source values value to Yes.

Currently, there is no mobile support for microsoft access, so if you will have access, you will need to work on Web access, otherwise turn to similar programs that support apk.

I agree with The_Doc_Man. Gives this error due to inaccuracies in domain names.