Search results

Ya, from all my reading, everyone seems to have the same opinion that access graphs are pretty limited in comparison to excel (which I love using and am quite decent at if I do say so myself :) ). Ya I would do that but this access database setup isnt for my own use specifically. I am making...

Alrighty, I have my graph working correctly now with 1 "site name" being used. I wanted to expand this to allow for multiple "Site Names" though. I thought maybe under criteria for my query which the graph was tied to I could simply change my criteria from...

Ok I think I have it working now :) Well at least the query portion! Which is uplifting seeing as ive been pulling my hair out all day over this ^.^ . Here is what it looks like now. Now to try and work through your explanation about creating a chart :) Ill post an update on the progress...

Ah that make sense sort of. How am I suppose to create a query though to find lets say, Site names or EUTRANCELL names without using a criteria to specify where on the form that data is originating from? I know it's going against what you just said but what if I made 4 individual small queries...

No I didn't inner join them. So if I am using multiple queries together I need to inner join them. Fair enough. Is there a simple way to narrow down which query is causing this to happen. The method I found that produced the fewest number of rows (1866) was using only 1 of those queries and...

I should only have 2 rows of information showing. Not several thousand.

I am trying to go about doing what you suggested however my query I am trying to make which will have all the variables needed keeps outputting incorrectly. The code I have for it looks like this: SELECT QueryMarketNamesWorking.MARKET_DESC, [sah-marsty1-Thu_Jun_12_17_02_37].SITE...

Thank you so much for your reply. I will definately we trying your advice out tomorrow morning. Just about to head out from the office for the day. I will make sure I post a followup message once I have attempted to implement it. Thanks again, -Tyler

Thank you :) I was thinking that might be the way to go but wasn't 100%. I appreciate the help

After working on this for a few days I am stuck and believe I may have been going about this all wrong. I have 1 large database holding various fields etc. Then I was using a form where a user could select specific values from the master database. I was hoping to create various graph outputs...

I decided to try out, Private Sub CheckForAdditionalSites_AfterUpdate() Select Case CheckForAdditonalSites.Value Case 1 Me.NumberOfAdditionalSitesFrame.Enabled = True Case 2 Me.NumberOfAdditionalSitesFrame.Enabled = False End Select End Sub Which seems to accomplish the job. Now though I...

I have an option group with 2 buttons in it, yes and no. It is set to default to No, but if someone hits Yes I want it to enable or turn on the next option group. Would just simply changing visible status disable it? Because I have a series of codes set up based on the second option group which...