Recent content by mach27

never mind, I read from another forum that activeworkbook.name is what I needed.

Hi experts Please have a look at the scenario below in which I want to know the filename where the macro is activated. Here's the scenario: 1. A macro is saved in Book1 2. The macro is activated in Book2 Result: The macro should prompt the user that the filename is "Book2" regards, mach

Hi HarlyQuinn I use the vbOKOnly most of the time as majority of the message box gives information to the users. I will just change my button set to vbYesNo to disable the close button. cheers, [glasses]

Hi HarleyQuinn: I don't want the users to have an alternate way of closing a certain message box as doing it won't process some procedures. Hi PHV: Where should I put the "DoCmd.SetWarnings False" ? Cheers [glasses]

Hello experts Is there a way to disable the "close button" of all the message boxes? If not possible, make it all not visible. I've read other forums and I can't find any solution to what I want to do. Cheers, [glasses]

Thanks Duane, it works [medal] regards, [glasses]

Got it Duane, thanks [medal] Is there a way it can be transformed into a code? There are a lot of text boxes that it will be applied, doing it one by one will make it hard for me to track once there are changes to be made. ::-)

Hi Duane Conditional Formatting is limited to the value or expression (formula used) of a certain textbox. What I want to do is that the textbox color of a certain field will be dependent to the value of another textbox. [smile] Regards,

Hello Experts My question is how to change the color of the textbox based on the value of another textbox? Example: Textbox color of 'AOP' field will change to 'Red' whenever there is no value in 'ROP' field. regards, [morning]

[2thumbsup] Thanks PHV Your solution works. [glasses]

hi lespaul Table 1 (above) came from the comparison of 2 tables Table AOP Submission Jan Feb Mar Apr ... Dec CB00002402 10 CB00002538 13 2 Table MPO Submission Jan Feb Mar Apr ... Dec CB00002402 1 10...

Hello Experts, I am having a hard time understanding other forums if it has any relation to what I want to happen. I have a table which is a result of an append query where it appends the value of each month. 1 'Submission' may have multiple entries. Table 1 Submission MType Jan Feb Mar Apr...

Hi Greg I'm having a problem with this part: mpo.Submission_ID = mmr.Submission_ID and mpo.Request_Date = mmr.Request_Date It gives me an error message of "Syntax error (missing operator)in query expression" [peace] Mach

Hello Techies What I would like to do is to compare some entries of the table to another table to check if they have the same value, here's my condition: If the 2 entries being compared will not match, the result will be posted to the 3rd table using the entry of the 2nd table. If the...

Thanks guys, each solution works. /salute