Search results for query: *

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

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]

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]

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...

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...

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...