Stack Overflow
Stack Overflow

Questions tagged [ms-access-2013]

Questions regarding the Microsoft Access 2013 database management system.

Microsoft Access 2013 is a database management system and application development tool. It is included in "Microsoft Office Professional 2013" and "Microsoft Office Professional Plus 2013", and can also be purchased separately.

.

For more information on Microsoft Access, see

http://en.wikipedia.org/wiki/Microsoft_Access

.

For more information on new features in Microsoft Access 2013, see

What's new in Access 2013 - MSDN - Microsoft
http://msdn.microsoft.com/en-ca/library/fp179914.aspx

What's new for Access 2013 developers - MSDN - Microsoft
http://msdn.microsoft.com/en-us/library/office/jj250134.aspx

2184 questions
0
votes
1 answer

Connecting an Access database with password? (OledbConnection)

Look, I'm working and doing tests with Access databases in Visual Basic. I created an access database, and place it in the bin / debug folder of the project. Without assigning a password , it connects sucesfully with the database ... but when I…
TwoDent
  • 405
  • 7
  • 26
0
votes
1 answer

Trying to Get the Earliest Date using MIN()

SELECT ID, AppID, Description, Min([Transaction Date]) AS 'Transacton Date' FROM AppProsHist WHERE [Description]='Non-Final Rejection' GROUP BY ID, AppID, Description I thought this would allow for only the first (earliest) transaction date to be…
Johnfun10
  • 118
  • 8
0
votes
1 answer

Connecting MSAccess database with java webapplication

I am trying to connect Msaccess database with my java webapplication using the following code: import java.sql.*; public class connection { public static void main(String[] args) { try { // Load MS accces driver class …
Saideepthi Anivireddi
  • 1
  • 1
0
votes
1 answer

Report styles in Access 2013

I have an assignment that says to create a stepped report in Concourse style in Access 2013. However, I can't find a place where I can select the style, and when I follow Report Wizard instructions online, the Wizard on my computer completely skips…
Stephanie Fu
  • 79
  • 1
  • 9
0
votes
1 answer

Error When Using MS Access StrConv Function

Introduction I have a form with a TComboBox that I want to populate with a field from a table in my database using a query. I also want the values in the field displayed in proper case, which can be achieved using Access’ StrConv function. Here’s my…
Reginald Greyling
  • 363
  • 3
  • 19
0
votes
1 answer

SQL to eliminate the text and keep the number, capturing the number in hours

I have a table called VISIT REPORT. There is one column in the report named, Hours Spent, which I want to make changes. Due to imported data from other sources, some records for Hours Spent is recorded as, for example, "1 hour", "2 minutes", "3…
APPLEICECREAM
  • 1
  • 2
0
votes
0 answers

MS Access 2013: Force query to include multiple records which match a date interval

My MS Access 013 database had a table that records hours worked on specific projects in [Design Hours] and cross-references with a table of information about our people in [People], who manages whom in [Managers], and information about each project…
CarlF
  • 226
  • 4
  • 13
0
votes
1 answer

Limiting a combo box value by another column value

I'm a novice access user. I have created a form which brings through multiple values from a table, I have a column which I have as combo boxes. What I want to do is limit these combo boxes by the value in the same ro of a different column. Example:…
Justin Baker
  • 1
  • 4
0
votes
1 answer

Regarding creation of database in MS ACCESS using C# code dynamically

Is there any way i can create a MS ACCESS Database dynamically by writing code in C# ? I need this for my college project.
user3260706
  • 3
  • 1
0
votes
1 answer

Record count with Total records in MS access datasheet view by default

Im working with MS access front end and SQL server Back end I have 2 similar forms where one form for read-only view is copied from another form which allows edit. The form which allows edit displays the current record count at the bottom with total…
user2514925
  • 931
  • 8
  • 33
  • 56
0
votes
1 answer

Microsoft Access database primary key

Not me so I might not do the question justice; however, my suite mate was working on a database in Microsoft Access 2013 and somehow deleted the primary key. He didn't notice until after saving his progress. Is there a way to revert this, or is he…
Zackeezy
  • 74
  • 8
0
votes
1 answer

MS Access VBA: Can not transfer array variables to user-defined function

This is the first time for me to write VBA code involving arrays. I have a problem that MatrixMult function (which calculates M1 and M2 matrices) can not be called from MatrixText function. The problem is in "MOut = MatrixMult(M1, M2)" line. When I…
Mr. Ta Cen
  • 1
0
votes
1 answer

Using SetProperty/Dlookup macro to autofill

I am trying to set up a macro and expression to update a form field when an existing record is selected in a different field. Specifically I have a drop down on my form that allows the user to select a "request" object from my request table. When…
CodeJack
  • 19
  • 2
  • 5
0
votes
2 answers

Access SQL Server Insert blocked by Select

OK we have a multi user (25 users) Access 2013 FE and a SQL Server 2012 BE. Up until yesterday the whole system was working FINE and now it has completely stopped. If user A has a record open via a straight forward select query reading from TABLE…
Michael
  • 2,507
  • 8
  • 35
  • 71
0
votes
0 answers

pass through query in access vba time out happens due to inactivity? or regardless of activity?

Im working with MS Access and using Sql Server as back end im using Passthrough queries and set the ODBC Connection Timeout property. I want to know the time out error happens due to inactivity on the datasheet view of the particular query or…
user2514925
  • 931
  • 8
  • 33
  • 56
1 2 3
…
99 100