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

"Too few parameters error" when trying to open a recordset in Access with VBA

I found another answer on here that addressed this but it didn't help me. I checked the query I am trying to reference and I don't see a problem with any field. I also played around with how I declared and set the objects and stuff but that didn't…
user7389351
  • 403
  • 1
  • 5
  • 9
2
votes
1 answer

Setting User Permissions Within MS Access on Login

I am currently working within MS Access 2016. One of the requirements for the project that I am working on is tying the users Windows login to MS Access. I am only grabbing the users "User Name". Within Access there will be permissions set to users…
Orange56
  • 119
  • 7
2
votes
1 answer

Insert spaces before text in text box

I have numerous text boxes on an MS-Access form where I'm using left align, but I'd prefer to have a space or two between the edge of the actual box when it displays and the start of the actual data. I thought using the left padding item on the text…
Ross from Brooklin
  • 293
  • 1
  • 5
  • 18
2
votes
0 answers

How to open a Microsoft Access web form without macros executing

I'm developing a C# application to automatically read meta-data from Microsoft Access forms. Therefore user interference is not possible. I make use of the VBA object model using Office interop. Some forms have macros that execute when a form is…
bascoder
  • 181
  • 2
  • 8
2
votes
6 answers

Select records between yesterday and today

I have trying to implement a simple SQL query that gets records between today's fixed timing (e.g. 18:00) and yesterday's fixed timing (e.g. 18:00). SELECT * FROM [Table] WHERE [Table].[Date Time] > Now()-1; However, this will return all records…
Yong Xiang Soh
  • 87
  • 1
  • 4
  • 12
2
votes
1 answer

Access 2016 - Can I use 1 user-entered parameter to search 2 fields in a query?

I'm trying to help my daughter create an Access 2016 DB to catalog her massive collection of DVD's. For each record, she wants to keep two stars associated with the movie. I suggested fields "MaleStar" and "FemaleStar" but I got "the look" and she…
Ross from Brooklin
  • 293
  • 1
  • 5
  • 18
2
votes
1 answer

Working SQL query generates "A RunSQL statement requires an argument consisting of an SQL statement" in VBA

I'm trying to make a form in Access with a "search as you type" function to find a customer. I'll double click the correct match in a listbox to update the customer info textboxes. I succeeded the "search as you type" part, but not the listbox…
Vincent Labrecque
  • 304
  • 1
  • 5
  • 12
2
votes
1 answer

Visual Studio 2015 connection to Access 2016

I can't seem to get my Visual Studio 2015 to connect to Access 2016, both are 64 bit. I have looked at many forums and most people say to install the MS Access 2010 engine (x64). I followed the example given here-…
Tim W
  • 31
  • 1
  • 5
2
votes
1 answer

Is There a Way To Simulate the Form Activate from Modal/Pop Up Form

I have a form that opens a modal pop up helper form to collect some data. When this modal pop up form closes, focus returns to the main form. I would like to trigger some activity when focus comes back to my main form. The event model for the form…
Richard
  • 864
  • 2
  • 10
  • 21
2
votes
0 answers

How to recreate built-in CommandBarPopup in Access for Runtime

currently I'm developing an application with Access 2013/2016. This software should be runnable on client machines with the Access RUNTIME engine only. Now i noticed that all Ribbons/Context Menus are deactivated in RUNTIME mode. Now I'm trying to…
Daniel C.
  • 569
  • 2
  • 7
  • 19
2
votes
1 answer

Is it possible to globally add a project reference to anything that opens in Microsoft Office 2016?

I have a Microsoft Access Application (.mdb) that is old and proprietary and needs to be run on Windows 10 in Microsoft Office 2016. The frontend (.mde) for it needs some old .ocx controls, and I've narrowed it down to it needing a library (link1,…
leeand00
  • 25,510
  • 39
  • 140
  • 297
2
votes
2 answers

How to avoid a "You must enter a value" error message in Access VBA

I'm having issues avoiding a "You must enter a value in the __ field" error message in Access 2016. I have three tables, Tasks, Users, and TaskAssignments, and a split form that looks like: User Task Assigned? User1 Task1 True User1 …
randomname
  • 23
  • 1
  • 3
  • 6
2
votes
2 answers

Can't get the Today() function to work properly in MS Access 2016 Custom Web App

I'm trying to setup a query that will show me all of the records in a particular table where the listed expiry date is either in the past or upcoming in the next 6 months (approximately). At the moment, I have the "Expiry" field added to my query…
Jackson H
  • 23
  • 1
  • 5
2
votes
1 answer

Creating Multiple Links in an Access Textbox

I have a form in Access 2016 with a textbox in which I need to have multiple, semi-colon delimited hyperlinks (which will be dynamically created). What I've decided to do is create a "hyperlink construction string" in VBA, then assign them to the…
Christine
  • 621
  • 7
  • 21
2
votes
0 answers

Access VBA Error 3075

I am Running Access 2016 and I am trying to get some records from a query. I am an Access noob and I am making a database. When I run the following Code, i get Error 3075, and it says an Operator is not there, the thing is, when i paste the SQL…
Haru Fujimura
  • 121
  • 4
1 2 3
…
98 99