access 2013

Hi, We're currently using Access 2013 to manage some data and it need to reference some other information from SQL Server. This normally isn't an issue. I've written a view that we can use as a linked table to pull selected data into Access but some users (not all) are getting the error...

Hi. I am running the following vb command from access 2013. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "123", "c:\test\test.xls", True Access 2013 - Excel 2013 The table 123 is created but the external table is not in the expected format appears and when I click on debug...

I have a question about numbering rows of data in a Access table or query. I do not want to number each row but want to number each time a serial number appears in a table or query. I have already sorted by date and would like to have a reference in the table of each appearance of a Serial...

I work in MS Access almost exclusively in Design View because I have to do quick little queries often and it is fast and easy. With that caveat, I would prefer to have a solution in Design View if at all possible. I am trying to combine wildcard queries that are both "Like" and "Not Like". When...

I have a database that we are tracking student enrollments and graduation certificates. I am trying to update the database to where we can input all the students for a course on one form. Generally students will arrive all at once and then we in-process them so being able to input all students...

Good morning. I am looking for some VBA that would label each row in a table in sequence from 1 to 10. I am counting the number of times a model number comes up during the year. I have them in order of largest to smallest by top 10. I now need to label each row from 1 thru 10. Autonumber will...

When I switched from Access 2013 to 2016 all of the charts that I had previously created changed to a smaller size in every form. How to I resize these back to the normal size they were before? I utilized two versions of Access because of a customer need for different versions from 2013 to 2016...

Good morning, I have a question about why I cannot load a table onto my SharePoint site using the SharePoint Lists command in Access. My data gets to 33% and goes very slowly from that point. I have not been able to load up any table I have tried. There is a large amount of data in the tables...

Hi all Please advise for some "Advanced Access Macros Training" I'm working few years with Access + VBA, and i'm very successful, but for MACROS (not VBA) i can't find any advanced training. Thanks in advance.

Hi, Hope someone can help me with this problem that I can't figure out. I have a database(accdb) table with 4 fields, ID, First Name, Last Name, Start Date and I have an Excel spreadsheet that has 3 columns, IDEMP, Full Name, Start Date. I'm trying to create a macro in Excel to import the...

My VBA just ran through and created 2 20meg Excel files and I've called the routine to send them to SharePoint. ' =========== SEND to SharePoint ============================ L = MsgBox("Do you want to send the finished files on SharePoint", vbYesNo, "SharePoint") If L = 6 Then...

Just found out that one of our company's sites that I support got Access 2016 on new computer. Most of our apps are written in Access 2010 and separate versions are set to handle the Reference differences for 2013. Anything I need to know about 2016? Thanks,

Hi, I have a 2013 access db that is pulling info from a 2013 excel sheet that is updated frequently. I had to do some digging to find out how to parse and convert data from one cell into multiple cells so that I could properly query the info in access - all date and time info is in one cell...

Hello, Anybody can help and create billing invoice for me with the help fully VBA/USERFORM in excel 2013 or access 2013? my requirements are below 1>Company Details 2>fully edit features if i want to change previous invoice 3>product select or search with the help of product code & search by...

I have built the PivotTables from the data and then PivotCharts from them. My "PrimaryValueAxisTitle" is showing on the wrong data; displaying on the Secondary axis side. And my "SecondaryValueAxisTitle" is not displaying at all. I do not get any error messages. Got any ideas...

It seemed like it should be so easy. I'm creating a bunch of data from Access and sending to Excel and then creating a bunch of Charts. Charts look good. As each is created, I want to copy it and paste into a Word document. Set WDapp = CreateObject("Word.Application") WDapp.Documents.Open...

I have a front-end application that contains various different objects (forms, queries, tables, etc) opened via a switchboard. After users log in, all can view most objects w/out issue indicating there are no problems w/ permissions or linkages to the back-end file. However, some users are...

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...

I am not a VBA expert. What I would like to do, is to append those csv files to my table in Access. It's an ongoing process, so those CSV files keep coming in to my folder every day. I don't want to copy the headers though since I already have the headers in my Access table that i created. (I...

I have several CSV files in one folder. All files have the same format. I created an empty table in Access that has the same headers as the CSV files. What I would like to do, is to append those csv files to my table in Access. It's an ongoing process, so those CSV files keep coming in to my...