acccess

I have frmEmployees where you enter the name of the employee txtEmployeeName When you click the save button, cmdSave I want access to create a new table with the name: Transaction(employeename) which is a copy of the original table Transaction I only want the structure to be copied, not the...

My cousin a nurse sent me a question to help her with, she knows nothing about Access, even computers in general. and im only familiar with excell I was wondering if anyone here can help with the questions, I tried working on it by multitasking while im at work but im not able to pull through...

I am sure that this has been asked, but I cannot come up with the right search terms to find it, I'm sorry. I have a simple database with two tables (a "vendor" table, and an "invoice" table). Any vendor can have one, or any number of invoices. I want to make a report showing all invoices...

How to delete the duplicates rows in a single MS Access column? I'v got the code for Excel's VBA: Sub AccessDB() Dim db_file As String Dim cn As ADODB.Connection Dim rs As ADODB.Recordset db_file = "c:\Files\" db_file = db_file & "accdb.mdb" Set cn = New ADODB.Connection...

Hi Guys, I am working on a form in Excel VBA code of which is password protected. The idea is that user fills the form (accessible from his/hers drive or from remote location), clicks submit button and the email with details is sent. At the same time the same details are saved into other...