Search results

  1. J

    Form, subform, combo.. the problem is unclear!

    OK, problems! im right at the very end of my project and all of a sudden this little beauty pops up. Typical! I have 2 days to finish it so would really appreciate any advice or help!! :) ---------------------------------------------------------- Ill start with background info: # The 2 parent...
  2. J

    using a text box to find a record number

    I've got a text box and have it set it so that it shows the record number the form is currently on. This is the code: =[Form].[CurrentRecord] in the ControlSource. I was wondering if it would be possible to allow the user to type in the record number they want in this text box? I dont mind...
  3. J

    Code to open a Wordpad file from a button?

    Does anyone know the code for opening a specific notepad file from a button? I know there's a default button but it only opens a blank notepad page. I need to open some written instructions from a button you see. Thanks.
  4. J

    combo box used for record search - results dependent on 2 key fields

    Hello, Im posting in need of some advice! I've used combo boxes as search tools on forms before with no problems. This being you select a record from the drop down (usually by the key) and subsequent text boxes and subforms update appropriately. THEN THE PROBLEMS BEGAN! :eek: I have a table...
  5. J

    Switchboards- Different things on different pages?

    This is the first time ive used the switchboard so hopefully this will be just a quicky! Bascially i have a main switchboard which has 3 buttons. These buttons all link to different switchboard pages. THE PROBLEM :- I have labels on the main switchboard and these are all appearing on the...
  6. J

    Enforcing Referential Integrity

    Basically, I want to use this ^ . I have a load of tables with primary key fields and then a table with just the appropriate foreign keys (we'll call this the f table). I have all the table links set up to Enforce Referential Integrity. When I import the data i need into the f table a warning...
  7. J

    Combo Box updating Subform. HELP!!!

    Hello, Im pretty new to all this so apologies if this is very simple..! Basically, I have a form which simply has Username (in a combo box) Surname (in a text box) and First Name (in a text box). I used this code in the after update field of the combo box: Private Sub Combo6_AfterUpdate()...
  8. J

    questions.. please help!!

    Hello, im just starting out with access so apologies if my question is embarassingly basic! Q Im creating a form which consists of user name, first name and surname (all of this data is in a table called staff). In the form, I've made the user name a combo box so that you can choose the correct...
Back
Top Bottom