access 2010

Hi Everyone, I've got a DB that's setup to show a list of our all sub-contractors that we use. The main goal is to show details of each subbie and if they meet the approval criteria or not. This way our contracts team only place orders with approved subbies. The main field is the 'Approval'...

I'm using Access 2010 and need to perform the equivalent of Countif in an Access database. I'm trying to count the number of times an ID appears in one table that match the ID number in a specific record in another table. For example the ID in Table 1 is 123. That same ID might be in the...

I am trying to streamline my charting requirements and need some advice. I want to export the queries I used for charts to excel and have that linked to power point. These reports are monthly and my manager would like to have these saved for historical review. So, I know I can export my queries...

I have a code error that was fine with Windows 7 office 32 bit, but with Windows 8.1 Office 64 bit.. it keep marking error at the set db = opendatabase command! how do i fix this problem. or how do i rewrite the code so it works! --------- Sub AddNewProduct() Dim dbsDuke As Database...

In my Access database, I have two tables, from different sources, that have similar data. Each table has a customer number, and a customer name. I'm trying to create a query that will show only names that don't match for a given customer number. So, in Table_1, I have 3704 Fred Flintstone...

I am trying to access a table that contains two words in the table name, my code works when there is only one name to the table. No matter what table naming convention it errors out. What am I doing wrong? here is my code: Sub OpenTable() Dim cn As Object Dim rs As Object Dim i...

Below is the following code I am using to copy the headers from an access 2010 table and paste them on a specific tab and row of an excel 2010 spreadsheet. Currently when it goes to the next access 2010 table headers to paste, it is pasting them at the end of the first set of headers. I am...

I am trying to modify the below code to loop thru a list of path location where databases are located: rDirList = Sheets("DRG").Range("I6:I99") and the paste the header table results on the row below. Anyone have any suggestions on how to get this to work? Code: Sub OpenTable() Dim cn As...

I have a database where the status of a part can change from being in, out, lost, etc. I would like to track when the part goes Lost. I created another field to do this with but when the status changes, the field I create changes. I would like for it to remain as it is no matter what the status...

Good Morning. I have a table with list of parts that were checked out. In this list there are several status changes you can make, one of them being that the item was lost. I would like to be able to have a check box or other field populate when an item is put on the lost list and have the flag...

I am looking for some help in creating a VBA macro in excel 2010 that will open an access database table titled "RX", copy the first row of data including the headers and paste the row of data into row A5 in the excel workbook that is executing the macro. Title of Access Database: RXtest.mdb...

I have a simple Excel file with 3 columns of data. I would like to be able to allow a user to make changes to the file and have it update an Access database with the changes as well as the Excel file. I'd like to have a 'Submit' button that processes the changes to the Access database. I am...

Hi, I´m don't know how to use vba to copy many excel files in to a access data base. I got a lot of files, the sheets got the same standards but different names and located in the same path.

I'm writing VBA code to open objects and document them. When it gets to a make-table query I'd like to get the fields of the table it makes along with each one's source. But when I set a QueryDef object to the make-table query, then set a Fields object to QueryDefObject.Fields, the collection...

I have a problem with a union query and counting. I have two queries that count different items from different stores. I want to see like items from each store and put the count of usage from each store into a single query. The problem is when I union these queries together, I have like items...

Hi All, I am kind of stuck on finalize a crucial report in MS Access..... and tried to Google it as well but didn’t find any useful solution.... I will try to explain it with an example... Lets Say i have a Table in Access with below data: Table 1: <tbody> Material Description Qty A...

Hi All, I have been asked to make my database send emails when a new record is added or a change is made to the 'mobex' I have managed to get it to record the information in another table but I cant get the email to send I also don't want it to alert the member of staff that an email is being...

Is there a way to look up multiple numbers in Access? I have a database and can input one number and have it return the information I need but is there a way to put in several numbers at once and pull the data? Thanks

I am creating a macro in Excel 2010 that selects a range of data (which changes each month) and copies that range into a table in Access 2010. I am getting the error message "Run-time Error 2498: An expression you entered is the wrong data type for one of the arguments." The macro stops at...

Is there a way to export a list of forms or reports using VBA to Power point? I currently can export a list of forms to PDF but would like to have the ability to put these over in power point. The forms contain graphs and when I copy the PDFs into power point it makes them fuzzy. Like a bad copy...