access 2013

It's been awhile since I've had to use Access. I have a roster database in Excel that I want to be able to create reports for in Access. So I linked the table in Access and created my report. What is going to happen when I add records in Excel and use Custom Sort? It looks like I am not able...

Hello all, Not sure exactly what is wrong with my code, it keeps coming back with error 13 (type mismatch). This is a simplified version of my code with the line causing the error highlighted: Sub Loop_Criteria_UnionQUERY() 'define names for the database, query table and the SQL string Dim db...

Hi, I have a base Query that pulls in data to be used in multiple queries. Select ClientActivities.FacilityID ,Facility.FacilityName ,ClientActivities.ClientID ,ClientActivities.ActivityID ,ClientActivities.ActivityDate From ClientActivities Inner Join...

I'm trying to add an attachment to a field "SDS" in my table "ChemicalLibrary" When I'm adding a completely new record to the table it works perfectly (the first half of the code below). My problem arises when I'm trying to update a record in the table and add an attachment. Below I'm trying to...

Hello, I am trying to upload 100+ csv files into MS Access, I am a amateur in VBA, could i possibly have some help writing the code? The file location is, D:\Users\UKVIV00003\Desktop\Clients, the file format i need to import is csv, and i require all fields to be imported. Also, what is the...

Dear all, Below codes fill the bookmarks in Word, no problem there. However, I'd like to add the logo of client companies to this, but I do not know how to call up images with FillBookmark based on the selected Contact. The images are saved in the folder \logos which is in the same folder as...

Dear all, I am linking my Access Database to a UserForm in Word and have written below code. When I test the macro there are no errors, but the ComboBox is empty. Can anyone tell me what I'm doing wrong here? Private Sub UserForm1_Initialize() On Error GoTo UserForm1_Initialize_Err...

I have several columns in an Access Table that I need to split into several fields. They are easy to "Delimit" as you would call it in Excel, with a "-" or a "." where I would need to split it. How can I accomplish this in Access? Another thing, I only want it to split the first "-", but no...

Hello there, I am new at VBA and Access and I was making a DB that needs to print a determined number of different labels depending on the options given. When I use macros it is quite easy to choose the labels and it all works but I found out code that works fairly well and it becomes faster...

Has anyone ever tried the Access Web App for Sharepoint 2013? It literally creates an instance of SQL Server 2012 so this new "hybrid" should give the actual Application some new never-before-seen features. Share your thoughts! Has anyone ever done a row-level security or used of views with...

I have an Excel spreadsheet with client names and addresses on it. It has grown to over 30,000 rows (one row per record). I am now trying to import it into Access, but Access will only import 448 records before it says there is too much data. Is there any way that I can easily split my data so...