Search results
-
F
[VBA] Query Return Value
Hi! I have a query: SELECT port_number_new FROM NE_Data WHERE number=(SELECT LAST(number) FROM NE_Data WHERE NE_number=NEnumber); NEnumber is a variable, which comes from another form. How can I obtain a return value from above query? Is there some kind of function? I'd like to have a...- fahur
- Thread
- Replies: 4
- Forum: Modules & VBA
-
F
Query Return Value
Hi! How to run and read a return value form a query? I have two following queries: Form first one I want to get "number" as a integer variable, eg. "numberVar": SELECT LAST(number) FROM NE_Data WHERE NE_number=X; than I should insert "numberVar" into second query: SELECT port_number_new...- fahur
- Thread
- Replies: 1
- Forum: Modules & VBA
-
F
Controls automatic update
Hi! I have two tables: Network_Element NE_Data The second one is a "child" table for Network_Element. For these tables I've created two forms: 01_NE and 02_Data, which is a subform for 01_NE. The procedure of data completion is this: 1. Choose Network Element 2. Open NE_Data for this... -
F
[Table Relation] Problem
Hi! I'm new to MS Access databases. I'm trying to buil a database of a kind of elements. Every element has it's description (name, number, etc), but there are other parameters, which I want to add. I'll try to picture this: Element_Table-- | - Date...