Search results

Hi all, I have a problem with some checkboxes and conditions, I have a checkbox A and B – B is invisible and is automatically checked when A is checked (onclick event). I want this to be the case when A is 0 to 1 but not the case when it’s already checked and goes from 1 to 0. This happens on...

Hi all, I want to calculate the DAY (Friday, Thursday, ect.) form a text box containing a date. How do i do this? Thanks

Hi all, I have an unbound textbox that I can enter the date. I want to make 2 buttons that will go thru the dates day by day forward (Button1) and back (Button2). I want that the last day in the DB (I have a constants that are the first/last day in...

Hi all, I have a query that counts by month. It works fine when you count separately the yes/no field and is not null field but when I try to put them in the same query I get the same number in both counting fields. Is there a way for this to work? Thanks SELECT Month([DATUM_IZVESTAJA]) AS...

Hi all, I want to make my update query work on all the records but my current record because i get the error that another user is changing the record in my form. I have a check box that is firing the update query. How do i change my query so i affect all the records but not the current one? Thanks

Hi all, I need to start an update query on deselect or unchecking a check box. I made a mechanism for auto checking this box if there is a result from another query – this query checks to se if there is another record that has this box checked. If there is, the new record has this box checked...

Hi all, I want to make a count query – in my table I have 3 Yes/No fields. I want to make 1 query that will count them all and result is Field1-Count Field2-count Field3-count. How do I do this? Thanks

Hi all, How do i disable design view on my report – i want to secure my reports so when in report view you cant get in to design view. Thanks

Hi all, I made a List box that runs a query that gets Type and Details of a Location. I made a listbox the biggest i could because it will be used on an old computer with low resolution. When i get a Location with much Detail text it is croping my text and can’t see the rest of it. How can i...

Hi all, How do i make a form open on a event (on Load of another form) if a query has results?(the form that opens displays the results) If there is a need for it then it opens, if there is no results then it does nothing. Thanks

Hi all, I need to color all my combo boxes and text boxes with the same color when i click a check box in a form. Can this be done? Thanks

Hi all, How can i enter the parameters of a table record with a blank form? If i make a BLANK FORM and have a combo box that helps me find the specific record in a table, how can i than change something in that record. TABLE1 [ID|LOCATION|CHECKBOX] - Combo box [ID| LOCATION] in TABLE 1, id...

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

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

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

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

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

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