Stack Overflow
Stack Overflow

Questions tagged [ms-access-2016]

Microsoft Access 2016 is a database management system and application development tool.

Microsoft Access 2016 is a database management system and application development tool. It is included in some versions of "Microsoft Office 2016" and "Microsoft Office 365".

For more information on Microsoft Access, see http://en.wikipedia.org/wiki/Microsoft_Access

For more information on new features in Microsoft Access 2016, see: https://support.office.com/en-us/article/What-s-new-in-Access-2016-76454345-f85d-47af-ace1-98a456cb3496

Access Development - MSDN - Microsoft: https://msdn.microsoft.com/en-us/library/office/fp179695.aspx

1477 questions
-2
votes
1 answer

Is there an easier way to select every column but one in a table with a query in Access 2016?

I have a table with many column such like Name, Country, Gender, ID etc. Is there an easier way to do select every column of this table within a query except the Gender column?
Ice s. Woo
  • 27
  • 8
-2
votes
3 answers

How to count occurrence of each sentence in Excel in this specific case?

The challenge here is the sentence is not split by cell. They are in the same column, but they might appear in the same cell. One sentence per line. I need to count the occurrence of each sentence, for example, occurrence of "The cat is pink" is 2…
Ice s. Woo
  • 27
  • 8
-2
votes
1 answer

Syntax error on join operation access SQL

I'm trying to do some join operations in sql access but I keep on getting the join operation error. At first it was just the JOIN alone, but then I realized I had to add the INNER which I did but it didn't resolve the error. Code below: SELECT…
mark7328
  • 41
  • 5
-2
votes
1 answer

Overwrite access database from excel table using VBA

I've searched this website for my question, but unable to locate solution. I'm a beginner for excel VBA, Need some help help in updating old data in access database with new data from excel spreadsheet using excel-VBA. From internet i've created the…
Ravikumar N
  • 1
  • 2
-2
votes
1 answer

CurrentDb.openrecordset no result found

I am trying to have a text box show the value that is associated with a certain value. I have a table with 2 columns, [Error_Code] and [Type]. I want to have a combobox with Error_Codes (which works) and whenever a selection is made, the [Type] will…
jrussin
  • 79
  • 1
  • 7
-2
votes
2 answers

Split string separated by commas in access

I have a table tblPartnerships structured as ID      Partnerships 1     Finance, IT, Operations 2     Legal, Compliance, IT, HR I need to extract all of the comma separated keywords from Partnerships column and put it in another mastertable with…
Anup
  • 107
  • 3
  • 11
-2
votes
2 answers

Why did my code stop working?

When I entered docmd. In my code it worked, until I closed it then it stopped working here is my code . Private Sub Command1_Click() If (Txtusername = "123" And txtpassword = 123) Then DoCmd.OpenForm FormName:="Kappa", View:=acNormal,…
cinemassacres
  • 389
  • 4
  • 16
-2
votes
1 answer

Writing a value to two tables in access 2016

I have two tables in Access 2016 with one to one relationship and I want when entering a value (integer) on the fist one i.e "service report Number" to automatically set it on the second one.
Koullis
  • 3
  • 4
-2
votes
1 answer

Create a table from a Form MS Access

I have a continuous form in MS Access that I would like to create a table from. Most of the fields are populated by a query, but some fields will be user entered and there will also be calculated fields. Basically I need to create a snapshot of…
Chuck0185
  • 531
  • 3
  • 15
  • 36
-2
votes
1 answer

I need an Access query that returns customer orders where more than 1 product type was purchased.

I thought this would be simple enough, I tried the solution here, but can't get it to work Count(Distinct) doesn't work in access apparently. So here's my relevant structure: tblMaster with fields ID (Primary Key), fldOrderNumber, ProductID, and…
Matt
  • 1
  • 1
-2
votes
2 answers

vba ms access 2016 how to check if I need to update or insert

I have a form that captures call logging. I need to use the form to insert data to/update 2 tables. Basically I want the customerID, date, time, event, notes from the form to insert to a table every time a new call is made. This data comes from text…
Pixie007
  • 1
-2
votes
1 answer

Microsoft access form view

I am creating a Microsoft access application, and I designed a login form, where the user inputs username and password. I want the form view of the form to be showing above the access window, as a pop-up... how do I achieve that?
Danny Sofftie
  • 1,031
  • 1
  • 8
  • 16
-3
votes
1 answer

Access SQL - group data by week for current month ( 4 or 5 weeks only per month )

I need your help with this table please. GROUP BY DatePart("ww",[date]), statisticsABC.Date HAVING (((statisticsABC.Date) Between [STARTDATE] And [ENDDATE])); I used DatePart("ww",[date]) but it shows me data like this:
LULIIITA
  • 1
  • 1
-3
votes
1 answer

MS Access: Will Access 2016 application work with Access 2007?

If I create a VERY simple 2016 Access Database with [max] 5 simple Tables, a Data Entry Form, 3 or 4 Search Forms to display data and maybe a couple of Reports - will it work for a friend who is using Access 2007? I have worked on converting complex…
Talay
  • 349
  • 1
  • 5
  • 17
-3
votes
2 answers

How to secure my program from "illegal" copying?

Last year I started to develop a small "program" (not sure how this is called) in Access to help the family shop with the stock list and product prices, etc. A few months ago, a client of the company started to ask for my Access's program because he…
Ender Look
  • 2,303
  • 2
  • 17
  • 41
1 2 3
…
98
99