Search results

Got it, thanks for the help

Do you mean, create a query with the two tables and link the 2 tables by the ID and the Name?

I have 3 tables. One table has a whole load of data: (table 1) date, name, company name, building Name, etc I have one other table which holds company names (table 2) I have one other table which holds Building Names (table 3) The main table is linked to the other tables so in the company...

I realise this was 2 years ago...lol...but i just had the same problem and fixed it. the answer to this problem is: change the properties of the chart to enabled = yes, locked = yes done

Thanks, look forward to the info.

Many Thanks for your information, thats just the info i was looking to hear. I suspected i would have to use an exported documented to import data into access. Some more information would be greatly appreciated, such as Hardware and Software needed. Many Thanks

Many Thanks for your information, thats just the info i was looking to hear. I suspected i would have to use an exported documented to import data into access.

Wondering if anybody has any information about this. Backgound information: My access database information comes from a 'card' where somebody has manually put crosses in a number of boxes. This information is currently being manually inputted into the database... I know you can get scanners to...

I have a statement which is driving me nuts...i'm a beginner with using SQL: Private Sub Command45_Click() Me.Graph0.RowSource = "SELECT (Format([Date],""" """mmm""" ''yy')) AS Expr1 FROM Chart_Unsafe_Daily GROUP BY (Format([Date],'mmm'' '''yy")), (Year([Date])*12+Month([Date])-1); End Sub...

Thanks for the reply, i'm not sure what you mean however. Would it be possible instead to have: The form with the generated line graph (with 7 lines a, b, c, d, e, f, g) And 7 buttons below the graph labeled a b c d e f g my idea is that by pressing button 'a'; the line 'a' in the graph will...

I have a report with has a graph. I also have a form which has two date entry fields, date to: and date from: These two dates are used to display all the groups of data which lies between the two dates. in more detail: What i have just now, correctly shows all the data which lies between the...

Thanks for your help, i will use that technique. :)

I am not using an option group, i am using 2 single option buttons. I have just tested the option group and i can indeed set the default value to "1", however you can only give the value "1" to a single option in the group. I still want to have the Value "1" given to each option which is...

Hi there, I have a problem where the option buttons within a form are creating a "-1" in the Table instead of a "+1" The reason this is a problem is because i am using a COUNT query which obviously gives me a negative total, such as "-23" instead of "+23" I would really like the option...