Recent content by onur_can

You can transfer it with a command like this. DoCmd.OutputTo acOutputReport, "ReportName", acFormatRTF, customerID & "ReportName"

Hello For this you need whatsapp api. I have worked on this subject before. I did a preliminary study. But when my client gave up on having his program done, I stopped working. I am giving you the site address that contains the information I found about WhatsApp, you can review it. whatsapp...

In conditional formatting, especially if you have more than one rule, you should analyze them very well and sort them. So if you know a bit of visual basic, you should edit it just like you would use it in if...then...else...endif blocks. When comparing multiple conditions in an if block, you...

Open the query on which your report is based in the design window and refer to the criteria part of the relevant criteria field in the drop-down box on your form.

If I heard that such an access tournament was organized, the first thing I would do would be to buy a ticket immediately. Even if I couldn't participate in the competition, it would be fun to watch.

another way is to put the column you refer to in the first row of your query in the row source of the combo box. this way, you don't apply for a column, you only refer to the dropdown box itself.

I'm sorry, I guess I misdirected you with the information I gave. Type the following code on the command button that opens the report on your form and it will be fixed. If you want it to fill the full screen Private Sub cmdPreview_Click() DoCmd.OpenReport "CounterInformation", acViewPreview...

try this way (open event) DoCmd.OpenReport "report name", acViewPreview DoCmd.Maximize DoCmd.RunCommand acCmdZoom100 You can change the value of 100

Add the following code to the open event of the report DoCmd.Maximize

Hello, your answer can be the following SQL statement. SELECT Table1.id, Table1.producname FROM Table1 WHERE (((Table1.producname) Like "*?6x1,?*")) OR (((Table1.producname) Like "*?6x1*"));

Welcome aboard, Seruz, many of our friends here are knowledgeable and qualified, your questions do not go unanswered. I believe you will benefit greatly from this form.

You have written the command that opens the form when there is no registration. Of course it will open. Use Exit Sub instead of this command. DoCmd.OpenForm "MRN_Query1_Delivered", acNormal, , " [Item Code] = '" & Me.List6 & "' and [Location - Clinics Code] = " &...

Although we log in with the password and user name in the access forms, we cannot achieve full security. The safest way to do this is to set a password in the Set database password section of Access and distribute this password to users.

Hello link here may help https://accessapplication.blogspot.com/2019/03/sql-datediffparametreler-iki-tarih.html

Dear The_Doc_Man, you have made a very good explanation.