Search results for query: *

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

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

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

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

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

Hi All, I am looking for a solution for a lookup funtion and hope s.o. has an idea. What I got: A main form with meetings (frmMeetings) A subform with Attendees (subfrmAttendees) - a continuous Form that has buttons next to each name entry, one of which is Cmd Button NameLookup that launches...

Hi all, I have received this search form from a very nice user http://homepages.bamboo.lu/kyster/searchdb.zip but I have two questions about it: 1. I would like the columns in the results list box to be bigger to reflect the size of the results - what code do I add? 2. What code do I add...

Hey all, I am stuck: I have a form with contact details (maximised) and a search contact button. When I click the srch button, the frmSearch should pop up (in the center, over the contact details form) - I currently do this with a command button that runs a macro "openForm" ... but sometimes it...

Hi guys, Probably a simple thing, but my lid'l brain is lost: Setup: Two tables: Table A with many names that feed (with dropdown) from Table B where the names are the primary key (I have of course related the two tables). Problem: In a form I want the user to use a dropdown when entering...