Recent content by fahur

OK. I know that DLookup() would do the thing, but how to parameterize the query?

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...

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...

OK. I've created a query that will work for me: SELECT LAST(port_number_new) FROM 02_NE_Data WHERE NE_number=parameter; It gives the value for last record of column port_number_new where Network Element number (NE_number) is parameter... (or does it??) but how to insert this value into...

Yes, after clicking a button a popup form appears. Doesn't work :-| I've put this: Private Sub Form_BeforeInsert(Cancel As Integer) Me.[NE_number] = Forms![01_NE]![NE_number] End Sub Hmmm... Let me think. Every record of NE_Data has two identifiers that are most important: number...

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...

Number field is autonumbered and this is my primary key. The thing is that the additional info for each element will have several records (some kind of history - what was going on with the element in the past). So there should be one record in Element_Table and to this record there should be...

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...