Search results

Sorry I pasted the code in beforeupdate by mistake, it works great, you are a genius. the sad thing is that I do not understand the code yet, I wull try to figure it out. would appreciate answering me on the Keys issues in the above reply of mine thanks

I tried the code after renamingthe check box. It gave me the error as per attached photos/ Also attached a photo of th code I pasted in the afterupdate event of the check box. regards

Thanks for the efforts and time, appreciate it. I will try it As for the keys, I believe I have a primary key for the orders table (OrderID). for the orderdeatils table, I did not know what to do because I have there the OrderID field linked to the OrderID field of Orders table. Should I...

is it possible touse visual basic 6 for example to create an interface for the finished access database so that I can create an install application for users that do nothave Access. in other words, I want to have a standalone application through VB 6 that will manage the database application...

appreciate it

what about the structure, any mistakes, recommendations (please do the analyze and see what it recommends) thanks

how to execute this. is it a code, where to put

I always do comapct and repair, still it is bigger than the limit, please send my your email mine is aymanmb@tedata.net.eg

I put it under the afterupdate event of the checkbox. the database file compressed exceeds the forum limit (~500 KB). Can I send it to your private email. regards

what is the best way to do it without harming anything. is it also possible to reset autonumbers thanks

I tried it did not work (see attached photo) thanks guy's for your interest to support

I did, still same thing, the message box appears regardless if all tasks check or not. hereis the updated code: Private Sub Completed_AfterUpdate() Dim ctlChk As Control Dim ctlChkT As Control Dim intCounter As Integer Dim intCounterTrue As Integer For Each ctlChk In Me.Controls If...

thanks, nice idea. I did as per your advise but no success. the code was: Private Sub Completed_AfterUpdate() Dim ctlChk As Control Dim ctlChkT As Control Dim intCounter As Integer Dim intCounterTrue As Integer For Each ctlChk In Me.Controls If ctlChk.ControlType = acCheckBox Then...

I finally managed to do it, thanks a lot for all the support

Hi, I have a form with a field "EndDate" and a subform holding multiple tasks and each of these tasks have a checkbox field "Completed". I want to write a code that will prompt the user to enter "EndDate" in the main form when all tasks in the subform has been checked (Completed). appreciate...

thanks for your patience. I tried it but something is wrong because the report is dependant on 2 tables "tbl_Orders" and tbl_Customers". whenI am done with your suggestion, Access keeps asking me for too many paremeters values which it is supposed to be got from the DataInput form. Can you help...

how do you do that (where do you write the code in the stand alone query). and why can't I use the report query since I have half of it working (date range) sorry for my beginner's question

thanks, but where should I put that code. I tried to put it in the report query criteria but gave me message of undefined where. I also tried to put it in the OnOpen event of the report but gave me message of can not find macro where ...... thanks for any tipes

Thanks, actually the example I have is a data input form for the user to enter a date range (which i did successfully) and a customer name (I did not succeede to do both). this form will feed a report query to filter the report to that specific date range for that customer only. the criteria I...

great responses, thanks a lot. I agree that it could be eliminated in presence of an EndDate/Completeddate. however for my learning curve, would apppreciate giving me an example code to make the checkbox disabled till a date is entered. thanks a lot guys