Hi,
unfortuately I have a problem with the data source of a graph in an form.
First of all: I am using Access 2013.
I have a cross table like this:
tbl_crosstable:
C_Datum | Company A | Company XY
-----------------------------------
2011 500 100
2012 600 300
2013 700 200
If...
Hey guys,
i am using the following function in a query:
Public Function Progress(ByVal varCompany As Variant _
, ByVal varPercent As Variant) As Variant
Static varCompanyOld As Variant
Static varValueOld As Variant
Dim Value As Variant
If varCompany &...
Hello,
maybe I can not not see the forest for the trees ... or it is realy difficult.
I have a table like:
-> tblPerformance
P_ID | P_Date | Performance
------------------------------
1 | 01.01.2010 | 1,03
2 | 02.01.2010 | 1,05
3 | 04.01.2010 | 0,98
4 | 05.01.2010 |...
Hello,
one more thread of mine today :D
I have this table:
-> tblTest
test_id | test_Name | test_Date | test_value
------------------------------------
1 | Company A | 01.01.2010 | 0,90
2 | Company A | 02.01.2010 | 0,95
3 | Company A | 03.01.2010 | 1,10
4 | Company A |...
Hello,
is it possible to name a field in a query or a table with a variable name?
For example:
I want to choose in listbox "fieldname" the name of the field.
And the query field name looks like:
forms![testform]![fieldname]: FieldOfTheTable
Unfortunately it doesnt work.
Also if I save the...
Hello,
I need support one more time :)
I have a form with a listbox that allowed multiselection.
The listbox depends on the field "name"
And I have a table "names_should_be_selected" (fields: name, date ...)
It would be great if alle names in the listbox are selected when the name is in...
Hello,
is it possible to call a function in a query with the input of a control element?
I have a form, and there is a list box in which I can choose the calculate method. In the query, a field should calculated with the choosen function.
Example:
SELECT tblTest.price, tblTest.Date...
Hello,
I already asked this question in my last thread, but unfortunately it was overlooked because the topic question was solved.
Anyway, sorry for double posting.
I have a price table:
tblPrice
PosNr PriceDate Company Price
1 01.01.2014 Firma A 5...
Hello,
I have this query:
SELECT A.PosNr, A.PriceDate, A.Company, A.Price, (SELECT TOP 1
B.Price
FROM
tblData As B
WHERE
B.Company= A.Company
AND
B.PosNr < ( A.PosNr - 364 )
ORDER BY
B.PosNr DESC )...
Hello,
I am trying to import data from an Excel file to MS Access (2013).
The Excel sheet consists of 700 columns. A group of 7 columns (always same header) are to be implement in Access one among the other.
That means:
At first columns A-G, than columns H-N, than columns O-U
I am trying to...