Search results

The problem is that i cant connect the ID_RASKRSNICE and ID_UREDJAJ in subquery... This is something like this SELECT IZVESTAJ.*, (SELECT RASKRSNICA.ID_UREDJAJA FROM UREDJAJ INNER JOIN (RASKRSNICA INNER JOIN IZVESTAJ ON RASKRSNICA.ID_RASKRSNICE = IZVESTAJ.ID_RASKRSNICE) ON UREDJAJ.ID_UREDJAJA =...

Can I give you my db for you to do it, I can’t find how I can do this. I only found simple operation Subqueries and I cant make any head way… :(

Now i have a problem if making a query within a query... a subquery... a subquery that uses the field in the first query... my head hurts... :(

... I’ll figure it out In time... does this calculated filed is done just one time and when its entered in the db it does not change. The result of this query is different in time, that’s why I made this calculated field. Same records will have different query results in time. I need this for...

More in System Administration. Where to put it so it calculate it, I have a finished query and everything but don’t know how to make that field calculate and fill it.

Actually I’m an IT engineer that they tasked with the making this db… self thought in access 2007, that’s why I’m full of questions :( And we are in a process of privatizing , that’s the main reason I’m doing this db. Can I make a calculated field with a query? I’m using access 2007 so I don’t...

Not a search form, i have a form, it’s a form for entering other data in my table. I just want to enter a new field in my table that will be filled by a query that is conditional with another field value in the same table. BeogradPut is a public utility company that runs the roads and...

Hi all, I need to enter a value in my table from a query that is conditional via my form automatically (combo box triggers a query). Is there a way to do this? I can fill a List box with my query but i can't make it go in a record. I actually can, but I must select the list box before it...

Got it :) Thanks

That did it :) Thanks if you could tell me what you did there I would be grateful :P

The same problem is in my QrySearchRASKRSNICA that I use for searching thru my table. I don’t get the results for the streets that do not have ID_Uredjaj. This is a simple form – you will understand it better. Form is FrmPretraga – enter Svetozara Markovića in the criteria for the search and you...

Select Svetozara Markovića-V.Milenka in IZVESTAJ IME RASKRSNICE and start QryRASKRSNICA. Everything is Null and i want to see the DETALJI. The question is why do i get the Null value, in everything, in this query when one of the results is Null?

The query is QryRaskrsnica [gets the location from the Form IZVESTAJ - field IME Raskrsnice ] and the location that is the problem is Svetozara Markovića-V. Milenka. In the table RASKRSNICA - the record with Svetozara Markovića-V. Milenka - does not have ID_Uredjaja but it has DETALJI.

This query is old, it worked fine but then I came upon a record that is specific, like this one that has no device (the device on this location is old and one of its kind) and in the details of that record there is information of this fact. When I run this simple query I don’t get anything and...

Hello all, I have a query that gets the device and details from the location were they are located. The location is selected in a form. I have a location without the device but with the details.If the device is not null I get the results of the query, but if the device is null, I get that...

Hi all, I need a history of changes to a table. I wanted to make a copy of a table record to another table with an addition of a date and comment of change. I made a form for changing the table (this table contains the newest state of the record ), any time I change this table with my form I...

Hi all, How do I start a macro wizard in access 2007? How do i make a macro for copying data from one form to another form? Thanks

Can this be done? Please help :( Can i maybe make the data from one form copy automatically to another form when I open it? Can this be done my making a macro?

Hi all, I Have a table that has the 25 different data fields (numbers, yes/no, text). I need to make a record of changes that are made with the date of the change. I have a table that has the info but it’s the [last state table]. My logic is to make a [new table] that has the date and all the...

Hide the records... That is an interesting idea, how do I hide a record? Can I look at it from that form?