Search results

No it isn't. I am and will remain the only user. I'm developing it for educational reasons, I'm not planning to distribute it.

I've already fully uninstalled and clear reinstalled Office 2010 fully updated. I'm running Windows 7 ultimate 32bit. But all this doesn't make sense. I told you I have the exact same technique, the exact same code, in another Access project with similar structure, running fine for months.

Yes, same thing again. I can't think of anything I haven't already tried.

It seems [sub2013] is a control in subform "frmservices_2013".

I have completely deleted the form and subforms, redesigned them, wrote the code from the very beginning (nothing copy-pasted) and still have the same problem, only this time it asks if I want to send a report to Microsoft. References checked: Visual Basic for Applications Micorsoft Access...

Thank you, I'll try this too...

I'm not sure I really understood this, the file is an accdb file, not an mde neither an accde. However I ran the code line by line and had this result: Private Sub Form_Current() If Me.TabletCategoryID = 1 Then Me.DepositsPage.Visible = True Me.SubFrmDepositTransactions.Enabled = True...

Something like If all_date>Date Then Me.completed.Enabled = False else Me.completed.Enabled = True End if if I'm right.... unchecked, please check it first. Edit OK.....sorry, my bad......forget it....

Ok, I'll come with a stripped version, but it's gonna take some time. However, if I may become more clear : A main form has two subforms. By selecting a record on SformA, I want to display specific data on SformB. So I have an unbound control on Mainform that takes values from SformA and...

Sorry for the interference but, why don't you change the Enabled property of the checkbox depending on the comparison between Date() and [all_date]?

A stripped version of the database is almost impossible, I'll try it though but is gonna take some time. Meanwhile there's the code behind the on currnet event, that seems to cause the problem. Private Sub Form_Current() If Me.TabletCategoryID = 1 Then Me.DepositsPage.Visible = True...

Hi everyone, I have a Main form (MainForm) with two subforms (SFormA, SFormB). These SForms are connected to the MainForm by a control (controlA) and connected to each other by a control (controlB) via an unbound control in the main form, in order to change data in SFormB according to selected...

http://roster.alkhamsa.org/pedigrees/hindex.html maybe?

I used multiple queries because I wanted multiple results from the same tables, depending on multiple (slightly different) criteria, and because I COULD do it in MY CASE. I certainly DO NOT recommend it in your case. And definitely is not a different version issue 'cause I've tried 2010 and...

Well, that's about the case I had here http://www.access-programmers.co.uk/forums/showthread.php?t=272420 and got no solution so far. Thankfully I had the option of using multiple queries. Curious of a solution though. Noticed that you don't use the Is Null expression in your sql code though...

Absolutely right, but I don't thing I'll ever create such a big database needing 100 queries, I'm not a professional, I do this just to learn something. In my case charted results depend on slighlty different parameters and present slightly different outcome, thus making the use of three...

Thanks for your reply. By this time I've changed my aspect of doing things and instead of using a query with three different parameters, I use three queries with one parameter each, more suitable for my case 'cause I want to present results in charts. Advice noted though. Thank you.

Tried everything. I even turned back to Access 2010. Nothing doing. When only one criteria is applied it works fine, when second is applied it goes crazy. After applying the third shows nothing. :(

Thanks for your reply. Well, it seems my machine is haunted. I've tried everything, and had the same results. If I use only a single criteria it works alright, when I put in the second , it gets confused, and when I put in the third, shows nothing no matter what I choose. Sometimes it seems...

Thank you Brian for bringing this up!