Search results for query: *

Hi, Can someone please help me? Thank you for your time and help in advance. I have a combobox in VBA that belongs to workbook1, and I want the combobox in workbook1 to list all the sheets of workbook2 (which is a closed workbook). Here is the code I have so far...

Hello Everyone, Can someone please tell me the best way to approach the process I want to develop? Thank you in advance for your time and help. I would like to transform multiple workbooks in Excel to become a Web-based interface that allow user to perform "what if" analysis; add/delete...

Hello Everyone, Can someone please help me? Thank you in advance for your time and help. I have a workbook in Excel, and I want to be able to search the rows in the worksheet by phrase and keyword. Once the phrase or keywork in the worksheet is found, the worksheet should be filtered so that...

Hello, Can someone please help me with this? Thank you for your help in advance. I have a worksheet, and I would like the row color to change from white to green when a user enter information into a blank row. I have tried to enter this formula into Conditional Format Formula...

Hello, Can someone please help me? I have a question about checkbox enabled and disabled capability. I would like to thank you in advance for your help. I have a table call 'Items' with 'Status'; 'Due Date'; 'Overdue' and many other fields, but the condition only involves Status; Due Date...

Hello, Can someone please help me ? I really appreciate your time and effort in advance. I created a form called "Form1" with a textbox called "txtpsswd", and another form called "Form2" with a textbox called "txtnewpsswd" and a command button called...

Hello All, Do you know if it is possible to run the MS Excel file with VBA forms and modules embedded on a Website? I uploaded the MS Excel file with VBA forms and received an error message when I tried to run it directly from the Website. The error message is as follows: "Run-time error...

Hello Everyone, I am fairly new to VBScript. I have forms and modules in MS Project VBA. As you already know, most of these modules were built using recording macros. However, I want to take a step further by enabling users to remotely perform actions using the VBScript forms on a Website...

Hello Everyone, Can someone please help me with the UPDATE SQL Query? I appreciate your time and effort in advance. I have 2 tables in a db called "Master Table" and "Imported Table." Both tables have the same number of fields and field names as follow: UID, Name...

Can someone please help me with the following question. I thank you for your help and time in advance. I have a subform inside a form that displays as Datasheet view. My goal is to highlight the cell when a change occurs. For example, the Datasheet consists of 4 columns: TaskID, TaskName...

Can someone please help me with the following question. I thank you for your help and time in advance. I have a subform inside a form that displays as Datasheet view. My goal is to highlight the cell when a change occurs. For example, the Datasheet consists of 4 columns: TaskID, TaskName...

Hello, Can someone please help me with the question below? Your time and help are truly appreciated. I have a form called Purchase with a default view as datasheet. The Purchase datasheet consists of five fields: Vendor ID, Product Name, Price, Quantity, Total$(Quantity * Price). I also...

Hi, Can someone help me? Thank you in advance. Even though I know that MS Access does provide the security, but I also want to create a login form that verifies the users by their username and password. So, I created a table called tblLogin which has two fields: Username, Password. I also...

Hi, I have a form and everytime I make changes to the existing record or add a new record, MS Access automatically save the record to the database without my confirmation. My goal is to disable this Autosave, and only save the changes of the existing record or the new record to the database...

Hi, Can someone help me with this question? I thank you for your help in advance. I have a DB in MS Access with two tables: Task and Delete The Task and Delete tables have the same number and types of fieldnames, and the primary key of the Task table is called TP_NO. I also created a Task...

Hello, Can someone help me with the DELETE Duplicates Statement? I have a table named Junction in MS Access DB which duplicates each record by 47 times. Is there a DELETE statement which allows me to reduce the records copy to just 1. Thank you for your help in advance. DTiff

Hello, Can someone help me with this query? I don't know what I did wrong. The purpose is to insert the records from one table to the other by matching the same fields. INSERT INTO Junction ( Unique_ID, ID, WBS, Name, Duration_In_Days, Start_Date, Finish_Date, Recurring, Milestone...

Hello Everyone, Can you please let me know what is wrong with the query? INSERT INTO Junction (Unique_ID, ID, WBS, Name, Duration_In_Days, Start_Date, Finish_Date, Recurring, Milestone, Resource_Unique_ID, Resource_ID, Resource_Name, Resource_Initials ) SELECT Task.Unique_ID, Task.ID...

Hello, Can someone help me with the problem I describe below? I appreciate your time and concern in advance. I have a VB 6.0 form with two DataGrids. The Recordsources for these two DataGrids came from MS Access 2000 DB. The Recordsources name are as follow: Task & JT. The JT table has the...

Can anyone tell me how to update a table in MS Access DB using sql? Thank you very much for your time. Diem