Search results

Calling procedure is sending 'Me' as a parameter. Yes, Object is a parameter in function called. I've put a break point and 'Name' property is indeed there for the 'Object' collection set, attaching screenshot, and its value is 'Microsoft Access'! I don't have any idea where this Microsoft...

Hi n Happy New Year to all!! I'm getting Error: 438, Message: Object doesn't support this property or method. I'm getting this error while using LASsie from PetersSoftware for permissions and this happens when I try to put restriction on some Control on the Form. It works fine if i put...

No, i don't have this situation. Even if I Edit a form without any VBA procedure, the message pops up.

Hi, I've an Access DB with SQL Server back end. In fact I had an issue that every second time when try to I edit the same record on the form i get error as: 'The data has been changed. Another user edited the record and saved the changes before you attempted to save your changes. Re-edit the...

Thank you, worked. Now how to filter only results matching search criteria please? Regards, K

Hi, I'm looking to add search functionality on form using a text box and button, attaching screenshot. I'm using DoCmd.SearchForRecord command for that and it works fine if I used it to search, but when I try to use '* Criteria *' wildcard it doesn't search as expected and stays on the...

Is OnDelete more like BeforeDelete event? I feel like Delete button is a place then where I could write query to copy record in history table. Thank you for all the information and advice. K

Thank you, for all your replies. What I'm understanding is I've to save the data from table into some temporary table or variables and then after delete copy this data to History/Log table. If I use before delete, then I'll simply copy the record from base table to log table... same as I do...

Hi, What is the best place to log data into history/audit table before record is deleted please?? If I do this in Before_Delete event, then I've to delete the record from history/audit table if user presses Cancel on delete confirmation box. If I use After_Delete, then it'll be too late. In...

Sorted, by using tables instead of queries. Thanks for advice.

Didn't appear to my mind earlier when i was designing. I was only making sure that data is not repeating. I didn't know that UNION slows down the performance and doesn't let indexing carried through as well. Can't do any change for now, because already spent money to get android version...

Thanks for explanation CJ.

I think I'll be much better if you could direct me to some article/video on this please. Being still a learner, I'm not getting a complete idea, and need bit of details to get it working.

Because, maybe, frmSelection_Box_SE was not opened and values were not selected. Use Viktor please and 7/6/2016 let's say. I've not other way to get desired results. I've to combine two totally irrelevant tables and get them to the point to produce desired results. What does 'Carried through'...

Hi, Need your guys help once again. I'm facing a very slow report which is basically derived from multiple queries feeding each other. I tried indexing certain fields in criteria, cut certain table sizes at least 100 times shorter by reducing data which is required in production database...

howdy, How could I schedule in Access, sending a email report with an attachment everyday? let's say, 4 o'clock every morning? Regards, K

Thank you so much all, this query solved my problem. Regards, K SELECT qryWeeklySE_WorkpackEmployee_GroupBy.SupervisorID, qryrWeekly_Verified_Report.Area, qryrWeekly_Verified_Report.WorkPack, Sum(qryWeeklySE_WorkpackEmployee_GroupBy.WorkingHours) AS SumOfWorkingHours...

The query I'm trying to solve is based on two other queries. 'qryWeekly_Verified_Report' is a simple combination of several tables using JOINs. Second query, i.e. 'qryWeeklySE_WorkpackEmployee_GroupBy' is a group query, attaching screenshot for your review, shows the actual GUI query used to...

What else required please? I just need Sum of value in table on left, i.e. Working, Lost and Rest Hours, in Groups, where Activity Date lies between Start and End Dates in table on right... and then I'll combine certain other fields from both tables based on required report format.

Hi, I want to Sum values from qryWeeklySE_WorkPackEmployee_GroupBy where Activity Date in this query lies between Start and End Date from query qryWeekly_Verified_Report. This is too complex for me. I've tried full day trying lot of different stuff but nothing has worked for me yet...