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

...But hoping this will bring me some bonus points - right now our department is working with 5 differnet Excel spreadsheets with over 5000 entries each. I believe having one userfriendly interface will make people more comfortable with their work. *wife currently not too happy though* Kysterathome

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...