Search results

hi, thanks but you lost me, any further help would be much appreciated... any freelancers might wanna considered a price...i need to sort this.. cheers Andy

I am trying to design a form which will provide my users multiple reporting options using the same query. my query contains the following fields: Daycode WeekNumber PeriodNumber Line Machine Eventcode TotalTime Occur Avg i want the user to choose in this order : a time period to run the...

I have designed a report in Access, which i am happy with, one of the next requirements it to Analyze it in excel... is there a way to do the following : automatically export the report into excel without having to click the button on the toolbar, example: click button on my form to run the...

i have a table called : Tbl_Production in here is a field called : PlannedTime i also have a report that i want to put a textbox on to display the data in the table, the planned time is seperated by Date and by production line example 1/1/01 ---- 1440 minutes ----- line 6 2/2/01 ---- 1380...

cheers Andy

we have about 60 users at the mo... should i just set up the table in Sql server then link to them...and right all the queries etc.. in Access ? is Sql server any quicker ?

Hi, i am looking at making use of SQL Server which we have at work to run our access Database from, is this a good idea ? what are the benifits, problems etc... Andy

cheers Andy

hi, thanks, but i have just tried the FAQ and entered cascading combo boxes and i got a sorry nothing found message, and tips to what i should search for ?

i have a subform called Tbl_Trainingsubform on here i have two combo boxes which i am trying to setup as casacading...i believe this is how they are referred to anyway. combo box 1 is called cbosection the other is called cboactivity i have a table called tbl_training which has the following...

Hi, i have been working on this project for months now and am getting nowhere very fast... is there anyone that can please help me sort this out... I have one week before i need to start logging this data, yet i am so lost... i have got a db that i believe captures data of registered players...

in my report called Factory Model, i have a number of subreports. the 2 i am concentrating on are: Report.factorymodel_ReportVAT subreport and Report.FactoryModel_CIP subreport in the Report.FactoryModel_CIP subreport i have to perform a calculation that includes a value from...

i have a form called frm_Unaccounted on this form i have a combo box called cboLine in my query i have entered the following hoping that it will use the criteria from the form [Forms]![frm_Unaccounted]![cboLine] i have the form open, and set it to a specific line then run the query but i keep...

i have a table of code that are similar to this: A101 A101A A101B A101C A102 A102A A102B A102C and so on... the problem i have is that in my drop down box the codes with the letters after them are always at the topof the list... like so: A101A A101B A101C A101 ----->(this has moved) A102A...

milo, it must hurt to be that dam good... cheers

Hi, i am sure this has been addressed hundreds of times, but i have had a look around and cant seem to get to the answer i am looking for: Problem: I have a query that calculates total time dived by the number of occurances. the trouble i am having is that when there are a recurring decimal...

i have to convert, minutes into hours and minutes,to work out average stops per stoppage. how can i do this please. i have tried dividing my minute by 60 but then get silly answers: example 416 minutes divided by 60 = 6.9333333 hours but really this is 6 hours and 56 mins how can i get the...

ok cool, i understand......i will have a play and see what i come up with Andy

cheers, that was really helpful....i think i get you, have you got any examples ?

one or two of my queries seem to take a while to complete, so i was hoping to use some kind of progress bar to highlight how much of the query has completed. i have searched through the forums to try and find a very simple guide to using the progress bar that is built in access activex control...