Search results

I have similar problem, but I noticed same pattern like selvsagt explained. After small change application goes crazy. Sometimes everything is working well until I make .accde, and only on .accde I got errors like "the expression OnLoad/OnEvent/OnTimer you entered as the event property...", but...

Me.Form!ID is working. Thank you again!

Yes I have. In post #3 you can see that first field is ID

I have one more question that is not exactly related to this topic. Maybe you noticed, that in my query I have: SELECT ..., ..., ..., "Open" AS [Open], "Copy" AS Copy, "Delete" AS [Delete], ..., And when I try to Open, Copy or Delete some element of datasheet view, I have to get ID of that...

It worked. Thank you a lot!

I'll try to do that. Thank you. I'll inform you whether is working or not.

Actually I did specify them. I never used SELECT * when setting Record Source. This is one of my Record Sources: SELECT tblProjects.ID, tblProjects.ProjectName, tblProjects.InternalStatus, tblProjects.ProjectType, tblProjects.Author, tblProjects.CustomerName, "Open" AS [Open], "Copy" AS Copy...

I suppose that Aaron5714 find some workaround solution to this problem. Searching for a solution for same or similar problem I bumped on this post, and decided to ask if maybe someone know is it somehow possible to solve this kind of a problem. In my application I have a lot of datasheet...

I managed to do this a little bit different. On ApplyFilter I form and run sql query. When user clicks on sort in OrderBy I get which column needs to be sorted and how (asc or des), and concatenate that on my default query in ORDER BY clause. Thank you all for your help.

After a lot of debugging I came to next conclusion. Code in my previous post is correct but access sort comes after ApplyFilter code and override my sort, but I'm not sure that this is correct assumption. So CJ_Londons suggestion will probably work. I'll try it later today.

Yes I'm aware of that. I checked names, that shouldn't be a problem.

Thank you all for your help. I ' am trying to implement vbaInets suggestion, but I'm having problem with OrderBy. My code: Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer) Me.OrderBy = "[frm].[col1], [frm].[col2] " Me.OrderByOn = True EndSub This code doesn't...

Exactly. I would like to add any other sort to my initial sort (but my initial sort must have highest priority). Something like this: Initial sort | Added sort 1 | 1 1 | 2 1 | 3 2 | 1 2...

Hello everyone. I have a form presented in datasheet layout. I set the initial sort by two columns, but I would like to keep highest priority for that initial sort, so when user wants to sort by some other columns that sort happens inside my initial sort. Regards, bikcina!

Hi people. I am new to programming in Access. I am familiar with other program languages (C/C++, C#, Java...) but Access (and VBA) is different. So I am here to learn. bikcina