Search results

i am using some code to export my query to excel to then create a fancy chart, this was a system setup by someone else who has now left the company. the code is below, everything works fine except, i dont get the field headings transfered across, can someone please inform me where and how i...

i have a crosstab query that runs and all works fine except one thing, the months are displayed in the wrong order... they appear like: April, Feb, Jan,Jul, jun, mar, may these are obviously being sorted in alphbetical order, can this be changed to sort by months as they should be cheers...

hi, do you have any examples of how to do this,i am extremley new to cross tabs

i am simply trying to get 2 columns or 2 rows of data like so: example: jan feb mar april Target 2003 2004 23 23 54 23 60 47 34 but not sure how to do this....can it be done,if so how please i have attached a sample DB with a dummy query which is storing...

i have generated a query in Access and now need to chart this data. i have tried to chart this in Access and have had very little joy, so i am looking at using Excel to do the job now unless someone can suggest a way of doing this in Access. my problem: my query generates data as follows...

ok cool, but how would i use just the month and year from the date format ?

i have a table that stores dates, of various types English Dates US Dates DayCodes i now need to add a new column Month and Year i need the data to be displayed as : Jan 04 Feb 04 etc, should i store this in the table or can i extract it as a query? using the current dates

hi, i tried to address this problem some time ago, then swept it under the carpet, but now need to address this issue again. i have a table called: Tbl_Players contains all player info and Tbl_TeamPlayers with team info i have linked them very simply so that i can click on the teams and...

i have been trying to get my head around this, Can someone please clearly explain the difference between: Database Rollback and Database Recovery cheers Andy

Does anyone have any idea when the various versions of access were released, by year would be fine. i need a breakdown of all versions with there release dates if possible please

i am not sure the title of this thread explains mu problem too well. i have a form that has a button on it, when clicked a link to a word document is activated using the followhyperlink option. The word document opens fine but here is my problem, when i close the word document my database has...

Simple.... Thanks Andy

Thanks for that, i am aware about the table issue, i didn't design it and have not had time to modify the table structure so am going to have to live with this one for the time being. What you did was exactly what i am after.... but i now also want to use the category thing to sum the time for...

right i have had a bit of a play with this and am not really getting to far... i have attached my sample db for you to reference. Problem number 1) In my table tbl_Registrations you will see that registrations for 1 & 2 are identical except for the registration number, a player is not...

in my database, we track stoppage on production lines. the stopages a re stored in TblEvents... the numbers under the minor and major categories are in downtime minutes. i need to now how many times an eventcode has happened between a timeframe for example, i need to now how many time code...

thank you milo

is that all i should type in the on load box of the properties window??

hmmm...now i am lost.... this is the code in that module i was on about.. Function Reconnect() Dim ref As Reference Dim db As Database, source As String, path As String Dim dbsource As String, i As Integer, j As Integer Set db = DBEngine.Workspaces(0).Databases(0) For i = Len(db.Name) To 1...

i have a module that is called "Getpath" and want it to be used on my main form when the db opens... i am lead to believe i need to use the on load event but am not sure how to actually call the module, any advise please Andy

hi thanks..... Help needed fast please! (Sorry dont mean to be pushy) i have linked the tables etc together.....but the Set dbs = DBEngine.Workspaces(0).OpenDatabase("\\Tech02\OeeData\oeedata.mdb") is referenced in some of the forms....so by just linking the tables hasn't solved my whole...