Search results for query: *

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

This is about importing Excel data into Access table. All Excel data (or sheet) can be uploaded into Access table regardless of the number of fields Excel data has. The imported file will be stored in a table called "Dump_table." There is a specif Excel file that should be used but there will...

Is there someone who can help me create a code to automatically get the timezone the PC is set to?

Hi I have a table of questions and i want to show all its contents in a datasheet view on form. Here how it looks: First Table (Question) QuestNum: Autonumber Category: Text Question: Text Second Table (Questionnaire) RACF: Text timestamp: Date category: Text Question: Text Answer...