Search results

Private Sub Completed_BeforeUpdate(Cancel As Integer) If Not IsDate(Me.EndDate) Then MsgBox "Please complete the Ending Date first!" Cancel = True End If End Sub

can I reun my report based on 2 criteria from one query. I learned how to do that on one criteria e.g. date (between and), I tried to put a second criteria e.g. Company name but it does not work thanks for any tip

thaks a lot, it worked but one problem: I can not go back to the date to enter the value because the error messgae reappear always i.e. I can not change the focus to the EndDate field

Hi, I have a form based on a table with a text control storing "Enddate" and a checkbox names "Completed". I want to write a code that will prompt/force the user to enter a date in the "EndDate" field if the "Completed" checkbox is checked. otherwise, it is OK to leave the "EndDate" empty as...

I have a report based on a query that shows Company name, total sales, net profit with a sub report showing detailed orders for that company. problem is no proper page break by company as I want to, so the pages continue and accordingly the 1st page will have the send company name then the...

Hi, I know I know that this question was asked too many times. I serached the forum but none of the threads showed me how to solve my issue. I craeted a simple form named "DateInput" with 2 unbound text controls for the user to inout a date range of the report. I added a command button that...

Hi, I am trying to have my report generated based on a date range as per the northwind databse example. I did everything exactly as per the example: a dialogue form to input the date range copied all codes and modified it with me control names in OnOpen, OnClose and OnNoData events of the...

I am trying to have my report generated based on a given period by the user (similar to the Northwind databse example). I have the rports done and it is linked to a query that has "Enddate" field. how can I do that. thanks

I have a datasheet form that is lnked to order details table. this form is displayed as a subform in the main oder form. in this datasheet, there is a field names "Completed" to inidcate that this part of the order was executed. I want to change the color of all lnked field to this completed...

thanks, but I want to do/learn about filters

hi, I am trying to make a filter that will enable me to show only the records onn a form based on un checked field in the fomr (Completed) on the attached database. can you help me do that. I have no idea how to do filters. thanks

Hi boblarson could you please help me once more. Attached database contains a button on orders form to filter uncompleted orders only based on selecting unchecked "completed" field. I did it based on example given by MStef but unfortunbately a missing link to the newly added field "company...

this is my last trial and thenI will stop trying this thread. please help

no replies. why hi friends, I used to receive almost immediate help from you, Am I violating any rules here and that is why no body is responding anymore. appreciate your help

no replies yet, may be because I typed by mistake buyyon instead of button. appreciate your help

Dear all, attached database contains a buyyon on orders form to filter uncompleted orders only based on selecting unchecked "completed ' field. I did it based on example given by MStef but unfortunbately a missing link to the newly added field "company name" appearede. I do not know how to...

Dear MStef, would appreciate your help thanks

Hi again, sorry I did send you an older version of the database. I tried to do same on my latest version but failed (give syntax error). I tried to find out what but could not. I would appreciate if you can redo the 2 buttons with their code for me to study the difference. thanks a lot

really, I did not do that, I am not sure how it ended up with a password, sorry anyway

sorry but what diod you mean by next time take off a passowrd