Search results for query: *

Indeed, the problem was in the Record Source of the parent form... I wonder what I did to upset it... Thanks a lot both of you! One worry less. Kysterathome

Willir, phew... a lot of characters in your code [3eyes] I tried to reconstruct your point, and currently understand what has to be put in the control source, so that the code is read... for the rest I am not sure. Indeed, I forgot to mention one thing: I need to indicate the max amount, but...

Zameer, Now I get: Can't find the field subfrmTransaction you refer to in your expression. But if it works fine with you, there must be a mistake somewhere that I haven't seen. I will keep trying! Thank you for your efforts! Kysterathome

Zameer, it gives me the error message: Compile Error: Method or data Member not found. and .subfrmTransactions is highlighted (in Me.subfrmTransactions.SetFocus ). The name is correct, though. ?

Sorry guys, one more question: If I place the button not in the subform, I tried the following code: Private Sub Command131_Click() Forms!frmIssueEntry!subfrmTransactions.Form!InvestorName.SetFocus DoCmd.RunCommand acCmdSortAscending End Sub However, it doesn't recognise the right...

Hi all, I have a question regarding filtering. The setup: Main form: frmData contains subfrmTransactions (continuous form based on QuerySubfrmTransactions). I would like to have a field in frmData (txtMaximum) that returns the highest record entered in the fields txtOrderAmount in...

I should of course add that I can't even enter the form in Form view because of that error. Kysterathome

Hey all, I am getting an error message in one of my forms: Syntax Error in FROM clause But I am not using any FROM in the VBA of that form at all?! Any idea? Kysterathome

Ahhhh!!!! Am at home now, and now ZmrAbdulla's idea works! Very nice. I think, TheAceMan1: Also, when you try one method, are you removing the one previously tested? was once again the right idea. Thank you all - made my weekend! Kysterathome (now ... and finally ready for breakfast)

VBslammer, that's my biggest fear that there will be a big resistance ... however, I figure, the more userfriendly and the better the reports, the faster the adaptation process. Fingers crossed [upsidedown]

Ha! Of course, I got it.... Just insert DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Before the actual code for the submit button :) Kysterathome

Well, PHV, I thought about that, esp. because at work it says can't read project or Library, or smth like that ... but then I ticked pretty much all of the references, but nothing really changed... also, there are hundreds of references... wouldn't that slow down the loading time, if Access has...

TheAceMan1 Actually, the user has the choice: either he choses a name in the dropdown in frmData, or he uses the frmSearch, which helps the search via a form. The name chosen in frmSearch (chosen among the same names that are in the dropdown list in frmData) will populate the dropdown list in...

KenReay, I tried your idea on After Update, On Enter, On Change, but not working, it still only returns an empty result in frmData. TheAceMan1, my VBA is quite poor still. Where/how do I apply your me.diry=false?

Hi All, How do I automatically save a record after a field has been populated? The situation: I have a lookup btn in my frmData that pops up a frmSearch. Upon double clicking my choice is frmSearch, the last field in frmData (a combo box txtInfo) gets populated with the data I double-clicked...

Right - Data Entry = Yes. Perfect Thanks!

Hi all, I would like to click a control button on frmData that opens up frmEnterNewRecord. However, I would like frmEnterNewRecord to open up with blank fields that I can enter a new record. What code do I have to use and where should I enter it (perhaps in the frmEnterNewRecord at EVENT -...

Hi all, I am working on a rather large project in Access, both at work as well as at home. However, when I take the DB home on weekends, I painfully discover on Mondays that a number of codes don't work anymore (e.g. date, format, Mid). And I am wondering, is that because I have a German MS...

BNPMike and Willir, I have experimented a bit with the subforms and it turns out to be a good solution. Willir, the dropdown option I will use on another occasion. THANK YOU BOTH! Kysterathome

Hi all, I am lost - it seems so simple and yet I don't get it: Two tables: tblContacts ContactID - autonumber (primary key) ContactName City - number [linked to tblCity.CityID - enforcing Ref. Int.] tblCity CityID - autonumber (primary key) CityName The relationship is clear - but here is...