Recent content by Junkee Brewster

  1. J

    Subtotal on a form

    Hi Marco, I wanted to make something for no knowledge of VB or macros (except using MS Command Button Wizard to Open forms) What I think you might have: A form showing multiple account numbers. When you click the "Add New" button, a plain old data entry form opens (no links or anything)...
  2. J

    Show Query fields in subform using option groups

    Chrism2 No, it won't work in datasheet view. So, basically, you want your users to use all of those checkboxes to select which fields to view/hide, and then, once they click the "view" button, those multiple fields selected will show/hide? One thing, the problem with this method, is the...
  3. J

    Subtotal on a form

    Hi mtagliaferri Am I to infer that your form is a tabular form, and at any given time, your form has records from multiple account numbers? If the form was only displaying records from ONE account number at a time, I would say to simply put a textbox with the controlsource: =Sum([Amount])...
  4. J

    Using CurrentUser() in a form??

    Hiya iddqd, It won't write to table. If you call CurrentUser() in your form using a calculated field, it only "calculates" for the display of that record on your form (or any "=Expression" on a form for that matter). Make a new field/expression in your query: FieldNameofChoice: =CurrentUser()...
  5. J

    list box open form new Record with the ID in

    Well I'm off the boil tonight.. I see you want to open to DATAENTRY mode. Still use the code I gave for your command button, but what you will need to do: On the form you want to have as the data entry form, make table client details as the form record, and add a text box with Client Number...
  6. J

    list box open form new Record with the ID in

    Click on the List Box in design view. Events Tab>OnClick or On Dbl Click and open a new Sub. Use: DoCmd.OpenForm "YOUR FORM TO OPEN (NAME)", , , "[ClientNumber] = " & Me.YOURLISTBOXNAME, , acWindowNormal Make sure to put in the form to open name, and your listbox name. I personally use...
  7. J

    Show Query fields in subform using option groups

    Hi Chrism2, I've been thinking - I should've showed you how to reveal hidden fields on an existing, VISIBLE subform (because that's what you probably wanted all along! Ah duh Junkee - it's been a long day, what can I say?) So, look at frmSubWithHidden for the example. Same principle as...
  8. J

    Show Query fields in subform using option groups

    Hi Chrism2, I'm not sure if I have understood what you want correctly.. But this method can allow you to display additional/hidden fields or subform(s) from a user mouseclick. Open frmMain. You will see a check/tick box and a command button. Command Button: "Reveals" several new fields...
  9. J

    Automate Specific Cell Extraction from Multiple WkShts (not VLookup)

    Shades, you're a deadset legend. THANKYOU THANKYOU THANKYOU. You have no idea what you've done :D I am now remindeded of 3 important things: 1) Something is not useless because I do not know how to use it properly (teehee) 2) K.I.S.S principle 3) Why Access World Forums is my one and only stop...
  10. J

    Automate Specific Cell Extraction from Multiple WkShts (not VLookup)

    Completely Automate data extraction from specific single cells per worksheet (multiple per book) into a summary column (descending in the same order as the worksheet orders): I am a complete Excel blockhead. Access = fine. VB for Access = fine. Excel = pretty formats and autosums. That is it...
  11. J

    Relationship Woes with Specific Query

    Len, Beautiful. Works a treat. I had slowly been progressing along those lines all evening (after I posted) but was still a bit lost/rusty and feeling every-so-slightly teary. Forest from trees and all that. Thanks very much and have a smashing weekend.
  12. J

    Sum Thread

    OK, my computer has gremlins. Yes, this message is in the right place, to the right user, but before it was displaying a different message (something to do with Decoding Access) under this title of "Sum Thread". Twilight Zone! Soz :)
  13. J

    Sum Thread

    My apologies - this is the second time this has happened to me today - I've gone to post, gotten an error message, had to log back in and noticed that my post has gone to the wrong thread. Very sorry!!!!! Please ignore this reply for this thread :)
  14. J

    Sum Thread

    Hi there, I'm assuming your tables and relationships are set up correctly/similarly.... If you're looking to display this data to a customer, use a form or report. Add a calculated field to the form or report. (note * and # denote child/master fields, this setup would have 3 backend tables...
  15. J

    create a new table from Excel

    You can set up a function using VB and various queries to import Excel/CSV files into existing or new Access tables. However, it isn't a fully automated process. Maybe some VB wizz could code it to execute at runtime, but I don't know how (i've never tried, maybe code for on Load or On Open.. )...
Top Bottom