Replies

You need to Convert the answer to a fraction of a Day in order to use a time format

So if A2 contains the Volume and B2 contains the Rate then the formula for the time
to use an mm:ss time format is =((A2/B2)/60)/24

For example If Vol =1000 and Rate = 45.6 this give 21.93 as a decimal min
which is 21:56 converted to a time where 21.93 min = 0.015229 Days

WORKS GREAT THANKS!

Well thanks steve! big help here x-y plot it is

Cheers

yes, do anything special?

updated the attachment, i hope this works

Hi Lounge,

Has anyone got a solution for dealling with graphing data on multiple time scales?

I have 3 different sets of data recorded over time different color for each set…attached.

I am tring to plot the rate colume for each set comparing against the flowtime, but as you will see the sample time steps are takin at different intervals, which is a problem because the chart only wants one X axis.. Any way to make this work over one?

ok, did that now when entering data in my form as soon as I enter data that relates to a different table I get an error at the bottom of the screen saying “Cannot add record(s); join key of table ‘tblWell’ not in recordset. Any idea what I need to do to fix this?

thanks,
off topic a bit but when making the form, I would like to have a subform for tblReservoir data in a table format so that I can add multiple entrys

Will in tblProposal after I enter in a OrderID a plus + appears and when I click that tblWell appears an if I enter a WellID tblResevoir appears. I may have some setting activated

Thank you for your reply!

Thanks

Ok thank-you. So I have setup my Tables this way. as for the SQL statment behind combobox1:
Option Compare Database

Private Sub cboCompany_AfterUpdate()
‘ Update the row source of the cboProducts combo box
‘ when the user makes a selection in the cboCategories
‘ combo box.
Me.cboCompanyRep.RowSource = “SELECT [Company Rep] FROM” & _
” tblContact WHERE CompanyID = ” & _
Me.cboCompany & _
” ORDER BY [Company Rep]”

Me.cboCompanyRep = Me.cboCompanyRep.ItemData(0)
End Sub

This doesnt seem to work anysuggestions?

Ok so what I gather from this is I need another Table called Company that lists the Company Names individually.
I can then have a relationship with tblContact for getting the Companys information
Correct?

Sure,
What I have setup is Two Tables,
tblContact
tblRequest_Contact

tblContact Is a table that Stores customer details ex. Company, Company Rep, Street Address ect. for lists

TblRequest_Contact is a table that will store jobs.

I have created a Job fill out form that so far has 2 comboboxes and a text box.
Combobox 1 is for picking a Company, which I want connect to the tblContact Company field to get a list and only List the unique companys so no multiples. The use will pick a company from the list and populate the Company field in tblRequest_Contact (Currently I have this working)
Combobox2 is a Company Rep, Which I want to syncronize with the company combobox, so which ever company is picked then the list will show only customer reps belonging to the Company pick in the combobox list. I believe a query is needed that looks at the Combobox1 value and select only company reps that belong to that company.
The Textbox is for An Address which again is a query, that reports multiple fields from the tblContact
Street Address, Postal Code, Province, Country

I think my problem is when following the instructions on the MSDN link you have attached to the post. I do not know how to do the step:

An Access 2007 database exists which contains two tables, tblCategories and tblProducts. The Category field in tblProducts is a lookup column that is linked to the Category field in the tblCategories table.

Does this matter?

Thank you for the tip. I am almost of fto the races having the event procedure not stop on anything.

although nothing is showing up in the 2nd combobox I goto the vb scipt editor an stop the code to view the varibles and it seems to be grabbing the primay key value from the first combobox pick?