Search results

No. I haven't. I can watch YouTube videos from my computer with sound. Even other applications are sending me notifications with sound.

Hello, I have a button to save my data. Before save procedure runs I have a Beep in my code as follows here but it doesn't create a Beep sound. Is there something that I've missed in my VBA code? I also tried to do the same with Macro Builder and got no beep sound. Private Sub btn_save_Click()...

Very informative comment. Thank you. Just for my curiosity how much is that Code Signing Certificate? Installer is required even if the host computer already has MS Access?

As you were guessing, Access has no "Protected View" in there. Then I tried to add a trusted folder. The folder is added to my local computer here but what about people who don't know or want to do such operations on their computer before they open my application? It looks like I have to...

Thanks for fast respond. I will try it and get back to you.

Hi everybody. I have a database that I want to send it to my friends so that they can use it. I realized when I attempt to open it for the first time on another computer this warning appears. I know I can enable it easily by clicking on the button in the message bar but since my database opens...

Thank you for your help.

Now the query works fine. I am trying to use that field of the query (Expr2) as a source of the same field in my report but it gives me error. Expr2: IIf([place_detail]="Home","DOESN'T APPLY",[place_detail]) My mistake was a typo at the beginning. I had iff instead of iif. Sorry for my mistake.

I used your code in query design. Now it is showing all the values where changed to "NOT APPLICABLE". It is doing the "true" part of the statement properly but the "false" section remains blank, returns nothing. Please see the snapshot:

No. I was using it in expression builder. Let me try it in query design and get back to you.

I did. Exactly same errors displayed.

Thanks for respond. I applied your changes but it gave me errors next to the control in design view and when I ran it it goes into a circular prompt to enter "iff" in a dialog box. Invalid Control Property Circular Reference I was thinking of using Conditional Formatting but it is used to color...

Hello, I have a report based on a query. Query is in order based on a table. I need one of the fields in my report shows "Not Applicable" when a criteria is met. I used this code in expression builder but it didn't work: = iff("Home","NOT APPLICABLE", [place_detail]) I was trying to say if...

I actually didn't use any code. Since I had "--Select One--" as one of my items in underlying table it was displaying it in the middle of the list. I added a space at the beginning of the word " --Select One--" so that brought it to the top of the list when items were sorted ascending. This is...

Yes I did. I fixed it already. Took me more time and I had to go to work but I finally finished it this morning. Thank you for responding.

I am still waiting for help to arrive. Is there anyone who can help me about this?

Hi arnelgp, I saw your sample . I appreciate your effort helping me on this issue. I spent time and couldn't figure out how to do it. Unfortunately I couldn't apply your method to my case statement function. Could you please help me to apply your method using following function and case...

Hi, I am using two columns of my combo box here. I use column (1) for a variable in riskRate function and column(0) to be in my Recordset and will be written in main table.

Hi. Thank you. Your code and modification generates "Run-time error 13". Is there anything I need to do in my side? MajP; Which field in my table? This is not a field in my table but it is a variable used in another function called riskRate. I am going to work and will try more when I am back...

I understood. Before I select anything it shows empty combo box and that's where I want to see "Select One" on my combo box. A copy of DB is attached and if you have time please look at it. Thank you in advance