Search results

Hi Mr. B, thank you for helping me... i am attaching the sample DB of what i have done so far.. maybe this will help you in understanding what the issue is? in the end i want to store the hrs in the Main table (TblMain and FrmMain), but in order to do so i need to first figure out what the...

Hi Mr. B, so the table has the ckeckboxes, and my sub form basically has all those fields including the checkbox. So if the checkbox is clicked its acutally ckicked in the table...does that make sense? and the textbox is on the main form where it calculates the sum using the dsum function... but...

can someone please help?

me.refreash under both forms does not work.. please help!

its actually working but i have to keep closing the table and then reopening it... so what i did was added my main table as a subform on my form with the DSUM textbox. But how do i make it current so that when the checkbox is clicked it updates the text box? right now i have to close the form...

ok here is another thought... what if i put a checkbox on the table itself and say now calculate or sum up the numbers if the checkbox is clicked? would that work? i saw this great tutorial on the following website but for somereason if i click more then one checkbox its still not adding up...

that did not work either.. any other suggestions on how to display the "Sum" results on a form?

can someone please help? is there a way to display totals of the query on a form? see my layout in the above post.. maybe i need to change it entirely?

Hi vbaInet, to answer your questions 1. yes and yes 2. yes 3. record source is a temp query that i created off of my main table where i run each query to get the reuslts. But this query returns no results so that when the form loads its blank... hope that makes sense So here is how it works...

yeah i have done that already but was wondering if there was a diffrent way to do it in the code... but any who thank you sooooo much for your help!

THANK YOU! ok if i remove the record set it gives a value of "#Name?", which is not pretty. Is there a way to blank out the text box so it looks normal? I was thinking to create a query with no results and add that as the Record set of the form this way its blank at all times but is there a way...

thank you Mr. B! this was real helpful. One question, is there a way to blank out the text boxes as the beginnig or is that not possible?

yes sure.. sorry i shoul dhave done that earlier... ok so yes my queries return values that need to populate in each text box. So value 1 will populate txtbox1, value2 in query will populate txtbox2 and so on... does that help?

Hello, i have a question regarding checkboxes, is it possible to load textbox values when a checkbox is clicked? For example i have 2 checkboxes, if chbox1 is clicked i want to run qry1 and load txtbox1, txtbox2, txtbox3, if chkbox 2 is clicked i want to run qry2 and load txtbox1, txtbox2...

now i am getting a different error after i adjusted the code a little it bombs at the line below stating "Run time error '75' Path/File access error" Dim strSQL As String Dim hCarrier As String, hDate As String Dim Elapsed As Variant, zTimer As Long, eMin As String, eSec As String Dim zImport...

right but i am basically asking it to go there and get a file no?

just giving a name so i dont have to keep writing in docmd, i would be using many of the docmd as the file will be imported many times in different tables.. does that help?

Hello, this use to work perfectly until i went from 2007 to 2003... basically few of my users need to use this DB in 2003 but they were getting an error, when i did some research i fixed few things but now i am stuck here.. can someone please assist? error - run time error 3207 can not update...

never mind i had the input value in correct. thank you sooo much!

thank you! Ok so I went to name manager and extended the cells to go to the following ='Test'!$E$3:$G$65536 but for some reason it still wont populate the X's... it did before (up to G6) when the value in name manager was ='Test'!$E$3:$G$6... but it went to G6 so i changed the value since it...