Search results

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

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

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

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

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

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

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

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

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

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

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.

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 :)

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 :)

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

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

I have a pretty standard relationship set up, with the following tables: Customers: A row/Cust ID for each customer WorkOrders: each customer can have multiple work orders (linked to Customers by CustID, individual ID is WOID) Jobs: each work order can have multiple job records attached...

Hi guys, I need to tailor a HTML template for exporting static data from Access. I'm familiar with the generic template as outlined in Help (which, as usual, is about as useful as a kick in the head), problem is, my template has multiple small tables and various other design attributes (and I...

Rich, There are 7 different TestPeriods (years) 0, 0.5, 1, 2, 3, 5, 10, stored corresponding to the tool type, on TblToolGroups, displayed on Main Form, FrmTools. On the subform (TblTools) there is only one field "ReTest" that needs to hold the calculated dates contingent on the different...

Sure Mik, I'd love to see your progress. Some ideas about dealing with lots of fields. You could mean that your tables now have lots of fields (going horizontally across your form), or you could mean that because you've entered so much data, your form display data is growing longer and longer...

RG, The fields LastTest and ReTest are both in the underlying Query. The user inputs data in LastTest, but VB will (hopefully) update ReTest. txtTestPeriod is problematic - I've got it set on the subform by referring to the main form: =Forms!MainFrm!TestPeriod. I cannot seem to get the...