Search results

I have a field (DueDate) that will blink (flash) if it passes its value problem is the text to the right of the navigation buttons is not showing the number of records unless I navigate till end of the records. I tried Me.Requery and Me. Refresh but with no success

I have a macro that will copy the database to a folder upon quiting. The databse also is enabled from the options to compact and repair upon exit. Problem is the copied databse will be always not compacted becaue the macro will run 1st before quiting (and hence before compacting). is there a...

what is the color number to change the font to red

works great, thanks a lot what if I want if above are met then [DueDate] color is red how to write it

I am trying to write a code that will enable an event to happen if 2 conditions are true, something like: If [DueDate] >= [CurrentDate] And [EndDate] is Null Then Event ..... take place I tried above and did not work it works only if write one condition of above how can I set it up correctly

I have a switchboard with an exit button to exit the application. I want to add an event so it executes when user exit the application from the switchboard. how to do that. or how can I access the procdure for the application exit attach the event to

can you tell me how did you manage to do it. 1- where did you put the function code 2- from where did you call the function (a button click or upon exit application) 3- how did you solve the not found issue in you message above thanks

I managed to do what I want by attaching to the button a macro that will run the query as a filter. now how can I reset the form to show back all records. tried to do another button/macro but could not figure it out

no Frm_Orders is the main form with a subform sFrm-OrderDetails

Ok I did, as per below: Frm_Orders.RecordSource = "SELECT tbl_Orders.OrderID, tbl_Orders.PurchaseNo, tbl_Orders.CustomerID, tbl_Orders.StartDate, tbl_Orders.DueDate, tbl_Orders.EndDate, tbl_Orders.InovoiceNr, tbl_Orders.Notes, tbl_Orders.StartDate, tbl_Orders.StartDate...

thanks a lot, I did as you said, but it gives a syntex error and when debug you see attached photo

Dear all, I have a form with a subform that is linked to a query. the current record Source is as follows: SELECT tbl_Orders.OrderID, tbl_Orders.PurchaseNo, tbl_Orders.CustomerID, tbl_Orders.StartDate, tbl_Orders.DueDate, tbl_Orders.EndDate, tbl_Orders.InovoiceNr, tbl_Orders.Notes...

I managed to insert a graph on my form based on a count query of my orders table. So it display now the number of pending orders (EndDate field is null) How can I make it dynamic i.e. when an Order is no more pending, the graph will automatically be updated. I guess the query has to be...

just to explain more, in my query I used the count function but the problem is for example I have an OrderID (#27 for example) is linked to 3 tasks in OrderDetails, so the count function return 3 instead of 1 (it is only one OrderID at the end). how can I modify my query to read only OrderID alone.

Dear all, I have a simple query that shows the pending orders and unfinished order detail tasks. I want to be able to count both (unfinished oreders/unfinished tasks) and display them graphically on the main form. I tried the group by and tried to count number of records in the OrderID field...

of course putting it in a query will be best. if you want it only on the form then it should be something like this: =[Price]*x where x is your Vat factor

Dear Bob, I managed to do it myself (last request above), I am gratefull to you and happy that I managed to manipulate the code and achieve what I want thanks again

I am not an expert yet in Access, buf feel that the Select Case is the right one for this issue. I am not fiamiliar however how to set it properly. regards

Final request Bob, I want to modify code above so that if the user uncheck one of the orderdetails records to check if not all records are checked to ask the user to remove the EndDate if it was entered before. thanks

Thank yu for your time and care, a reall master. as for the keys, I will do a primary key for the OrderDetails table. I understand that foreign key means that I will link this field e.g. OrderID field of Orderdetails to its field in Orders table. Annd that on the orderDetails table only one...