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

Microsoft Access - Search Query

I have two strings: 1. #ck# 2. #c44# these are located in a string like "#CK# Site B: Umbau der IDU vom in Delta-Cabinets und Auflage der STM-1 auf ODF" I am unable to use a function that is similar to isnumber(search) in Excel. I want to find…
Mani
  • 35
  • 1
  • 5
0
votes
0 answers

My SQL Keeps Getting Deleted

I have 15 saved queries that filter data from a master table. They just filter out different values (Location Code ie, LAX, NYC, CHI etc). My problem is that the SQL statements of those queries occasionally get changed to just SELECT; When I…
Joe Ferrer
  • 11
0
votes
1 answer

Show all entries (including null) unless criteria is met

I have a table on a form that should show all entries from a table. This table can be filtered by two fields on the form which modifies the query. The problem is that entries where one field is null do not show up. I added the code here and it…
tjb1
  • 747
  • 9
  • 30
0
votes
1 answer

How to put name of current object in clipboard

In Microsoft Access, is there a way in can put the name of the active object in the clipboard, so that I can paste it into code?
user1546084
  • 1
  • 2
0
votes
1 answer

How can I reset an option group in Access?

I am monitoring true/false veterinarian cases in a research facility. I have a true/false option group that generates either 1 (true) or 2 (false). Then, I use the value (which is not stored in any table) to create specific actions. Here is my…
Johnathan
  • 1,877
  • 4
  • 23
  • 29
0
votes
1 answer

Is it possible to run a query to rename the fieldnames of each field?

I have like 20 datasets, each with 28 fields without the first row having fieldnames. So MS Access assigned 'Field1', 'Field2'.... 'Field28' as fieldnames for each column. I'd like to know if it is possible to run a query to rename them? I…
dropkick
  • 1
  • 1
  • 4
0
votes
1 answer

Sharing MS Database with Multiple Users

I have a MS Access Database that I need to share with multiple users in the entire state. Right now I split the database and placed the backend on a shared network drive and distributed the front end, but the issue I'm having is that offices…
Jordy
  • 53
  • 1
  • 9
0
votes
1 answer

VBA save Excel file as .xls from Access

Hi, I have to perform Import from Excel file into Access DB, without duplicates. Only way that this can be done is by creating table where you can Import Excel data, and…
LuckyLuke82
  • 586
  • 1
  • 18
  • 58
0
votes
0 answers

I suddenly lost access to my Microsoft Access database

I am using Access on my Mac through parallel desktop. I worked on my database all day until I recently got this error message: I am baffled to what could have happened... Any ideas? Thank you!
Johnathan
  • 1,877
  • 4
  • 23
  • 29
0
votes
1 answer

How do you select records based on their ID number and only if second ID is a specific word

I need some help with selecting and displaying specific data. This is travel data and I only want to find what the first and second trips are, and only if the 2nd trip is 'Home' or 'ReturnFromWork'. I want to see who made direct trips from…
dropkick
  • 1
  • 1
  • 4
0
votes
1 answer

Removing Null Values from a Query

I'm trying to write an SQL statement that will return countries that had exports of over "500" from my database. My issue is that instead of not returning countries that do not meet the criteria, my query still returns those countries except with…
sparky
  • 25
  • 1
  • 4
0
votes
1 answer

how to connect MS Access (x86) DB using Microsoft Jscript running in x64 bit Environment

I am trying to connect an MS Access (x86) database (*.mdb) from a third party application which is x64 bit and supports Microsoft JScript ... My Code Looks like below: function testaccess(sender : System.Object, cmdArgs :…
Dharmesh Gohel
  • 3
  • 1
0
votes
1 answer

getting the value of two fields with checkbox

I'm trying to get two values based on a checkbox in a continuous form. Whenever I click a checkbox I want to get the adjacent values of Cost of Item * Quantity. I'm new to VBA, so I have no idea where to begin. EDIT I figured it out for the…
bonziia
  • 35
  • 7
0
votes
0 answers

Searching a Database file table for files in a folder path using SQL

I am fairly new to SQL programming and I need some help. I am working on creating a little MS Access 2013 report that will dig through an SQL 2008 database's tables that hold folder path information for files and count the number of new files put in…
David G Bitts
  • 1
  • 1
0
votes
1 answer

Text Boxes over combo boxes in continuous form

I'm hoping someone can help here. I have a continuous form in Access 2013, I have code in already which allows you to search for a specific item, this is on click event for a button, I also have a reset which again is on click event for another…
Justin Baker
  • 1
  • 4
1 2 3
…
99 100