Search results

I only save the record when i go to the next record, how do i save the record on a click (check box) so i can get this record in query that i can put in a different table. Also how do i chose the last record in a query as the only result. By Date? By unique key? What is the criteria?

I already made 2 much changes in my relationships in my db, the easiest way of fixing the statistics problem is making a different table that will have that information. The update query is fired on the check box because that’s the check box that locks the record and then it can be entered in...

Hi all, I want to make a check box that saves the current record that is entered in the form. I want to make an update query that writes that current record in a different table so I want to make an OnClick event that fires that update query. Can someone help me? Thanks

I'm not so good in MS programming :( can you give me an example for this

I’ve decided to make a new table that will be filled with an update query – that will have a date location device and error. I just have to figure out how to do it and what will be the event that will fire that update query… And than i can make my statistics from that table.

I have a question. Can I somehow lock individual controls and not group of controls like all textboxes all comboboxes and all checkboxes. Can I lock like combobox 1 but not combobox 2

I made it work by editing the buttons :) if locked the buttons don't work

How do i lock specific buttons with my Tag property? (ctrl is Me.command) ? I cant make Me.AllowEdits work. :(

How do I do that? I made this work with Form_Current() but I have some buttons that can automatically fill some fields. They can fill it even when I LOCK the TextBox CheckBox and ComboBox with LockRecord. How to correct this? Maybe I can include the buttons in the lock…but I have some navigation...

Hi all, I want to have an option to lock a particular record (i.e. if an employee leaves, I want to lock their record so that the data can only be viewed but no further changes can be made to it. I know how to lock fields - but that will lock the fields for all records! I want to have an...

Re: Subquery as a Calucated field Here is my newer DB :) I Copy Pasted the Device name in my IZVESTAJ->ID_UREDJAJA field so i can show you what i want to be done automatically when I enter the ID_RASKRSNICE. Ignore the ID_UREDJAJA1 that is just for testing. :)

Re: Subquery as a Calucated field Ok no rush, thanks :)

Re: Subquery as a Calucated field Can this be done with some appending query that will fire when a new record is made. Please help

Re: Subquery as a Calucated field I have a simple problem but I don’t know how to solve it. The statistic that I’m doing is incorrect because of some changes that are done that I did not take into account. The error – ONE Location ONE type of Device. The problem is - that ONE location can...

Re: Subquery as a Calucated field Can some one help me? Or direct me to a place were i can get instructions or an example of calculated query field :((

Hi all, Can I make a field2 in my table that will be the result of another query that has the field1 as a chosen value. The Query is from another table that is connected to the first table. I really have a problem with this so if someone can help me. Thanks a lot

Bottom line is I want to put the device (URS-200, KSS-1 ect.) into my table IZVESTAJ , field ID_UREDJAJA, automatically when I enter the location field ID_RASKRSNICE. This information is contained in my linked table RASKRSNICE.Here is my db if you can help i would be grateful. And i don't want...

I made a new field in IZVESTAJ called ID_UREDJAJA – who I want to be the current device that is on the street. I want to put this information in this table because the device can change so in two dates we can have 2 different devices. I need this for exact statistic by street and by device...

This is the table that needs ID_UREDJAJA1 to be filled with the result of a query 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 = RASKRSNICA.ID_UREDJAJA ORDER...

I get that, but how to make the new field in one record be the result of a query that is conditional from a different field in the same record...