Recent content by douginiraq

I have a need to track the amount of chlorine we use daily. I have generated a table and form to collect the data and a generic report to display the collected data. What I am struggling with is as follows: As the chlorine cylinders empty their respective weights decrease. Then they reach...

ok, cool, I'll try and figure out what you did so I can educate my self. Thanks!

I am now, i would think that it would be a simple format box on the form properties I was not seeing..

I dont mind it being to tall but is there any way to have it default to the top of the form?

I'll do one better, here is a copy in 2007 format. Cheers! Doug

I have a Form called MDCF in the db. When the form is opened the form is slightly scrolled down and the tabs are not visible. I have tried numerous format options all with no effect on the start position of the form on open... Any ideas on how to get the default so the form tabs are always...

Will do, I am glad I registered for this Forum!

You must make someone very happy with your skills :) I was in bed (it's 0230 here) and I was thinking about the "pumpID" and it dawned on me what you were talking about. But the code you wrote is way above my current level! Thank you Zen Master! Where do I send the check?

Each pump has it's own table so not sure about the pumpID field mentioned. Keep in mind I am kind of a noob for Access and am learning as I go. I uploaded a 2003 version for your reference.

Each of the tables that stores the date/time has a primary key of "ID". I am at 2.8MB or I would upload.... I deleted a couple of tables and the switchboard from a copy of the DB.

I modified my post...to include your question.

Each piece of data is a new record so I can total the total amount of run time for a given date range.. The code below I just tried as a baseline... I am getting a debug erro loading the form at the StopDateTime.. Private Sub Form_Open(Cancel As Integer) Dim IAB_WATER_TEST_DB As...

Thank you. Is that something I have to do on the form or for each sub-form. I think each sub-form, but I am new enough I don't want to waste to much time experimenting. Cheers! Doug

I have a Unbound Form with 4 bound sub-forms. Each of the sub forms is identical in function. See the code below: frmP4RT -------------------------- Private Sub btnStart4_Click() Me.btnStop4.Enabled = True Dim IAB_WATER_TEST_DB As DAO.Database Dim tblP4RT As DAO.Recordset...