Search results

hello, I have a small problem with the graphs. I use a graph in a report which get data from query. I want to use a graph of the type bars to have the name of my fields in vertical and into horizontal the data but I do not manage to manage the labels. I have a label on two, they are not on...

Thanks Travis and Mile-O-Phile for your answer. My question is perhaps stupid but yes i would like view a data sheet from excel to access. is is possible to make this?. Thanks Nilses

Hello, I would like to create a function which counts the number of day between two dates without counting saturdays and Sundays and I would like also a function which counts the number of Saturday between two dates. Could you help me to build these functions? I have another question, my...

Hello, I have a problem with property BackColor. I would like to put the back color (by code VBA and not by the option of formating) according to the value of a field but I do not arrive there in spite of my many test and my research. Could you help me. I have do this like function: ' This...

Hello, I NEED YOUR HELP. I have advanced in my problem but I've a problem on this function. I search the solution since two days :confused: and i didn't find it. This function make the difference between two dates but i use a timetable 09H00-12H00//13H30-17H30. After this i subtract the bank...

Hello, I have a big problem of function. The first part of this function goes perfectly (Thanks Harry) but not the second part (the mine!!). That makes one week that I try to solve my problem but I do not arrive there all alone. I try to subtract on the whole saturdays after midday, Sundays...

Hello, I have make a function (Thanks TIMK From UtterAccess) which make the difference between two dates and which takes only into account a time zone 9H00 - 17H30 and that function perfectly (example if I make the difference between these two hours 8H00 - 20H00, I takes only 9H00 - 17H30)...

Thanks for you help jkokkelmans. I will try your advice Nilses

Hello, I have a basic question but I do not see how to make. In a code VBA, I would like to calculate the number of day between two dates in a variable like this hello = DCount(?) I have a query with a field dateStart and a DateEnd. I would like to count the number of day between these two...

Hello, I need you because I do not find the solution. I would like to count the number of midday between two dates. I have a date of beginning and a date of end. For me the midday is 13:00:00/14:00:00 Here a example of what i want. (year/month/day)...

Thanks Mile-O-Phile Thanks for your help, but it doesn't work. Access display a window and this window wait a parameter, it's strange!! Your help will be appreciated Nilses

Hello I wish to make a function but I do not make it and I require your assistance. I have a query with 76000 recordings and I have a field with a date. I wish when I launch my query to have all recordings of the previous day . We are thuesday on 03/18/03 and i would like the recordings for...

Hello, I have small a problem on my procedure. I have Two listbox, one for the customer and one for the type of machine. When i select the customer, i display the machine for the custommer and when i select most customer, i display the machine for these customers and i remove the doubled. I use...

Hello, I have small problem. I wanted to know when my query was finished. I made a msgbox which posts me a message but what is odd and that when I make ok, it starts again only once my query, I want just simply that it closes the window. Why that done that?. Here end of my request in...

Merci Mile-O-Phile Mon problème et qu'il n'affiche que des zéros comme résultat alors que j'ai un exemple ou j'ai inséré entre deux dates un jour férié. J'ai le sentiment qu'il n'arrive pas à se connecter à la table et à lire le champ. Ma table est bien tblJoursFériés et le nom du champ de ma...

Hello, I need assistance on my function. I try to find the number of bank holiday between two dates and I wish to take into account saturdays and Sunday or only Sunday. What is strange in my function it is that I return only from the zero. I have the impression that it does not arrive at...

Hello I seek a function which could say to me if between two date it there bank holiday by excluding saturdays and Sunday and I seek also a function which could say to me if between two date it there bank holidays by including saturdays and by excluding Sunday. Thank you for your assistance...

Hello, I would like to have of the assistance on this function. This function calculate the bank holiday between two dates. When I insert this line in my query and that I wish to launch my query it posts me a window by indicating to me that it awaits a data to continue and I would like to know...

I'm sorry ColinEssex, After my post, it was most appropriate to me to post my question in VBA forum because my question is a question VBA, I believe. Nilses:(

Hello or Bonjour, I am hoping someone could help me with this problem. I would like to have of the assistance on a function of calculation of difference between two dates. I know that it should be used DiffDate and that in my function I must make this. Function BetweenHours(DateStart as...