All Questions
4,016
questions
0
votes
0
answers
14
views
MS Access combo box and text box control source
I have a combo box and a text box in a form. The Text box value Control Source is set to the value of combox box + 1. But if the combo box value is 0 or empty the Text Box shows #error. I even tried ...
1
vote
1
answer
11
views
Multiple filter between date and category on a subform in MS access >> Type mismatch error
Please, anyone suggest me to solve this error, I'm new for the MS Access development. I have been getting a problem to filter subform between filter date and category. It show an error statement that &...
-1
votes
0
answers
37
views
Why is my query not populating in MS Excel from Access? [closed]
Hi, I am trying to pull my queried data into an excel file but unfortunately it is not populating in excel even though there is data in the access queried table. Any fix to this?
I have tried ...
0
votes
0
answers
30
views
Getting an error while trying to connect MS Access database to netbeans [closed]
I am getting the error
java.sql.SQLException: No suitable driver found for jdbc:ucanacess://C:/Users/jin06/OneDrive/Documents/NetBeansProjects/MazeMania/MazeManiaUserbase.accdb
package mazemania;
...
-1
votes
0
answers
95
views
Visual Basic - BindingNavigator not working properly with database
I'm trying to complete an assignment where we have to interact with an Access database via a BindingNavigator in Visual Studio with VB. The one table is called Grades, where the grades of students are ...
-1
votes
1
answer
42
views
How to show the same field value from another entity attributes
How can i show the same value of attribute from Item_Stock under entity PurchaseOrder and Warehouse ?
To be more specific, i need to do a calculation from warehouse that when Item_Stock is taken by ...
0
votes
0
answers
21
views
MSAccess unexpectedly change the character i to I in my code
I paste the following code to a text or memo field in msaccess table
for (var i = 1; i < rows.length; i++) {
var thisCell = rows[i].getElementsByTagName('td')[1];
var thisContent;
...
0
votes
2
answers
135
views
How do I connect Delphi to a website using MS Access database?
I want to create a local website for a registration form where the user can register and then login using the Delphi language. I need the info from the website to be saved in a database and the ...
0
votes
0
answers
46
views
MS Access with VBA: How to make a Field on a Form that adds a new columns to table by lookup?
I need to create a Field that will function as a Lookup Field but that will look up Column Name (instead of cell content, as in the traditional Lookup Field) and add a new Column with the name ...
0
votes
1
answer
17
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").
...
0
votes
0
answers
83
views
Is there a way to make a incremental array in C#?
I am making a sales report on C# and Microsoft Access
This report gathers all product sent to other branches in a month and prints on a PDF using iText.
All the data I need fills a datagridview like ...
0
votes
0
answers
18
views
Connection between Access Database and HTML Browser interface [duplicate]
I have a Microsoft Access Database with 5 tables and a html browser webpage.
I need to connect the database with the web so it can read and write my data from every table.
Any ideas?
Tried with a ...
-1
votes
1
answer
45
views
Inventory With multiple items unit
I'm working on designing a database in MS Access, but I'm having trouble with handling products that come in different units. I would greatly appreciate any guidance on the correct way to design this. ...
-1
votes
1
answer
53
views
How to use sub queries in MS Access DB--So far not working [duplicate]
I tried
SELECT 2 - (SELECT 1);
and got
" Syntax error in query '2 - (SELECT 1)' "
0
votes
1
answer
35
views
Formatting in Millions - MS Access
I'm trying to format a figure in an access form to read in millions but retain the 0. in how it displays.
Using the formatting: #,###,,.0 makes my figure of 200,000 read as .2 which is great.... But I ...