6,014 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
0
answers
93
views
Access lookup using another column value [closed]
I have 4 tables in a MS Access database, namely
Table1 (values - A, B, C, D)
Table2 (values - P, Q, R, S)
Flags (values - Y, N)
Table3 has two columns, TYPE and DESCRIPTION
The TYPE column is a ...
-4
votes
2
answers
360
views
Using DAO to retrieve data types MS Access database
Even though most seem to frown on DAO, it seems to be my only option to get column information from an Access database. I downloaded a small function to do just that but the most important variable (...
0
votes
0
answers
299
views
Word Merge document cannot access the data source (error)
In brief: This is about a "Word cannot access the data source" error when starting a Word Merge process via an Event Procedure (VBA code) in MS Access 2010.
The overall situation:
I am ...
1
vote
2
answers
79
views
Error 426: The remote server machine does not exist or is unavailable when running Code a second time
I've looked through other solutions and none of the other posts seems to be identical to mine, trying to replicate the solutions I could, did not solve my problem
I'm trying to create a Master Word ...
-1
votes
1
answer
83
views
How to stop MS Access from modifying my queries?
I am using MS Access 2024 to create a form based on my query, where the user can input values into the search box to filter certain records from my table.
Every time I close the query window or MS ...
0
votes
1
answer
44
views
MS Access Continuous Form: How to filter records (standard number format) between the min and max range?
Here is my stocks table:
product_group
dimension
cost
TI
8x4
5000
WN
2000
YS
7x9
25000
ST
10x15
8000
I made a query stocksListQ and created a form findStocks based on that, adding a CostMinSearch (...
0
votes
1
answer
68
views
System.InvalidOperationException: Instance of entity type cannot be tracked because another instance with the same key value is already being tracked
I have a table TblQuotesDetails which is setup with this primary key:
entity.HasKey(e => new { e.OrderId, e.PartNo })
.HasName("PrimaryKey");
I am trying to modify some records ...
0
votes
0
answers
64
views
Maximizing MS-Access Application Not Applying Update to Subform's width property
I have a subform called "SprintTicket_Work_subform" on a main form called "Home". I have been playing with the main form's On Resize event to try to get the subform to grow ...
0
votes
1
answer
94
views
Only show detail values for selected row in Access 2010 Pivot Table
I have a database and I need to use a pivot table (which I have already created). I am trying to make it so that when a Cell in one of the rows is double clicked (I already know how to get what object ...
0
votes
0
answers
99
views
Access - Set Subreport Control Properties With VBA
I have placed three unlinked subreports in the Report Header of a main report. I want the records in each subreport to be listed in two equal-height columns (down, then across), so in the ...
1
vote
1
answer
235
views
send DDE command to pdf document in SUMATRA PDF on subform
I have an MS-Access 2010 application. I use Sumatra PDF as a pdf viewer. To make the viewer fit in with the application, I have loaded the viewer on a subform, using this simple code:
Private Sub ...
0
votes
1
answer
28
views
Requery works on Button Click but not on TextBox Change
I have a main form containing a subform called "SF_Liste_Patients", the source object of the subform is a query, filtering on a criteria (TextBox called "entree_recherche_nom").
...
-3
votes
1
answer
90
views
Access SQL Transform and Pivot usage
I have a table below that I need to count the instances that a particular group is in a particular gate status. I'm looking for an Access SQL statement to achieve this please. Your help is greatly ...
0
votes
1
answer
76
views
duplicate a form with all data , attachments ,subforms's data
Hi i am working on a ms file for identification cart of the equipment, but it dose not really matter
anyway i want to have bottom to duplicate an equipment form with all of the data and attachments ...
0
votes
0
answers
30
views
merging two queries to one query results in some records being dropped
I have two queries that are laid out as follows:
Query name - week1
SELECT
BERTHAGE.BOAT, BERTHAGE.LOCATION, BERTHAGE.BERTH_WEEK, BERTHAGE.BERTH_YEAR
FROM
BERTHAGE
WHERE
(((BERTHAGE....