Search:

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

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

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

Hi,
ran into some confusion with my table relationship so attached is a picture and heres an explanation of what is intended to happen.

currently I have 4 tables

Proposal table is what starts...

Thank you for your reply!

Hi Lounge, As I am slowly learning how to make a database a few things I need to clear up with tables since its the most important part of how the database works.

I see tables as having a few...

Hi lounge, I am trying to format a time (3/6/2008 12:46:00 PM) and would like to only get the the time in mm:ss instead of mm/day/yyyy hh:mm:ss PM, is there a easy way of doing this?

Hi Lounge,

Just wondering if and one has problems with the scatter plot when you are tryin to plot about 30,000 points, My graph seems to bogg excel down if I try to format the scals ect. If so...

Hi Lounge,

I am having trouble making a query which will provide me with a summary of monthly sales for each store.

What want to do is list the total sales for each store by month. I only get...

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

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

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

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

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

Another issue I seem to be having is with my code stopping on Me.cboCompanyRep.RowSource = "SELECT Company Rep FROM" & _
" tblContact WHERE Company = " & _
...

Thank you for the link.
I added the SELECT [tblContact].ID, [tblContact].Company FROM tblContact ORDER BY [Company]; statment to combo box cboCompany and when the form is ran it shows the primary...

What I am exactly after is setting the row source to a table, called customer and I query all in the field called Company. The next combo box is where I am having trouble. I would like to query...

ok thanks I will try this

was wondering if anyone has experience with reading a text file (csv format) and displaying the values of each section , , seperately to a textbox. If so please share a way to do this? I currently...

I am developing a user form on a access data base and would like to to have a combo box with a list of things to be picked. I can set the list up with in the properties, but I was wondering how I...