Search results

Hi all, I want to make 3 check boxes that can be changed if 5 fields in my form are entered. Until they are not entered the check boxes are [Me.checkbox.enabled = false] gray and can't be accessed. How do I do that? Thanks

Yes, but i don't know how to make it so i have like 5 results for 1 device 5 for another... SELECT TOP 5 IZVESTAJ.ID_UREDJAJ, IZVESTAJ.ID_RASKRSNICE, Count(IZVESTAJ.ID_GRESKE) AS CountOfID_GRESKE FROM IZVESTAJ WHERE (((IZVESTAJ.DATUM_IZVESTAJA) Between...

Hi all, I have 5 different devices and a query for every one of them separately, that gives me results I need in separate reports. How do i make a complete report that will sum up every result query for every device? Thanks

Hi all, I made a Query that has this code, and when i run it i have the right order, descending… SELECT TOP 5 IZVESTAJ.ID_UREDJAJ, IZVESTAJ.ID_RASKRSNICE, Count(IZVESTAJ.ID_GRESKE) AS CountOfID_GRESKE FROM IZVESTAJ WHERE (((IZVESTAJ.DATUM_IZVESTAJA) Between...

Yes i did but i wanted to see if there is something smaller maybe a module or something just for a form. That example i integrated in the entering the db. I wanted this for extra security...So if there is something like that that would be cool :)

Hi all, Can you make a Form level security. If you want to enter a form you must enter a password. Thanks

Hi all, I made a report that is based on a query result. Also i made another query that gets the parameter from the other query thru the report ( [Report]![ReportName]![Fieldname] ). I need this information in that same report. How do i enter the result of this second query into that same...

When I go to a record I want this to be entered first time I click on it only. When I go to other record I want also just the first time I enter it. There is a Text that is entered almost every time with adding some other text. I want to help the user so he has only to add or in some cases to...

This does it for the whole form, i want to enter it once in every record...

Hi all, I want to fire the event only the first time i on Focus the control. How do i do that? :) Thaankss

Where do i put If Me.Dirty Then Me.Dirty=False so i can’t make new records but can go back thru old records? I put it in make new record and move to record If Me.Dirty Then Me.Dirty = False DoCmd.GoToRecord , , acNext and If Me.Dirty Then Me.Dirty = False DoCmd.GoToRecord , , acNewRec And...

So What do i code where? Something like this? Where do i put Me.Dirty? Private Sub Form_BeforeUpdate() If IsNull(Me.DATUM_IZVESTAJA) Or IsNull(Me.ID_RASKRSNICE) Or IsNull(Me.ID_OSOBE_PRIJAVE) Or IsNull(Me.ID_STANJA_PRIJAVE) Or IsNull(Me.VREME_KVARA) Then MsgBox "All Required Fields...

It works but when i enter a new record and not fill the required fields i want him NOT to save it in to the table. He saves it when i go to exit (x) on my form. How do i NOT save that record?

Hi all, I made a Msgbox popup when i press make new record that did not fill all the conditions for making a new record. But when i click x on my window it makes a new record in my table. How do I disable this? Also what happens when you click on the x of the window and how can i implement a...

How do i make so that those same two boxes are needed for making a new record (doesn’t make a new record if they are not filled and popup an MsgBox with that warning), but not in a table, required option.

Thanks that did it :)

Hi all, I want to make an MsgBox popup when i click on a check box with a message - if the two controls are not filled you can’t check this box – if they are filled then nothing happens an the box is checked. How do I do this? Thanks

Solved it :) thanks

Yes, it will be a hidden control that automatically is filled by this event. So it must be a text box? I changed it from Column(3) - Column(2) still nothing...

Doesn't work...i put it in afterupdate event of the first combobox. Me.ID_UREDJAJ = Me.ID_RASKRSNICE.Column(3) The other control is also a combo box (it has predefined values). Do i need to set something up in this control or change the type of the control or what?