Questions tagged [ms-access-2013]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
10 views

How would I implement multiple comboboxes in an MS access (2013) form that references a single column in a table or query?

So my goal is to have two fields, one with a dropdown for "inventory", and another that autopopulates with "quantity". I was able to achieve that with a single pair by linking to a ...
0
votes
1answer
152 views

psqlODBC access encoding problem

My local machine: Windows 7, 32-bit. I have installed on it the psqlODBC for 32-bit. MS Access is 32-bit as well. I have tried both Unicode and Ansi connections to... The server: a 64-bit Ubuntu, and ...
0
votes
1answer
549 views

Access Macro: ApplyFilter w/values from 2 combo boxes

I'm getting started with databases in Access for a work project (technically a work-learn for my non-CompSci degree). I have experience using multiple filters on multiple columns through Access/Excel, ...
0
votes
1answer
162 views

Setting up relationships properly with the Access UI

I am making the database design of my website in Microsoft Access 2013 because it has a nice user interface and I believe it will help me understand everything a whole lot better with the UI. I have ...
0
votes
0answers
11 views

How to prevent read-write overlaps in split MS Access databases

Consider the following scenario (it is contrived to highlight the potential issue): I have a backend.accdb MS Access DB that contains all data tables. Let's consider this to be an address contacts ...
1
vote
0answers
55 views

MS Access: automatic creation of row in a table based on field in another table

I have a Table A with an ID field and a Question field. The question has a yes/no answer. I want MS Access to automatically create a new observation (row) in another table, Table B, if I answer yes. ...
4
votes
1answer
83 views

Fill percentage of total field conditional on some other field with MS Access SQL

This question is an extension of Fill percentage of total field with MS Access SQL. I have the following 2013 MS Access SQL query: UPDATE MyTable SET F = f / DSUM("f", "MyTable") ; This query ...
2
votes
1answer
96 views

Fill percentage of total field with MS Access SQL

I am trying to fill, with a SQL query, a field F with the percentage over the total of some field f, such that each record F(i) in field F is given by: F(i) = f(i)/SUM_i(f(i)) Both fields f and F ...
0
votes
2answers
36 views

Make custom query from two table access

I have two table that table 1 contains Number, code, ID and table 2 contains Name, Family name, Number, ID, code, Phone number,... Now I want to make a query that contains table 2 fields but the ...
1
vote
1answer
321 views

How to simplify this query?

I am somewhat new to Access and I need help with a query that Access does not execute because of Not enough space on temporary disk. I have one table. A product may have up to 3 IDs and a place to ...